CF 9 64 bit with SQL Server 2005 32 bit

Report · Jul 15, 2010

We upgraded one of our webservers to CF9 64 bit on Win 2008 Server from CF8 on 32 bit Win 2003 platform and we are seeing awful performance on queries from our SQL Server 2005 32 bit Win 2003 DB server. I think its the driver that is installed on the CF9 server that may be the issue. I have searched for any docs on driver issues and cannot find it. Where can I find what driver the CF server is using and what should I be using?

Thanks

Report · Jul 16, 2010

The driver that ships w/ CF is very old. Try the Microsoft JDBC Driver http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en