Linked Server to Pervasive 8.6.192.30
Linked Server to Pervasive 8.6.192.30
(OP)
Hi,
I need to create a linked server from sql server 2005 to a pervasive 8.1 database. The Sql server is lying on a 64-bit machine, but the pervasive db is on a 32-bit machine. I have read a couple of posts within this forum that said you can accomplish this by creating a dsn on the sql box and installing the correct ODBC drivers - in my case, W3ODBCCI.DLL AND W3ODBCEI.DLL. Is this the best way or only way to do this? Also, will the different machines, 64 and 32 cause an issue?
Thanks...
I need to create a linked server from sql server 2005 to a pervasive 8.1 database. The Sql server is lying on a 64-bit machine, but the pervasive db is on a 32-bit machine. I have read a couple of posts within this forum that said you can accomplish this by creating a dsn on the sql box and installing the correct ODBC drivers - in my case, W3ODBCCI.DLL AND W3ODBCEI.DLL. Is this the best way or only way to do this? Also, will the different machines, 64 and 32 cause an issue?
Thanks...
RE: Linked Server to Pervasive 8.6.192.30
Those files are the correct files for the Client (W3ODBCCI.DLL) and Engine (W3ODBCEI.DLL) drivers but you need more than just those two DLLs. You need the full PSQL Client install (unless you are accessing the data on the same server). Once the client is installed on the machine running SQL Server, you should have the option to create a Client Interface DSN. You would point it to the remote server running PSQL Server that has an Engine Interface DSN pointing to the application DDFs / data files.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Linked Server to Pervasive 8.6.192.30
I'll let you know how it goes with the linked server setup tomorrow.
Maria
RE: Linked Server to Pervasive 8.6.192.30
RE: Linked Server to Pervasive 8.6.192.30
We had an issue connecting to a 64 bit server from a 32 bit server. We are now looking into alternatives - converting the pervasive db to a sql db.
Maria
RE: Linked Server to Pervasive 8.6.192.30
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Linked Server to Pervasive 8.6.192.30