Meaningless Drivel is fun!*
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: data source name too long