Connect TO SQL Server using ADO

[FRANDAZZO]

Hello all,

Question - How do you connect to SQL server using ADO and using the Windows authentication not OledDB with a sql login and Pwd supplied.

Thankx in advance,

Frank

 

[Elysium]

Try this:

objConn_SQL.ConnectionString = &quot;Driver={SQL Server};Server=<<Name or IP of SQL Server>>;Database=<<DB_NAME>>;UID=<<ID>>;PWD=<<PWD>>&quot;