Why is my MSOLEDBSQL connection string in Excel not connecting to my SQL Express db?
I’m trying to connect to a new SQL Express Db and can establish the connection with a BAT file, but not in VBA. The name in SQL Server Management Studio is: Data Source=James-desktopSQLEXPRESS.History. I can connect with SMS as well at the BAT. I do have Integrated Security (Windows Authentication) setup, and since it works with the BAT, that presumably can’t be the problem.