Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2006
    Posts
    4

    Unanswered: 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!

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.

  3. #3
    Join Date
    Feb 2006
    Posts
    4
    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?

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    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.

  5. #5
    Join Date
    Feb 2006
    Posts
    4
    Thanks again!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •