• Post Reply Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found an  RSS feed

 
Hewa Naimanage Sumedha Amalka
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys, i am using excel sheet to get the data to jsp page through (tomcat)
but i get the above exception
pls help me !
(i have edited all the administrative odbc tools correctly)


try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection c = DriverManager.getConnection( "jdbcdbc:ExcelRec", "", "" );

Statement stmnt = c.createStatement();

String query = "select C:\\AAA.xls from [IJTS$]";
ResultSet rs3 = stmnt.executeQuery( query );

// System.out.println( "Found the following URLs for March 2000:" );

while( rs3.next() )
{
out.println( rs3.getString( "C:\\AAA.xls" ) );
}

stmnt.close();
c.close();
}

catch( Exception e ) {
out.println( e );
}
 
Prabhu Venkatachalam
Ranch Hand
Posts: 502
Java jQuery Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
seems like DataSource name is not created in server(machine where server is running). As you are using JDBC-ODBC driver you need to create a datasource in the machine where server is running.

Let me know still need clarification.
 
Prabhu Venkatachalam
Ranch Hand
Posts: 502
Java jQuery Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have a look at this URL.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!