Create MSSQL Linked Server to Paradox

[miller2300]

I'm trying to create a Linked Server in MSSQL to a remote Paradox 10 database using an OLEDB for ODBC connection.

The error message I am getting when running a query in Query Analyzer (select * from openquery(myDatasource, 'Select * from MyTable') is:

**** Error Start ****
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [DataDirect][ODBC Paradox driver] Cannot open file: K:\MyDir\MyTable.DB]
[OLE/DB provider returned message: [DataDirect][ODBC Paradox driver] [Paradox]Network initialization failed.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare:repare returned 0x80004005: ].
**** Error End ****

I've recieved similar error (Network Initialization failed), when trying to connect using other methods such as Access, some JDBC stuff, etc. This is not isolated to MSSQL.

 

[jartman]

The ODBC driver will not work with remote database files, not even on mapped network drives. You have to create the ODBC data source on the same machine where the paradox data files are, and that means it also has to be the same machine that runs MSSQL.

I'm not very experienced with MSSQL, and I haven't heard of a "linked server". Maybe you can run a second copy of MSSQL (or just MSDE) on the remote machine and then link to that?

 

[miller2300]

Thanks for your reply jartman.

I am using a Paradox driver from Data Direct, not the default Microsoft Paradox driver.

I have a working connection to the remote Paradox driver through a local Access Database using the Data Direct driver. I am trying to set up a linked server in SQL Server to the remote paradox database using the Data Direct driver.