Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Server to Pervasive 8.6.192.30

Status
Not open for further replies.
Maria01

Maria01

Programmer
Joined
Apr 27, 2010
Messages
4
Location
US
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...
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Thanks, Mirtheil...I appreciate it...

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

Maria
 
Upvote 0 Downvote
Any updates on this??? I would love to know how you got this to work???
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ianbtheog
  • Locked
  • Question Question
Connection Manager is not running at the specified port number - Pervasive 13.31.014 - Intermittent
Replies
2
Views
835
ianbtheog
ianbtheog
dgillz
  • Locked
  • Question Question
DDF Builder for Actian fka Pervasive SQL
Replies
3
Views
830
mirtheil
mirtheil
profoundhypnotic
  • Locked
  • Question Question
How to read a csv file in Pervasive?
Replies
1
Views
873
mirtheil
mirtheil
dgillz
  • Locked
  • Question Question
How to Execute Create View code in Actian Zen?
Replies
1
Views
782
mirtheil
mirtheil
michellepace
  • Locked
  • Question Question
Source control for pervasive? (git)
Replies
1
Views
541
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top