>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;"

That error means that you have no such driver (SQL Server Native Client 11.0) installed on this computer.