ODBC data sources on Windows Server 2008 x64
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".
Comments
[Add Comment]
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 Andrew
| 9/24/09 5:25 PM
Sorry, I don't think this will work with Coldfusion 64 bit.
# Posted By AEllstrom
| 9/25/09 2:44 PM
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!
# Posted By Jules
| 11/17/09 7:36 AM
[Add Comment]
