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.

My understanding is that something like this should work:

exec sp_addlinkedserver @server='PSQLDEMODATAODBC',
@srvproduct='',@provider='MSDASQL', @datasrc='Demodata',
@location='',@provstr='DBQ=Demodata;Driver=c:\pvsw \bin\w3odbcci.dll'

In this case, the first "demodata" is the DSN, and the second (DBQ) is
the Named Database on the server. (Usually these are the same, but
they CAN be different.)

Hope this helps...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - March, 2006 ***
*** Chicago: Pervasive DataExchange Class - March, 2006 ***

datenisis (AT) gmail (DOT) com wrote:

Hi Bill,

I've tried your suggestion and it still gave me the same error, and I
have checked that the DSN and the dll file both exist.

Thanks,

- d

let me rephrase, the error only shows " Error 7399: OLE DB Provider
'MSDASQL' Reported an error."

It doesn't have the datasource not found part on it.

datenisis (AT) gmail (DOT) com wrote:

Well, you got me now. Not being a SQLServer person, I've never had the
"pleasure" of struggling with linked servers.

Can someone else chime in???

Yeah. If I remember the OLE DB Provider didn't work with MS SQL
Linked server stuff until Pervasive.SQL 2000i SP4 or thereabouts.
In fact there are some OLE DB specific notes on the SP4 download page:
http://www.pervasive.com/support/updates/2000i_sp4.asp

I believe you can use the generic ODBC driver for connectivity.

Leonard

On Wed, 04 Jan 2006 21:23:28 -0600, "Bill Bach"
<goldstar (AT) speakeasy (DOT) net> wrote:

Hi Leonard,

Can you elaborate on what you meant by: "you can use the generic ODBC
driver for connectivity"

I was looking to update tables on MS SQL via DTS, and to do this I'd
need to do joins on tables from MS SQL and Pervasive to check for which
records to add and update.

My ears are open to other ways of doing this, preferably in DTS, but I
would not like to use temp tables.

Thanks,

-d

I've used the following and it worked, thanks to Mertheil!

sp_addlinkedserver 'PSQLDEMODATAODBC', ' ', 'MSDASQL', 'DEMODATA'
When you specify the "MSDASQL", you don't need the providerstring or
location values.

- d