| Password Encrypted Tables Into SQL Server|
Hi,We're trying to access some legacy data in a Paradox 7 database. We've set up the the Paradox database as a linked server in SQL Server 2008 Express and can see the tables, but whenever we try to run a query against the database, we're getting an error: "Could not decrypt file."We know the database is encrypted and have the password. The problem is we have no idea where to use it.We have BDE 5.202 and the Microsoft ACE drivers installed, and are creating the linked server by calls to the following stored procedures in SQL Server:EXEC master.dbo.sp_addlinkedserver @server = N'MyPDOX'
, @provstr=N'Paradox 7.x'