Connection Strings/Authentication

• charger

  SSChasing Mays

  Points: 654

  More actions

  November 28, 2006 at 12:07 pm

  #171476

  Sql2k, Mixed Mode Authentication, Win2003. I have a VB app (actually a VB script) that connects to a Sql Server DB and runs some queries.  Here is the connection string it currently uses:

  Dim mhcConn

  set mhcConn = CreateObject("ADODB.Connection")

  Err.Number = 0

  mhcConn.Open "Driver={SQL Server};Server=MiniBase-Sql-002;" & _

  "Database=Employee;UID=myId;PWD=myPword"

  Is it possible to change the connection string so that it uses Windows Authentication?  If so what would be the syntax?  Any help would be greatly appreciated.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 28, 2006 at 12:26 pm

  #674486

  http://www.connectionstrings.com/?carrier=sqlserver

• charger

  SSChasing Mays

  Points: 654

  More actions

  November 28, 2006 at 12:46 pm

  #674499

  Thanks, this worked like a charm:

  Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;