The build number is 11.0.0.676Regards,Graeme

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

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'
           , @srvproduct=N'Paradox7'
           , @provider=N'Microsoft.ACE.OLEDB.12.0'
           , @datasrc=N'C:\MYPARADOXDBDIR'
           , @provstr=N'Paradox 7.x'

EXEC sp_addlinkedsrvl...

Sorry - that second SP in SQL Server we are passing as:EXEC sp_addlinkedsrvlogin MyPDOX, FALSE, NULL, Admin, <Password>

Posted to MB Topic: Paradox to/from Other Data Sources « Paradox Board