This is one of those cases where being on the leading edge of technology causes issues. I just got a new workstation that is running the 64-bit version of Windows Vista. I installed the 64-bit version of ColdFusion 8.0.1 with the latest hotfixes etc. and everything was going well. That is, until I tried setting up an MSSQL datasource. Apparently there is something wrong with the drivers that ship with CF 8.0.1 as I was not able to connect to a local MSSQL server or a remote MSSQL server. Any time I tried creating a new data source, JRun would crash.
So, after a bit of digging, Jared Rypka-Hauer and Jason Delmore both suggested trying the latest JDBC drivers from Microsoft. Microsoft just released a CTP of version 2.0 in July which can be found here …
For those that have not installed a JDBC driver ( I have not before for MSSQL ), here are the steps you will need to follow.
- Expand the zip that you get from Microsoft and grab the sqljdbc4.jar file.
- Copy that file to the JRunserverslib folder in your multi-server CF install
- Restart ColdFusion
- Create a new data source, selecting ‘other’ as the typeJDBC URL = jdbc:sqlserver:/localhost:1433;databaseName=[Your Database Name]
Driver Class = com.microsoft.sqlserver.jdbc.SQLServerDriver
Driver Name = MSSQL
Submit that along with your database username and password and hopefully you get a green Ok result. I will update if I get any new information from Jason.
Update: In less than 24 hours, Jason from Adobe has confirmed that they can reproduce this and will be addressing the issue. So, thanks Jason and Adobe for quickly looking into this!