Linked Server to Pervasive 8.6.192.30

[Maria01]

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...

 

[mirtheil]

If the SQL Server is running as a 64bit application and can access a 32 bit ODBC driver, you should be able to do it. In my experience, 64 bit apps cannot access 32 bit drivers. If SQL Server is running only as a 32 bit application, it should be fine.

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

 

[Maria01]

Thanks, Mirtheil...I appreciate it...

I'll let you know how it goes with the linked server setup tomorrow.

Maria

 

[skeeziix]

Any updates on this??? I would love to know how you got this to work???

 

[Maria01]

Hi,

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

 

[mirtheil]

You might want to take a look at PSQL v11. It's currently in Beta but there is now a 64 bit ODBC driver. Once you've got the 64 bit ODBC driver, you can create a linked server using MSSQL.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[Maria01]

That would be great, but they have no plans on upgrading the pervasive db - they simply need to have the ability to pull the historical data from the old system into the new one.