If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > MS SQL Linked Server to Pervasive v10

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-16-11, 16:49
greg28818 greg28818 is offline
Registered User
 
Join Date: Feb 2006
Posts: 3
MS SQL Linked Server to Pervasive v10

Can anyone tell me how/if a linked server can me made from MS SQL 2008 to Pervasive 10? I am doing it throught MS SQL Server Management Studio. Thank you for any help!
Reply With Quote
  #2 (permalink)  
Old 03-16-11, 22:01
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
Is MS SQL 2008 running as 64 bit or 32 bit? If it's 32 bit, you should be able to create a PSQL ODBC DSN, then add the linked server by calling sp_addlinkedserver. Here's an example:
sp_addlinkedserver 'PSQLDEMODATAODBC', ' ', 'MSDASQL', 'DEMODATA'
where PSQLDEMODATAODBC is the linked server name, "MSDAQL" is the provider name, and "DEMODTA" is the PSQL ODBC DSN you created to point to the PSQL data.

Now, the above is for 32 bit. If you are using 64 bit, you'll need a 64 bit PSQL ODBC driver which is only available in PSQL v11. PSQL v10 has a 64 bit Btrieve engine but only 32 bit ODBC drivers.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #3 (permalink)  
Old 03-17-11, 09:13
greg28818 greg28818 is offline
Registered User
 
Join Date: Feb 2006
Posts: 3
Yes 32bit. That did the trick. Thanks for your help!

Is it possible to make a Linked Server using the Provider: Pervasive.SQL OLE DB Provider or Pervasive.SQL V9 OLE DB Provider?
Reply With Quote
  #4 (permalink)  
Old 03-17-11, 09:32
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
I've had mixed luck with the Pervasive OLEDB provider and linked servers. I normally stick with the ODBC driver.
__________________
Mirtheil Software
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development
http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
Reply With Quote
  #5 (permalink)  
Old 03-17-11, 10:13
greg28818 greg28818 is offline
Registered User
 
Join Date: Feb 2006
Posts: 3
Thanks again!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On