Re: Linked Server MS SQL 2000 and Pervasive 7.82

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@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - March, 2006 ***
*** Chicago: Pervasive DataExchange Class - March, 2006 ***

datenisis@xxxxxxxxx wrote:

> 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

  • Re: Inno User Input Form and ODBC DSN
    ... Vincenzo Giordano - Inno Setup Extensions Knowledgebase ... It is an ODBC System DSN. ...
    (microsoft.public.vb.general.discussion)
  • Re: Inno User Input Form and ODBC DSN
    ... Vincenzo Giordano - Inno Setup Extensions Knowledgebase ... It is an ODBC System DSN. ...
    (microsoft.public.vb.database)
  • Re: Perl Code Connects to Database Across IP and Not Host Header
    ... I have the perl script setup in IIS as a virtual directory in Default ... access your ODBC DSN the way your http:///DOMAIN/page.pl ... DSN as a System DSN. ...
    (comp.lang.perl.misc)
  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Silly ODBC Connection problem
    ... it seems to me this must be done interactively on each client--either that or use the magical "DSN-less" connection. ... It's been 11 or years or so since I wrote about ODBC so it's getting kinda fuzzy. ... 556-9205 (Pacific time) ... > created a System DSN named "MyDSN" in the ODBC Administrator tool. ...
    (microsoft.public.dotnet.framework.adonet)