Search BrianLoesgen.com
Categories
Archives
Thursday
Jul052012

Connecting Cold Fusion 10 to Azure SQL Database

This is easy to do, IF you have the right pieces.

For the connection string, you can use the JDBC connection string presented in the portal (see below).

For the JDBC driver, you need to be using Version 4. The reason is that earlier versions had problems with wildcard SSL certificates. You can download the driver at: http://www.microsoft.com/en-us/download/details.aspx?id=11774

We tested this using with Cold Fusion 10 installed in an Azure Virtual Machine.

image

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>