From my laptop I connect easily to the MSSQL 2012 database which is set up on a server. I use SQLStringconnect() to connect. But when I compile the application and try to run it on another machine, I cannot connect. I have installed the new ODBC driver.
This is the connection string I use: "DRIVER=SQL Server Native Client 11.0; SERVER=xxxx01; Database=YYYY; Trusted_Connection=Yes;"
The error I receive, from aerror(),is:
1526 Connectivity error: [Microsoft ODBC Driver Manager] Data source name not found and no default driver specified
Aerror(1,4): IM002
Aerror(1,5): 0
Aerror(1,6): 1
What am I missing?
Update! I resolved the issue by using this connection string: "Driver={SQL Server}; SERVER=xxxx01; Database=YYYY; Trusted_Connection=Yes;"