Sunday, February 19, 2012

6.5 connectivity to 2000

Is it safe to use 6.5 connectivity on a 95 machine to
connect to a SQL 2000 installation on Win 2K?Hi,
No issues. You can execute all commands. Only demerit is that you wont get
the GUI facilities available in SQL 2000 client.
FYI, You cant use SQL 6.5 enterprise manager to connect to SQL 2000. Only
ISQLW can be used .
Hari
"Mark Walker" <anonymous@.discussions.microsoft.com> wrote in message
news:254101c3fc6a$25446c80$a101280a@.phx.gbl...
> Is it safe to use 6.5 connectivity on a 95 machine to
> connect to a SQL 2000 installation on Win 2K?|||... and since 6.5 ISQL.EXE and ISQLW.EXE uses DbLibrary, some of the new
stuff in 7.0/2000 will not be available. Such includes longer strings than
255 characters, Unicode, uniqueidentifier etc.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%2387UBvG$DHA.2520@.TK2MSFTNGP11.phx.gbl...
> Hi,
> No issues. You can execute all commands. Only demerit is that you wont get
> the GUI facilities available in SQL 2000 client.
> FYI, You cant use SQL 6.5 enterprise manager to connect to SQL 2000. Only
> ISQLW can be used .
>
> Hari
> "Mark Walker" <anonymous@.discussions.microsoft.com> wrote in message
> news:254101c3fc6a$25446c80$a101280a@.phx.gbl...
> > Is it safe to use 6.5 connectivity on a 95 machine to
> > connect to a SQL 2000 installation on Win 2K?
>

No comments:

Post a Comment