p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   SQL Server 7.0 talking to SQL Server 2000 (http://p2p.wrox.com/showthread.php?t=2806)

msavage August 14th, 2003 10:30 AM

SQL Server 7.0 talking to SQL Server 2000
I have a SQL Server 7.0 database I'm trying to get to talk to a SQL Server 2000 database. The communication actually needs to be 2-way in the end.

I've been trying to use the sp_addlinkedserver stored procedure in conjuction with sp_addlinkedsrvlogin.

So far, her is what I have:

exec sp_addlinkedserver @server='NAICT011\MFGSQL', @srvproduct='',
    @provider='SQLOLEDB', @datasrc='NAICT011\MFGSQL'

exec sp_addlinkedsrvlogin 'NAICT011\MFGSQL', FALSE,
    NULL, 'engdb', 'engdb'

Then, I attempted to do the following query:

select * from [NAICT011\MFGSQL].[Drive Loaner Test].[dbo].[tbl_Drives_Out]
    where userid='mbenue'

I get the following error:
[OLE/DB provider returned message: Client unable to establish connection]
[DBNMPNTW]ConnectionOpen (CreateFile()).

This is the SQL Server 7.0 trying to talk to the SQL Server 2000 database. If anyone can tell me what I'm doing wrong or tell me how they have done it successfully, I would be greatly appreciative! Thanks!

KenSchaefer August 20th, 2003 01:59 AM

What MDAC version do you have installed on the machine where SQL Server 7 is installed?



All times are GMT -4. The time now is 10:07 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.