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!

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

Cheers
Ken

www.adOpenStatic.com