data source name too long
sreejith ak
Greenhorn
Posts: 1
posted 12 years ago
hai all,
I used following code for reading excel files.but when am reading from excel files it showing exception like "Microsoft odbc manager data source name too long".but this problem not arising,when am running the same code in some computers.In some machines it shows exception.Is it coming due to any dll file missing?.please give me suggestions.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myDB =
"jdbc
dbc 
river={Microsoft Excel Driver (*.xls)};DBQ=C:/My Documents/";
//+ "DriverID=22;READONLY=false";
Connection con=DriverManager.getConnection(myDB,"","");
System.out.println("Connected..excel...");
sreejith
I used following code for reading excel files.but when am reading from excel files it showing exception like "Microsoft odbc manager data source name too long".but this problem not arising,when am running the same code in some computers.In some machines it shows exception.Is it coming due to any dll file missing?.please give me suggestions.
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String myDB =
"jdbc
dbc river={Microsoft Excel Driver (*.xls)};DBQ=C:/My Documents/";//+ "DriverID=22;READONLY=false";
Connection con=DriverManager.getConnection(myDB,"","");
System.out.println("Connected..excel...");
sreejith
| It is sorta covered in the JavaRanch Style Guide. |