I've been trying to figure out a connection string for a couple days now. I'm new to ado. I've been using odbc for years, but I want to update the old colde.
Please also let me know if I need quotation marks and apostrophes and does there need to be a semi-colon at the end, etc.
An example would be very helpful. I've look at connections.com, and many other places only to get
Here's a couple ones I've tried:
Set cn = "Provider='SQLOLEDB';Data Source='.\SQLEXPRESS';Initial Catalog='tblUser';Integrated Security='SSPI';"
Set cn = "Provider=SQLOLEDB; Data Source=CCI-2021\SQLExpress;Database=ADOLearn;Integrated Security=sspi;"
I'd like to use sql authentication, but windows would be fine.