I think the built in CF driver for SQL datasource is macromedia_drivers.jar in \ColdFusion11\cfusion\lib.
As far as I can tell the CF10 (update 15) and CF11 (update 4) macromedia file is the same.
Perhaps you could check the connection syntax in neo-datasource.xml is the same for a connection to azure that works versa one that does not connect.
I just reminded myself of something I have previously noted with CF11 datasources to a SQL instance.
Configuring datasource would need EG:
CF Data Source Name DSN
CF Data Source Name DSN
With CF11 if port values are defined the following error occurs:
When the instance name is specified, it is invalid to specify the port number.
Is the SQL in azure like a traditional SQL instance? Perhaps remove the port number details on your CF11 azure datasource.
Bear with me, I don't really get into the nuts and bolts often!
Is the file you are referring to the "Microsoft SQL Server" in the pull down menu choice, or the java driver? I had previously made the Sql Database Driver work and it seemed to work better than the Java driver, I consider it the adobe "Built in" sql driver and it seem like more of a "core" approach..
So are you saying to replace that file with the file in coldFusion 10, thereby making the drive the same, then verify in the XML file that the settings are the same?
Seems a little much for simply upgrading and filling the same screens out! (attached is a screenshot of what works on CF 10 and doesn't work on CF 11)
Does anyone from Adobe watch this forum?? (queue for magic slam-dunk answer, with up-sell!)
Removing the port (just wiping out 1433 in port) produced this error:
Connection verification failed for data source: cadxApp
java.sql.SQLException: Timed out trying to establish connection
The root cause was that: java.sql.SQLException: Timed out trying to establish connection
I could just save the $$ and NOT upgrade to CF 11 to solve the problem, but I have permission and I am tired of getting 5 versions behind! (Just went from 8 and MX to 11)
Does coldFusion 10 run fine on Windows 2012 R2 and the new IIS (8 I believe)??
Azure SQL is similar to regular Microsoft SQL, but different..
It tends to be more "Old School" and is not as robust or smart, but once you get it working it feels the same. Transact SQL is almost the same (with some Syntax differences)
I am sure if this was a regular Microsoft SQL Server database then I would not be having these problems! (and i wouldn't need the EncryptionMethod=SSL; in the connection string..
I think \ColdFusion11\cfusion\lib\macromedia_drivers.jar is the jdbc file used when you select "Microsoft SQL Server" in the pull down menu.
It would be a little radical to replace CF11 macromedia_drivers.jar file with one from CF10 but I suppose if you take a copy of first then you can always put file back.
On occasion I have noticed the datasource graphic environment not tell you everything about the datasource information so you can open neo-datasource.xml to compare like for like tho the password would possibly be encrypted differently.
Sometimes Adobe staff respond which can be very helpful.
Will CF Java need the azure SQL SSL certificate CER file added to CF keystore to make the SSL datasource connection?