Driver Error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid.... - microsoft access jdbc driver
I am working on a program in which I am connected *. mdb
jdbcodbc.Following throgh database error when I try to
connect:
java.sql.SQLException: [Microsoft] [ODBC Microsoft Access Driver]
'unknown) (' is
is not a valid path. Check the path name is spelled correctly
I
U connected to the server where the file resides.
In sun.jdbc.odbc.JdbcOdbc.createSQLExceptio ...
In sun.jdbc.odbc.JdbcOdbc.standardError (JDB ...
In sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect (...
in
sun.jdbc.odbc.JdbcOdbcConnection.initi ...
I checked the path and the DSN name, everything seems fine.I
I wonder by JSP running on Tomcat 4.1.32
Monday, January 18, 2010
Microsoft Access Jdbc Driver Driver Error : Java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' Is Not A Valid....
6 comments:
Ritu Hai
You said that you *. mdb file are logged, not a single database, as db1.mdb?
You can not access large amounts of multilateral development banks on a single data source.
If this is not the case, then you can verify that the DSN that you created should be valid? and is the same as you mentioned in the appendix.
A final point is that you said you were working on an application
Is it a web application, and later he said, using JSP?
Where did you get this error message?
Is it in the console (command prompt) or IE?
(This error may also be due to a lack of library files as well).
You can contact me
For more information, please send me a detailed description of what you need to know and, if possible, please send me the code segment
I will need the correct parts.
E-mail: ananthasivanvk@gmail.com
Mobile: +919995403653
Good sense of humor. Hold ..... will
Java and then uninstall the program moved
First try using the Java application (JSP not used)
connect to this DSN
First try using the Java application (JSP not used)
connect to this DSN
i Supect that the DSN is configured incorrectly
You can check this code, the JSP directly to the database without a DSN
String dbname = "C: \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ tomcat \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ database.mdb ";
Class.forName ( "oracle.jdbc.driver.OracleDriver");
= DriverManager.getConnection
( "Jdbc: odbc: DRIVER =
Microsoft Access Driver (*. mdb) DBQ =
+ DbName);
stmt = con.createStatement ();
rs = stmt.executeQuery (SELECT ".......");
* Dual-use \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ \\ only as an escape character
* Dbname must link directly to the database with the multilateral development banks.
Post a Comment