>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;"
Your solution means you'll be missing out on a few things that newer drivers do, like extra columns on sqlcolumns(..."NATIVE"), proper handling of newer data types etc. Not a big loss, IMO - I haven't found a need for any of those yet. Your connectstring looks like it's using the SQL2000 driver.