Connection Strings and SQL Server 2000 Named Instances - How To?

  • Thread starter Thread starter Ben Fidge
  • Start date Start date
B

Ben Fidge

How do I specify which named instance of a multi-instance SQL Server 2000
installation to connect to from within a ADO.Net connection string?
 
Easy. If I have a server named "Fred" and an instance of SQL Server named
"George" I would use
Server="Fred\George"
in the ConnectionString.

hth

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
HI

NamedInstance server name should be specified in
DataSource.

Data Source = servername\\Instance01



HTH
Ravikanth[MVP]
 
Back
Top