-
1
- #1
TimeTraveler
IS-IT--Management
If you are planning on using ColdFusion 9 and SQL Azure,
the default [green]SQL Server[/green] option for the [green]datasource[/green] will not work. Believe it or not, it is the old MacroMedia SQL Server driver!
You will want to download and use the Microsoft JDBC 3.0 (or later) database connectivity drivers.
And you will want to build your own connection string, which includes telling the driver to use SSL.
JDBC URL
jdbc:sqlserver://[blue]YOURDBIDHERE[/blue].database.windows.net:1433;databaseName=[blue]YOURDATABASENAME[/blue];User ID=[blue]YOURID[/blue]@[blue]YOURDBIDHERE[/blue];require=ssl;
DRIVER CLASS
com.microsoft.sqlserver.jdbc.SQLServerDriver
DRIVER NAME
Microsoft SQL Server Azure
DESCRIPTION (Optional)
Azure via SQL JDBC Driver from MS
TIMEOUT MIN / INTERVAL
3 / 4
See other tip on writing embedded SQL inside CFML for SQL Azure, since there is some workarounds for the Microsoft JDBC driver to do before it is 100% functional.
the default [green]SQL Server[/green] option for the [green]datasource[/green] will not work. Believe it or not, it is the old MacroMedia SQL Server driver!
You will want to download and use the Microsoft JDBC 3.0 (or later) database connectivity drivers.
And you will want to build your own connection string, which includes telling the driver to use SSL.
JDBC URL
jdbc:sqlserver://[blue]YOURDBIDHERE[/blue].database.windows.net:1433;databaseName=[blue]YOURDATABASENAME[/blue];User ID=[blue]YOURID[/blue]@[blue]YOURDBIDHERE[/blue];require=ssl;
DRIVER CLASS
com.microsoft.sqlserver.jdbc.SQLServerDriver
DRIVER NAME
Microsoft SQL Server Azure
DESCRIPTION (Optional)
Azure via SQL JDBC Driver from MS
TIMEOUT MIN / INTERVAL
3 / 4
See other tip on writing embedded SQL inside CFML for SQL Azure, since there is some workarounds for the Microsoft JDBC driver to do before it is 100% functional.