Tuesday, May 26, 2009

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

It might be possible that when you try to establish connection with Database using JDBC:ODBC approach you can face the following exception
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

fix:

Delete the USER data source name and define it as a SYSTEM data source name.

In Windows 2000:
-> Start -> Settings -> Control Panel -> Administrative Tools ->
Data Sources (ODBC):
- User DSN : delete the specified User DSN
- System DSN : create a new System DSN

No comments:

Post a Comment