Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

data source name too long

 
sreejith ak
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic