Re: Accessing SQL 2K from SQL 7
nntp
Date: 06/26/03
- Previous message: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- In reply to: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Next in thread: Shamim: "Re: Accessing SQL 2K from SQL 7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 26 Jun 2003 09:28:08 -0700
bingo
"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message
news:eyjXz7$ODHA.3700@tk2msftngp13.phx.gbl...
> Try updating MDAC on your SQL 7.0 system. Earlier versions (prior to 2.6
or
> 2.4, I think) don't understand named instances. If updating MDAC isn't an
> option, try creating an alias that includes specifying the port number.
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Careerbuilder.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
> >
> >
> >
> >
> >
>
>
- Previous message: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- In reply to: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Next in thread: Shamim: "Re: Accessing SQL 2K from SQL 7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
