Migrating an ASP application between services shows ODBC Driver error: data source name not found

38 Views Asked by At

I'm migrating an ASP application from Windows Server 2003 to Windows Server 2016, with an Oracle database located on another server.

I have already installed all the extensions that the application uses, configured everything related to Oracle, including downloading the same version that is on the old server, tested the connection with ODBC 32 and 64 bits on Windows, and configured the tnsnames.ora file.

I tested a connection purely in asp, and both are working, but the application itself does not connect to the database, it persists in this error:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I don't know if I skipped any essential steps, as I have no experience with this type of situation.

0

There are 0 best solutions below