my dog learned polymorphism*
The moose likes JDBC and the fly likes data source name too long Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "data source name too long" Watch "data source name too long" New topic
Author

data source name too long

sreejith ak
Greenhorn

Joined: May 26, 2005
Posts: 1
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: data source name too long
 
Similar Threads
Connectting to MS Access in Remote machine without DSN
Error in excel sending additional request
Error in excel sending additional request
dynamic creation of Data Source Name(DSN) programatically , help needed urgent
Exception :[ODBC Driver Manager] Data source name too long