Saturday, January 2, 2010

Sql Odbc Driver Driver Error : Java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' Is Not A Valid....

Driver Error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid.... - sql odbc 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

7 comments:

Anand said...

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

Anand said...

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

liketoas... said...

Good sense of humor. Hold ..... will

eagle4li... said...

Java and then uninstall the program moved

pokemon5... said...

First try using the Java application (JSP not used)
connect to this DSN

stealth_... said...

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.

stealth_... said...

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