CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: JDBC problem

  1. #1
    Join Date
    Aug 2000
    Posts
    9

    JDBC problem

    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.



  2. #2
    Join Date
    Sep 2000
    Posts
    2

    Re: JDBC problem

    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.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured