sql server (alternate): [quoted text, click to view]

It depends on what is your goal. There are lots of tools that can
connect to it.

[quoted text, click to view]

Yes (OleDb).

[quoted text, click to view]

-P

Hi,
I want to connect to Sql 6.5 server database server, What clientTool
should I use to connect it?
And also Is it possible to update records in the Sql 6.5 using
ADO.net 2.0?


Thansk In Advance

ABCL (ohmp05@hotmail.com) writes:
[quoted text, click to view]

You a tool like Management Studio?

Well, Management Studio cannot connect to SQL 6.5. Of the tools that
ship with SQL 2005, none is able to connect to 6.5.

But all tools that ship with SQL 2000 can connect: OSQL, Query Analyzer
or ISQL.

And of course, all the 6.5 tools can connect. The graphic query tool
for 6.5 is ISQL/W.

[quoted text, click to view]

With SqlClient, no. But you can use OleDb client, as long as you use
SQLOLEDB as the OLE DB provider. The newer SQLNCLI does not support
connections to SQL 6.5.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at