Connecting to a Server (Easy Question)

• Jacob Pressures

  SSCertifiable

  Points: 5804

  More actions

  April 25, 2007 at 10:21 pm

  #173105

  I'm using SQL Server2000. Up until now I've been testing my database connection on my workstation.  How do i modify my connection string to reach a server with a different letter?

  Here is my connection string

  connString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=FAE;Data Source=Maurice"

  Do I just put E: for the drive or how to i specify the path?

  Thanks!

• Bulent Gucuk

  SSCertifiable

  Points: 5497

  More actions

  April 26, 2007 at 9:08 am

  #702630

  Just change your source name to the new sql server name.

  Good day,

  Bulent