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

On 8 Ott, 16:14, ABCL <ohm...@hotmail.com> wrote:
> Hi,
> I want to connect to Sql 6.5 server database server, What clientTool
> should I use to connect it?

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

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

Yes (OleDb).

>
> Thansk In Advance

-P

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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx