ODBC Connection String for SQL Server

[Chlaris]

Dear all,

If I'm using SQL Server with "Windows only" authentication, how to write the
SQL connection string ?
When I use "SQL Server and Windows" authentication, I write the SQL
connection string like this :

strSQLConnection = "ODBC;DRIVER={SQL Server};SERVER=" & strServerName & _
";DATABASE=" & strDbName & ";UID=" &
strUserName & ";PWD=" & strPassword

But the above code doesn't work for "Windows only" authentication.
Please help. Thanks.

Chlaris

 

[Arvin Meyer [MVP]]

Every connection string that you could possibly want:

http://www.carlprothman.net/Default.aspx?tabid=81

 

[Pieter Wijnen]

And for some you might *not* want <g>

http://www.connectionstrings.com/

Pieter

 

[Chlaris]

Thank you very much.

Every connection string that you could possibly want:

http://www.carlprothman.net/Default.aspx?tabid=81
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com