Classic ASP with COM throwing "Data source name not found and no default driver specified" on Windows Server 2008 R2

Question

We have a classic ASP application that connects to a COM component. The COM component reads a connection string from the registry and connects to a datasource. We exported the COM package out of a 2003 box and imported into a 2008 R2 box. We've reviewed every setting to ensure its correct. When we hit the classic ASP site, we get the following in the event viewer:

Error Number: -2147467259
Error Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Additional Information: SPROC: sprocnamehere
Record Limit0 (User ID: 0)

We've created DSNs on the machine to ensure it could connect. We've setup the IIS anonymous user. We've setup IIS to run in 32-bit mode. Still, same error. Any other ideas? It almost seems as though the COM package is running as 64 bit.

Answer 1

You're close, but you have probably used the 64-bit version of the ODBC administrator to configure the DSNs. The DSN configuration is stored in the registry and 32-bit and 64-bit processes have different views of the registry. Run c:\windows\syswow64\odbcad32.exe instead. I think. Ask more questions about it at serverfault.com