ODBC Error Message Windows Server 2003
ODBC error: "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.."
Software/Hardware used:
Installing software applicationon Windows Server 2003 Standard Edition
Software/Hardware used:
Installing software applicationon Windows Server 2003 Standard Edition
ASKED:
March 22, 2010 3:19 PM
UPDATED:
March 22, 2010 6:06 PM
RELATED QUESTIONS
- MSSQL 2000 - ODBC connection SQL state 28000 error 18456
- ODBC to AS400 test connection failed
- SQL UPDATE/SET/WHERE statement
- Additional information: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
- Problem MS Queries Refresh in excel file located on client network
Answer Wiki:
DISCUSSION:
What are you trying to install?
I am installing an update to an ERP application. The application had already been installed and running on this server - both the Client and the Server versions. In updating, the installation is successful but when I open/access the program, I get the error message:
Error 1429:
OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified..
To see all answers submitted to the Answer Wiki: View Answer History.
What are you trying to install?
Take a look at the configuration of your ERP application. Some settings (including the name of the ODBC data source) could have been reseted to their defaults with the update.
If that’s not the case, and it is not a ‘known issue’ of the update you installed, then I think you will have to contact your software vendor/support.