Skip to main content
G
gotham65000
Participant
July 15, 2010
Question

CF 9 64 bit with SQL Server 2005 32 bit

  • July 15, 2010
  • 1 reply
  • 433 views

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

    This topic has been closed for replies.

    1 reply

    S
    Sean_Coyne-cKxAXa
    Inspiring
    July 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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices