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 …
http://www.microsoft.com/downloads/details.aspx?FamilyId=F914793A-6FB4-475F-9537-B8FCB776BEFD
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!
DougHughes.net 
Comments on: "MSSQL Driver Issue with CF 8.0.1" (6)
I have CF 8.0.1 64-bit installed on OSX 10.5 connecting to a remote MS-SQL 2005 server, no problems. Just sayin’.
LikeLike
We had the same issue with MX 6 connecting to a remote SQL Server 2005 database and used the same fix (installed the JDBC driver and used an ‘other’ datasource).
CF 8.0.1 connected fine to a local SQL Server 2005 database for us, but that was Windows Server 2003 and not Vista.
LikeLike
I personally haven’t had any problems on my non-64bit-Vista using CF8.0.1 along with MSSQL 2005 or MSSQL 2008.
LikeLike
@Cheif: Yeah, we have several people on the Alagad team running this setup on Mac, so the issue appears to be isolated to the Windows 64 bit install.
@Dave: I have been running the 32 bit version of Vista with no issues for months now. It was just this new system with Vista 64 where I ran into issues.
@Steve: I spoke with several people yesterday who said this was working for them, so I don’t know. All I know is that I have stock installs for MSSQL and CF and once I used the latest driver from Microsoft all of the issues disappeared. So, the main point in posting this was to help somebody else out that might run into this issue.
LikeLike
I’m having a very very similar problem. We are running Windows 2003 64bit, Apache 32bit, and Coldfusion 8.0.1 64bit, and we are getting “JRun Connection Closed” errors. I’m lost, as the logs give no useful info to tracking down this problem.
We have an ipen support case with Adobe open, and they seemed to be stummed too! We have yet to look into the MS-SQL, but we ARE using MS SQL 2005 so this sounds like it could be the problem.
I’m going to test this, and post back my results. Thanks for the post!
P.S: Any tricks for debugging those DB connections? Maybe there is something strange going on their??
LikeLike
http://concealer.mybrute.com
Check out this cool mini fighting game
LikeLike