Driver Error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid....

Question

i am working in an application where in i am connected to *.mdb
database throgh jdbcodbc.Following error comes up when i try to
connect to it :
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]
'(unknown)' is
not a valid path. Make sure that the path name is spelled correctly
and that yo
u are connected to the server on which the file resides.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6026)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6183)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2453)
at
sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3

I have checked the DSN path and name , everything seems to be fine.I
am calling it through jsp running in tomcat 4.1.32

Answer 1

Hai Ritu,
Here you mentioned that you are connected to *.mdb, so it is not to a single database, like db1.mdb ?

You cannot access lot of mdb's through a single dsn.

If this is not the case, then you need to verify that the dsn you created is existing ? and it is the same as that you have mentioned in the programming.

One more thing is that you said you are working in an application,
Is that a Web Application, later you said you are using JSP ?

Where did you receive these error messages ?
Is it in the console(command prompt) or in the IE ?
(This error may be also due to missing of library file also).

If you wish you can contact me
for more clarifications, send me a detailed description of what you need to know and if possible send me the code segment
I will correct the necessary parts.

email: [e-mail]
cell: [phone]

Answer 2

i supect that the DSN is set wrongly
you can try this coding, it will point the jsp directly to the database without using the DSN

String dbname = "C:\\tomcat\\database.mdb";
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");

con = DriverManager.getConnection
("jdbc:odbc:DRIVER=
Microsoft Access Driver (*.mdb);DBQ=
" + dbname);

stmt = con.createStatement();
rs = stmt.executeQuery("select.......");


*use double \ as single is an escape character
*dbname must point directly to the database with the .mdb

Answer 3

first you try on use java application (don't use jsp)
to connect to this DSN

Answer 4

uninstall Java and then reintall the program

Answer 5

Good sense of humour. Keep going.....