May 12th, 2000, 01:46 PM
Hello
I am running under Win Nt platform and using JDBC ODBC driver ( .
While trying to connect to Excel through a JAVA program , compilation goes fine but the RUN gives the following message -:
******************************************************************
SQLException --------------
SQLState : 37000
Message : [Microsoft][ODBC Microsoft Access Driver] Unknown
Interactive Session Ended
*****************************************************************
I am running under Win Nt platform and using JDBC ODBC driver .
Here is the exact Code
*************************
sourceURL = "jdbc:odbc:temp-order";
// querryIdandName= "select employeeid,firstname,address,salary from TEmployees";
querryIdandName= "select ORDERID , NAME from ORDER ";
querryWildCard= "select * from TEmployees";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// String sourceURL = new String ("jdbc:odbc:FirstDs1");
databaseConnection = DriverManager.getConnection(sourceURL);
}
Thank you techies
Zaky
I am running under Win Nt platform and using JDBC ODBC driver ( .
While trying to connect to Excel through a JAVA program , compilation goes fine but the RUN gives the following message -:
******************************************************************
SQLException --------------
SQLState : 37000
Message : [Microsoft][ODBC Microsoft Access Driver] Unknown
Interactive Session Ended
*****************************************************************
I am running under Win Nt platform and using JDBC ODBC driver .
Here is the exact Code
*************************
sourceURL = "jdbc:odbc:temp-order";
// querryIdandName= "select employeeid,firstname,address,salary from TEmployees";
querryIdandName= "select ORDERID , NAME from ORDER ";
querryWildCard= "select * from TEmployees";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// String sourceURL = new String ("jdbc:odbc:FirstDs1");
databaseConnection = DriverManager.getConnection(sourceURL);
}
Thank you techies
Zaky