Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Exclamation Unanswered: Pervasive - SQL Server (Linked Server)

    I've created and ODBC Connection to an old BTreive database using the "Pervasive ODBC Engine Interface" driver. I purchased the Pervasive Workgroup Engine to connect.

    Thereafter I create a Linked Server in SQL Server using the following information (this was mostly guess work, but the tables do get listed after the connection) ;

    Product Name: Pervasive ODBC Client Interface
    Data Source: <DSN Created as mentioned above>
    Provider String: MSDASQL
    Location: <blank>
    Catalog: <blank>

    When I run the query below:
    select * from openquery(<LINKED_SERVER_NAME>, 'select * from <TABLENAME>')

    I get this error:
    OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
    OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80004005: The provider did not give any information about the error.].

    Can anyone provide any insight as to why OR tell me if there's a better way to link to these tables.

    Thanks!!

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    First, what error are you seeing if you use the Pervasive Control Center to access the table?
    Second, are the SQL Server and Pervasive.SQL on the same server?
    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
  •