[Chris Parsons]

I have read all the posts discouraging the use of the JDBC/ODBC Bridge but I need to use this temporarily to retrieve some data from an Excel spreadsheet (yuk)

I can do this successfully in code but the Database Explorer is complaining – I am using the same SQL syntax as the code (see below) but get an error in the log – looks like the square brackets are not being translated perhaps?

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2007-07-25 09:27:15.625
!MESSAGE Error processing query: select  
    item, 
    description 
from 
    [sheet1$]
!STACK 0
java.sql.SQLException: [Microsoft][ODBC Excel Driver] 'sheet1$' is not a valid name.  Make sure that it does not include invalid characters or punctuation and that it is not too long.
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlExecProgress.java:225)
    at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgress.java:181)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

Is this something that can be resolved?

Thanks

Chris Parsons

[Riyad Kalla]

Chris,
I think you are right the sheet name needs to be quoted and isn’t getting quoted so it’s coming out as an invalid name.

Unfortunately if it’s a driver issue, there is nothing we can do, but if it’s a DB Explorer issue we could look into it. I’ll admit, it won’t be the highest priority and likely won’t go into 6.0, so for your temporary needs I don’t know if DBX will fit the bill 🙁

[Chris Parsons]

Yes, I had quoted it with square brackets in the DBX window – looks like this is going to be of limited use to me, never mind

Thanks anyway

Chris

[Riyad Kalla]

Chris,
Sorry about that. I hate saying no to users but with so much on our plate for 6.0 and 6.1, I honestly don’t know that management would prioritize this in time for it to get into 6.0 for you.

Thanks for understanding.

[zlatan24]

@cparsons wrote:

I have read all the posts discouraging the use of the JDBC/ODBC Bridge but I need to use this temporarily to retrieve some data from an Excel spreadsheet (yuk)

I can do this successfully in code but the Database Explorer is complaining – I am using the same SQL syntax as the code (see below) but get an error in the log – looks like the square brackets are not being translated perhaps?

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2007-07-25 09:27:15.625
!MESSAGE Error processing query: select  
    item, 
    description 
from 
    [sheet1$]
!STACK 0
java.sql.SQLException: [Microsoft][ODBC Excel Driver] 'sheet1$' is not a valid name.  Make sure that it does not include invalid characters or punctuation and that it is not too long.
    at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
    at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.processQuery(SqlExecProgress.java:225)
    at com.genuitec.eclipse.sqlexplorer.views.SqlExecProgress.run(SqlExecProgress.java:181)
    at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)

Is this something that can be resolved?

Thanks

Chris Parsons

Some weeks ago to me came a friend,and said about his problem with damaged excel files,I advised him-Microsoft Excel file not recognizable virus infection,And program helped him very good.I advised it to him,because tool helped me many times and it has free status as is known.Moreover program can too help you to repair damaged files in Microsoft Excel sheet recognizable format.

[support-shalini]

zlatan24,
Thank you for posting your findings

[zlatan24]

This message has not been recovered.

[Author]

Posts