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

    Unanswered: Create a linked server 2008 SQL Express to Pervasive

    I installed 64bit version of SQL Express and I initially installed Pervasive 10.0. Did not see Pervasive show up a provider, in MS Visual Studio, when trying to create a linked server. I downloaded a copy of Pervasive 11 which has 64bit ODBC drivers, thinking that was the problem. I installed v11 and still do not see Pervasive listed as a Provider. Any ideas on what I am doing wrong? Thanks for any help.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    If you want to use the Pervasive provider,you'll need to download and install the Pervasive ADO.NET SDK (in the Software Development Kit section at Pervasive® PSQL).
    You should be able to add the linked server pointing to an ODBC DSN though. You'll need to use the "MSDASQL" or "Microsoft ODBC Datasource" as the provider.
    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.

Posting Permissions

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