and everyone was happy. The connection worked and I was able to access all my data.
Set dbData = New ADODB.Connection sProvider = "SQLOLEDB.1" dbData.ConnectionString = "Provider=" & sProvider & ";Integrated Security=SSPI;" _ & "Initial Catalog=" & sCatalog & ";Data Source=" & sServer dbdata.Open()
I have tried to set "Integrated Security = True" or "Yes" and I get an error: Invalid value for key 'integrated security'.
dbData = New SqlConnection dbData.ConnectionString = "Data Source= " & sServer & "; Initial Catalog = " & sCatalog & "; Trusted_Connection=True)" dbData.Open()
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.