Posted by Erland Sommarskog on 10/08/07 22:05

ABCL (ohmp05@hotmail.com) writes:
> I want to connect to Sql 6.5 server database server, What clientTool
> should I use to connect it?

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.

> And also Is it possible to update records in the Sql 6.5 using
> ADO.net 2.0?

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
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How to select a word substring in a coumn header from right to left
• Prev in forum: Re: Help a newb (issue with excel, ms access and SQL Server)
• Thread view: Re: Sql Server 6.5 Client Tool and ASP.net

[Reply to this message]