Geek Answers Handbook

ColdFusion 11 and Azure Database

I cannot connect ColdFusion to an Azure database. We have the usual ColdFusion administration procedure, which requires a data source, and we are moving from aws to azure.

After reading on the Internet, it seems like this will not work unless you use a different data source and jdbc driver and settings. However, in ColdFusion 11 it just doesn't check and doesn't tell me

Connection verification failed for data source: MyData
 com.microsoft.sqlserver.jdbc.SQLServerException: The connection string contains a badly formed name or value.
 The root cause was that: com.microsoft.sqlserver.jdbc.SQLServerException: The connection string contains a badly formed name or value.

Ive tried many combinations and couldn't get it to work. Someone got this working and has an example connection string.

+4
source share
2 answers

, , . , , . , . jdbc Microsoft jar lib ColdFusion ( CF) CF.

  • : Other
  • : com.microsoft.sqlserver.jdbc.SQLServerDriver
  • : Microsoft SQL Server Azure
  • URL- JDBC: jdbc:sqlserver://YOURSERVERNAME.database.windows.net:1433;databaseName=YOURDATABASENAME;user=YOURUSERNAME@YOURSERVERNAME;password=YOURPASSWORD;
+9

, , . ODBC Coldfusion: ODBC azure ODBC.

0

More articles:


All Articles