[quote=479258:@Norman Palardy]Ah indeed I had tried this and I’m not certain why it doesnt connect
with
local_db.DataSource = “Driver={ODBC Driver 17 for SQL Server};Server=” + m_Server + “;Database=”+ m_dbName + “;Uid=” + m_UserName + “;Pwd=” + localPassword + “;MARS_Connection=Yes;”
The error I get is
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified[/quote]
It looks like you don’t have the driver installed for the architecture you’re using (64bit app?)
Try visiting https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver15 and downloading and installing the right one again?
There’s two ODBC Data Sources you can check in Administrative Tools, one each for 32/64 bit, if your app is 64bit you’ll want to see it in the 64bit edition of the ODBC Data Sources viewer when you click Add, if its not there, its not installed correctly.