[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1118
  • Last Modified:

Link Server Pervasive 11 64 bit to Sql Server 2008 32 bit

I've 2 servers Windows Server 2008 64 bit. In the first is installed Pervasive 11 64 bit in the other one is installed Sql Server 2008 32 bit. I've to create in the second one a linked server to a Pervasive database. I've tried using native Pervasive provider 32 and 64 bit and doesn't work. I've tried with OLE DB Connection for ODBC and nothing. I've the doubt can depend of 32 bit version of Sql Server. I've to install 64 bit version?
0
fantamen
Asked:
fantamen
  • 6
  • 2
1 Solution
 
mirtheilCommented:
What behavior are you seeing?  You say it doesn't work.  Does it give an error?  On the SQL Server machine, you will need to install the PSQL 32 bit client.  You can create an ODBC DSN on that machine pointing to the remote PSQL 64 bit server.  Once the DSN is created, you should be able to create the linked server.  If you can't, post the steps you are taking and any errors or messages you get.
0
 
fantamenAuthor Commented:
Mirtheil thanks a lot for the answer. I've made more times what you suggest me. The ODBC DSN creation and test from ODBC windows was succesfull but the link, using that ODBC DSN, in Sql Server failed. Tomorrow morning I'll send you the string error returned.
0
 
Ryan McCauleyCommented:
If you're creating an ODBC connection that you're accessing from a 32-bit version of SQL Server (installed on an x64 server), make sure you're using the 32 bit version of the ODBC configuration utility:

%WINDIR%\SysWOW64\odbcad32.exe

The x86 and x64 version of the ODBC configuration tool look identical, but the connections they set up can only be accessed from x86 and x64 applications (respectively) - since you're using an x86 installation of SQL Server, you'll need to have the x86 Pervasive driver installed and use the x86 ODBC panel to set up the connection - then the linked server should work from inside your SQL Server.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
fantamenAuthor Commented:
Yes I'm using the 32 bit ver of odbc conf. Utility...
0
 
fantamenAuthor Commented:
The error returnet is: Specified driver could not be loaded due to system error  998 (Pervasive ODBC Client Interface).". (.Net SqlClient Data Provider)
0
 
fantamenAuthor Commented:
After some tests I've noted this: installing new sql server instance 64 bit in another server linked servers starts, removing, in the trouble server, 32 bit instance and reinstalling 64 bit the error was the same mentioned in last message. Probably the error depend from a corrupted registry key but I don't know which is...
0
 
mirtheilCommented:
Turn off DEP for the PSQL engine and client components.  I've seen DEP cause the system error 998.  
http://windows.microsoft.com/en-US/windows7/Change-Data-Execution-Prevention-settings
0
 
fantamenAuthor Commented:
I've solved removing 32 bit version of Sql Server 2008 and installing 64 bit version. Native Pervasive driver doesn't appear in sql providers list so I use an OLEDB for ODBC.
0
 
fantamenAuthor Commented:
I've solved myself.
I appreciate the collaboration.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now