MS Access Database Connection

[Umesh Patil]

The error is:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'DriverId'. 63 S1000

This is the error when MS Access database connection on a local machine is attempted whenever a small servlet for database connection is run. Server is Java Web Server and the servlet is loaded through Admin tool. If the same DB connection is tried through a regular Java program (run through Visual Cafe), database connection is formed properly and the query is executed. This confirms the correctness of System DSN setting in 'ODBC Data Source' control through control panel (it is Winodws NT 4.0 server OS). The number 63 in error message is getErrorCode() int on SQLException and 'S1000' is getSQLState() on SQLException. Sun site for Java documentation mentions that error code is vendor specific and the latter is SQLException object state.

What I would like to know is why such a problem arises or where can one find details of the reported error message. I looked on Microsoft site and couldn't find any details of the same.

Thanks,

Umesh.

[Umesh Patil]

The error turns out that there were duplicate DriverIds registered through ODBC32 of Windows NT. Microsoft site tells about such errors for ODBC drivers. Removing duplicate entries solves the problem.


Umesh.