SQLConnection

[slg]

Gurus - I am using sqlconnection framework 2.0 class in my project. how can
i use native client 10.1 which
is for sql server 2008?
Do i have to change lot of my code.?

TIA

 

[Cowboy \(Gregory A. Beamer\)]

In general, Microsoft is not suggesting to move to native client when using
..NET. It is set up primarily for COM based clients. The .NET stuff wraps the
underlying bits nicely.

With COM it is as easy as changing the provider:

Provider=SQLNCLI10

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************

 

[slg]

Thx Gregory.


Are there new assemblies for following to connect to sql 2008.?
System.Data.SqlClient;
System.Data;

I found that for following namespaces i had to install new assemblies to use
connect to sql 2008.
Microsoft.SqlServer.Management.Smo;
Microsoft.SqlServer.Management;
Microsoft.SqlServer.Management.Common;

 

[Cowboy \(Gregory A. Beamer\)]

For normal data access, aim for the System.Data and System.Data.SqlClient.
The Management classes are for getting at schema (SMO = SQL Management
Objects, for example). SMO has been there for awhile, so it is not new to
SQL 2008. I am sure the libraries are updated, however.

If you go back to pre .NET, DMO was the method to get schema information. It
was replaced by SMO in .NET.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************