aspose file tools*
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
Similar Threads
Error in excel sending additional request
dynamic creation of Data Source Name(DSN) programatically , help needed urgent
Connectting to MS Access in Remote machine without DSN
Error in excel sending additional request
Exception :[ODBC Driver Manager] Data source name too long