INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

RE: Linked Server to Pervasive 8.6.192.30

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

RE: Linked Server to Pervasive 8.6.192.30

(OP)
Thanks, Mirtheil...I appreciate it...

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

Maria

RE: Linked Server to Pervasive 8.6.192.30

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

RE: Linked Server to Pervasive 8.6.192.30

(OP)
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

RE: Linked Server to Pervasive 8.6.192.30

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

RE: Linked Server to Pervasive 8.6.192.30

(OP)
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.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close