• ODBC data sources on Windows Server 2008 x64

    September 24, 2009 10:28 AM

    IIS7 / Windows

    Windows Server 2008 x64 has both 32 bit ODBC data sources and 64 bit ODBC data sources. They are managed separately. Setting up a 32 bit ODBC connection in Windows Server 2008 x64. Start, Run, C:\Windows\SysWOW64\odbcad32.exe To setup the 64 bit ODBC connection go to: Control Panel, Administrative Tools, Data Sources (ODBC). For consistency you should setup a matching 32 and 64 bit connections. Otherwise you may run into the error "[Microsoft][ODBC Driver Manager] Data source name not found".

    Posted by: Anson

Comments

  • Posted by: Andrew | September 24, 2009 05:25 PM
    so - does this mean that you can use an MS Access mdb file as a DSN under 64-bit Windows and 64-bit CF? If so, specifically how? Yes, yes, I know that no one should use Access, but NOT using it is not always an option.
  • Posted by: Anson | September 25, 2009 02:44 PM
    Sorry, I don't think this will work with Coldfusion 64 bit.
  • Posted by: Jules  | November 17, 2009 07:36 AM
    Wow Thanks - Had to migrate a hosting account to a new windows 2008 server 64bit and his code uses a DSN to connect to MS Access MDB file..... Your advice sorted my problem and his ASP code now works again! THANKS!

Add Your Own Comment