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_

Yes, you need to define system odbc's on your new sql server.