asked on
Set dbData = New ADODB.Connection
sProvider = "SQLOLEDB.1"
dbData.ConnectionString = "Provider=" & sProvider & ";Integrated Security=SSPI;" _
& "Initial Catalog=" & sCatalog & ";Data Source=" & sServer
dbdata.Open()
and everyone was happy. The connection worked and I was able to access all my data. dbData = New SqlConnection
dbData.ConnectionString = "Data Source= " & sServer & "; Initial Catalog = " & sCatalog & "; Trusted_Connection=True)"
dbData.Open()
I have tried to set "Integrated Security = True" or "Yes" and I get an error: Invalid value for key 'integrated security'.