Re: Accessing SQL 2K from SQL 7

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 06/26/03 

Date: Thu, 26 Jun 2003 12:21:06 -0400

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
>
>
>
>
>

Relevant Pages

  • Re: Two named instances. Why ?
    ... I agree with Mike & Geoff. ... All my clustered SQL instances have always ... think of to having both instances being named instances and the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Default or named instances??
    ... Come to think of it, a lot of SQL documentation doesn't specify exceptons for clusters where they are clearly warranted, but that is another discussion. ... When it comes to default and named instances on a cluster, you treat the cluster as you would a single system, that is you get a single default instance per cluster, nt per node. ... As for the relationship between a virtual server and an instance, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Multi Instance Cluster Question
    ... You can have one default instance and 15 named instances OR 16 named ... instances on a cluster, but that is just a personal thing. ... Microsoft SQL Server MVP ... > a default instance was named as SQL1. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Error: 25002. The specified buffer size is not valid.
    ... Try moving tempdb to a storage card using SQL CE 2.0 Books Online section ... "Specifying the Location of the Temporary Database .. ...
    (microsoft.public.sqlserver.ce)
  • Re: Specifying Cursor SQL
    ... From what I've read so far (John Palinski's book - I don't know how well it stands up against other publications, but it's done sterling service for me with respect to the Oracle SQL I've been doing the past few years), there doesn't seem to be an easy way of passing an SQL select statement to a function or procedure. ... I specified varchar2as I don't think I can just leave things open ended with specifying it as just varchar2 without a length specification? ... '-- begin '-- open cDistributions; close cDistributions; '-- return n_Distribution '-- ... Native Dynamic SQL. ...
    (comp.databases.oracle.server)