This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!