Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005
    Posts
    3

    Question Unanswered: MSSQL Linked Server to Pervasive.SQL V8 Error Using Oledb provider

    Can anyone help me please? I would like to create a linked server on a MSSQL2000 server.

    I have a standard install of the Pervasive.SQL V8 data engine and DemoData db on my local PC. The SQL Server is also on my local PC.

    I manage to create the Linked Server using the MSSQL Enterprise Manager. I used the following configuration:

    Provider Name: Pervasive.SQL V8 OLE DB Provider
    Product Name: Pervasive.SQL V8
    Data source: DemoData
    Provider string: <blank>
    Location: workstation03
    Catalog: <blank>

    However when I try to expand the tables object under Linked Servers in the Enterprise manager I get the following error.

    Error 7311: Could not obtain the schema rowset for the OLE DB provider 'UNKNOWN'. The provider supports the interface, but retuns a failure code when it is used. OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80040155 ].

    Thank you.
    Cindy

  2. #2
    Join Date
    Feb 2004
    Posts
    78
    That looks right. workstation03 is the pervasive server, right?

    Have you tried making a system ODBC dsn and linking to that?

  3. #3
    Join Date
    Jan 2005
    Posts
    3
    Hi, sorry for the delayed response. Yes worstation03 is the pervasive server. I'll give it a go with ODBC.

Posting Permissions

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