Win a copy of Mesos in Action this week in the Cloud/Virtualizaton 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic