SQL2000 Client to SQLServer 2005

#1

Hi,

I have upgraded to SQL Server2005.

I have some tools that seem to only support SQL 2000, and I am wondering if
I install the basic connectivity tools of SQL 2000 on my client, will they
be able to connect to the SQL 2005 server ? For example can I connect the
old ISQL/W tool to SQL 2005 Server... ?

Thanks

#2

ISQL is two versions behind and I don't know if you can connect to 2005 or
not. Even if you can you would certainly have issues with anything that is
specific to 2005. oSQL replaced that in SQL2000 and SQLCmd replaces that in
2005.

--
Andrew J. Kelly SQL MVP

"Aussie Rules" <AussieRules (AT) nospam (DOT) nospam> wrote

Quote:

Hi,

I have upgraded to SQL Server2005.

I have some tools that seem to only support SQL 2000, and I am wondering
if I install the basic connectivity tools of SQL 2000 on my client, will
they be able to connect to the SQL 2005 server ? For example can I connect
the old ISQL/W tool to SQL 2005 Server... ?

Thanks

#3

Hello,

ISQLW will open up a SQL 2000 query analyzer. THis will work fine for SQL
2005 databases as well.

Thanks
Hari

"Aussie Rules" <AussieRules (AT) nospam (DOT) nospam> wrote

Quote:

Hi,

I have upgraded to SQL Server2005.

I have some tools that seem to only support SQL 2000, and I am wondering
if I install the basic connectivity tools of SQL 2000 on my client, will
they be able to connect to the SQL 2005 server ? For example can I connect
the old ISQL/W tool to SQL 2005 Server... ?

Thanks

#4

Good catch Hari. I didn't see the W in that. Yes so far Query Analyzer still
connects but there is still limited functionality in some areas.

--
Andrew J. Kelly SQL MVP

"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> wrote

Quote:

Hello,

ISQLW will open up a SQL 2000 query analyzer. THis will work fine for SQL
2005 databases as well.

Thanks
Hari

"Aussie Rules" <AussieRules (AT) nospam (DOT) nospam> wrote in message
news:OzJwBjHrHHA.5092 (AT) TK2MSFTNGP04 (DOT) phx.gbl...
Hi,

I have upgraded to SQL Server2005.

I have some tools that seem to only support SQL 2000, and I am wondering
if I install the basic connectivity tools of SQL 2000 on my client, will
they be able to connect to the SQL 2005 server ? For example can I
connect the old ISQL/W tool to SQL 2005 Server... ?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL2000 Client to SQLServer 2005

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

SQL2000 Client to SQLServer 2005 - 06-11-2007 , 05:33 PM

Re: SQL2000 Client to SQLServer 2005 - 06-11-2007 , 08:44 PM

Re: SQL2000 Client to SQLServer 2005 - 06-11-2007 , 09:19 PM

Re: SQL2000 Client to SQLServer 2005 - 06-12-2007 , 08:33 AM