Click to See Complete Forum and Search --> : JDBC problem


zaBulet
September 19th, 2000, 07:52 AM
Hello!!!
I have a little problem.
I've started to work with JDBC for some time and everything works OK except
when I trry to acces an Excel database.
I configured ODBC DataSources from my Control Panel and I created an object
named ExcelDataSource (from System DSN).
I selected my Workbook (is an Excel file) and I made an Java Application that
tries to acces this ExcelDataBase.
The driver is loaded properly because no exception is thrown.
The problem appear when I try to execute a SQL Querry.
(The querry is : SELECT * FROM med.xls) where med.xls is my Workbook I've
selected when I've configured System DSN from ODBC DataSources.
When this querry is executed an exception is thrown:

java.sql.SQLException : [Microsoft][ODBC Excel Driver] The Microsoft Jet Database
engine could not find the object 'xls'. Make sure the object exists and that you
spell its name and the path correctly.

I've tried with also with no ".xls" extension, with full path, etc,etc....but the same
result.
I've tried with JDBC Explorer from Borland JBuilder3 but nothing.
What is my mistake? If you know please tell me. I think is something very
simple but i really don't know what it is.

Johnathan Day
September 23rd, 2000, 04:17 PM
For what it is worth...
I've not been able to get the Excel driver
to return data to any other ODBC compliant
applications. All other drivers seem okay, the word around the office is that it is buggy.