Linked Server MS SQL 2000 and Pervasive 7.82

I followed the setup from a previous thread on my setup between MS SQL
2000 and Pervasive 7.82:

EXEC sp_addlinkedserver
@server = 'ACCTS1',
@provider = 'MSDASQL',
@srvproduct='Pervasive ODBC Client Interface',
@datasrc = 'BVDemo'
--@Server is the name of the new linked server
--@datasrc is the name of a local ODBC DSN

and I keep on getting the error saying: Error 7399: OLE DB Provider
'MSDASQL' Reported an error. Data source name not found and no default
driver specified.

I have set up an ODBC connection and verified the system DSN is spelled
correctly and it connects to the server. I'm not sure what is wrong in
this setup.

Please help.

.

Relevant Pages

  • ODBC error code 126 Setting up a System DSN
    ... I am trying to setup a system DSN to setup a linked server to ... Microsoft ODBC Administrator ...
    (microsoft.public.sqlserver.odbc)
  • Re: ODBC
    ... How can I access and update PICK files from VBA? ... to setup an ODBC Data Source ... I wouldn't used D3's ODBC provider to do ... The driver configuration is pretty straight forward. ...
    (comp.databases.pick)
  • Win2000 & XP
    ... I am using VFP6 and Access using ODBC. ... setup at customer place in XP and Win2000 pro ...
    (microsoft.public.fox.vfp.dbc)
  • Setting up ODBC Connection in web.config
    ... I need to know how to setup and use an ODBC connection to SQL Server ... I have done a connection using OLEDB but not with ODBC. ...
    (microsoft.public.dotnet.framework.aspnet)
  • =?iso-8859-1?q?ODBC_l=E4=DFt_sich_nicht_neu-installieren_nach_Installation_von_SQL_Serve
    ... wie kann ich ODBC neu installieren? ... "Setup Routinen fehlen". ... MDAC 8.1 SP1 als richtige Version identifiziert, ...
    (microsoft.public.de.sqlserver)