[dba-SQLServer] ODBC connection string for Azure SQL

[Jim Lawrence]

Hi Gustav:

Excellent post.

Jim

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Discussion concerning MS SQL Server (dba-sqlserver at databaseadvisors.com)" <dba-sqlserver at databaseadvisors.com>, "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Sunday, April 24, 2016 10:44:22 AM
Subject: [dba-SQLServer] ODBC connection string for Azure SQL

Hi all

Note please, that the ODBC strings published even at the Azure console are buggy, as Access doesn't like the curly brackets.
Thus, a string must look like (one line, of course):

ODBC;DRIVER=SQL Server Native Client 11.0;
SERVER=servername.database.windows.net,1433;DATABASE=databasename;
UID=username at servername;PWD=YourPassword;Trusted_Connection=No;


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com