Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    20

    Unanswered: SQL Server: Linked Server to Pervasive.SQL 2000i error

    Hi,

    This is like a 'Part II' to my older thread Pervasive DB as Linked Server to SQL Server

    In light of Windows NT end-of-life, we are moving all applications from NT boxes to new boxes -- some to existing Windows 2000 and others to new Windows 2003. With that comes my problem because I have to redefine my Linked Servers...

    Here's my new config:
    1. My PC (TheClient)
    OS: Win XP Pro
    Pervasive: 2000i Client
    SQL Server: 2000 Client

    2. SQL Server Machine (SQLServe)
    OS: Windows 2000
    Pervasive: No Installation
    SQL Server: SQL Server Enterprise (one instance)

    3. Pervasive Server Machine (PervasiveServe)
    OS: Windows 2000
    Pervasive: 2000i Server

    Connection:
    o TheClient connects to SQLServe through SQL Enterprise Manager
    o Defines Linked Server:
    Linked_Perv_Serv
    Product Name: MS OLE DB for ODBC Drivers
    Data Source: PERVASIVE_DB
    Location: PervasiveServe
    Catalog: PERVASIVE_DB
    Security: Login's current security context

    When I try to click Tables on the Linked Server, Liked_Perv_Serv, I get the following error: Error 7399: OLEDB provider 'MSDASQL' reported an error.
    Data source name not found and no default driver specified]
    OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:]


    Other Info: Even though I change the Security of the Linked_Perv_Serv to force a valid user id to PervasiveServe machine, I still get the same error.

    Q: Aside from the microsoft's explanation of Error 7399 , should I look for other cause of this error like defining ODBC DSN's on SQLServe machine? Is that a requirement in my case?

    Thanks in advance for your input.

    _msd_

  2. #2
    Join Date
    Feb 2004
    Posts
    78
    Yes, you need to define system odbc's on your new sql server.

Posting Permissions

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