SqlConnection.ConnectionString parts

• kromo

  SSC-Addicted

  Points: 459

  More actions

  January 16, 2004 at 10:11 am

  #65376

  Can you specify the name of the sql service instance you want to connect to in the connection string?  If so how?  I just don't know what name\value pairs exist in the ConnectionString.

   

  Thanks in advance.

• justevolved

  SSC Enthusiast

  Points: 188

  More actions

  January 16, 2004 at 11:01 am

  #490492

  I am sure you are trying this with SQl server 2000.

  The connecting string should be

  sConn = "Provider=sqloledb;Data Source=myServerName\myInstanceName;Initial Catalog=myDatabaseName;User Id=myUsername;Password=myPassword"

  You have to dig for tons of dirt to get an ounce of Gold

• kromo

  SSC-Addicted

  Points: 459

  More actions

  January 16, 2004 at 12:11 pm

  #490516

  Thanks for the input but I am a little confused.  What is the difference between myServerName and myInstanceName?

   

• justevolved

  SSC Enthusiast

  Points: 188

  More actions

  January 16, 2004 at 12:42 pm

  #490521

  Starrting with SQL Server 2000. It is possible to have more than one instance of sql server on a single windows server. These instances are isolated from one another, they have separate sets of system dbs and so on.

  I hope I am clear and correct

  You have to dig for tons of dirt to get an ounce of Gold