Re: Accessing SQL 2K from SQL 7
From: Brian Moran (briancmoran_at_hotmail.com)
Date: 06/26/03
- Next message: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Previous message: Narayana Vyas Kondreddi: "Re: Multi server job - SQL 2K / 7"
- In reply to: Shamim: "Accessing SQL 2K from SQL 7"
- Next in thread: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 26 Jun 2003 12:16:05 -0400
not 100% sure, but...
SQL7 doesn't know about named instance. So the OLE-DB drivers won't know
either. You'd have a problem trying to resolve the name of the named
instance.
Try creating a client alias on the SQL7 box and use THAT name as the linked
server name. That might do the trick....
-- Brian Moran Principal Mentor Solid Quality Learning SQL Server MVP http://www.solidqualitylearning.com "Shamim" <shamim.abdul@railamerica.com> wrote in message news:e9bAog$ODHA.2052@TK2MSFTNGP11.phx.gbl... > We added a new SQL instance of SQL 2K - name XXX\AB > > From SQL 7 server, I did sp_addlinkedserver 'XXX\AB' > > when try to access from SQL 7 > > Select * from [XXX\AB].[dbname].[dbo].[tablename] > > "Specified SQL Server not found" > > Any thoughts ?? > > Sh > > > > >
- Next message: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Previous message: Narayana Vyas Kondreddi: "Re: Multi server job - SQL 2K / 7"
- In reply to: Shamim: "Accessing SQL 2K from SQL 7"
- Next in thread: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
