Hi,

I'm using a service account, non-windows authentication.



Code:
Set Connection_o = CreateObject("ADODB.Connection")

' ConnectionString_s = "Provider=SQLOLEDB;Data  Source=XXXXXXXXXXXXX\YYYYYYYYYY:99999;database=XXXXXXXXXXX;User ID=SVC\XXXXXXX;Password=YYYYYYYYYYYYYYYYYYYY"
ConnectionString_s = "Provider=SQLNCLI11;Data 
Source=XXXXXXXXXXXXX\YYYYYYYYYY:99999;database=XXXXXXXXXXX;User ID=SVC\XXXXXXX;Password=YYYYYYYYYYYYYYYYYYYY"
'SQLSRV32.DLL
'SQLNCLI11'

Connection_o.Open ConnectionString_s

, but it returns invalid parameters or connection string not valid.