2000 sql client connecting to a 6.5 sql server -- sql server clients

Keith Kratochvil
10/7/2003 12:42:19 PM

I am guessing that Query Analyzer should work. You might have problems =
with Enterprise Manager.

--=20
Keith

[quoted text, click to view]

rboyd NO[at]SPAM onlinemicrosoft.com
10/8/2003 3:24:36 PM

Enterprise Manager will not work. If you mean just client machines using
MDAC 2.6 or above then you ahould not have any problems.

Rand

David Knapp
10/9/2003 8:36:27 AM

One of my developers needs to connect to both types as
well. He says that EM for 2000 won't connect to the 6.5
and that the 6.5 client won't let him use the Table
variable type in 2000. He reloaded the 2000 client and
that caused 6.5 connections to cease to funtion at all.
Let me know if you find a way to connect to both. There
might be some magical combination of clients that allows
for that. Just another EM shortcoming in my book. For
folks who are migrating from 6.5 to 2K it could come in
very handy to have a way to manage easily both types of
systems.

Thanks,

Dave Knapp

Chris Gadsby
10/10/2003 11:55:55 PM

I've got both 2000 and 6.5 clients installed and both seem to work together
perfectly OK.

The Query Analyser for either client will connect to either server. The
client configuration tool works on the same set of aliases. Enterprise
Manager is specific to 6.5 or 2000.I have had both loaded at the same time
as well and they both worked.

If I have to connect to a SQL 7 database then the 2000 EM works with that.

Regards

Chris Gadsby

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : 2000 sql client connecting to a 6.5 sql server