Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unknown token errors when attempting to access Firebird 2.5 from Excel 2007 [ODBC169] #161

Closed
firebird-automations opened this issue Nov 12, 2013 · 6 comments

Comments

@firebird-automations
Copy link

Submitted by: Stephen Boyd (sboydlns)

Attachments:
OdbcFb.zip
OdbcFb_x64.zip

When trying to retrieve data into Excel from a Firebird 2.5 database using the Firebird ODBC driver V2.0.2.153 I get an error after I click OK on the Import Data dialogue. The error is:

Dynamic SQL error
SQL error code = -104
Unknown token Line 1 column 27 '.'

Since this clearly had something to do with the SELECT statement I tried clicking the Properties button on the Import Data dialogue. The SELECT statement generated by Excel is as follows:

Select * from "Operations"."Accounts"

where Operations in the ODBC data source name.

The Firebird ODBC driver apparently doesn't like this very much since removing "Operations". from the query gets everything working. While this bit of manual command editing doesn't bother me overly much it would be a big issue to end users who are trying to pull their data into a spreadsheet.

Commits: 50676cb 2ddb965

@firebird-automations
Copy link
Author

Commented by: @alexpotapchenko

Fixed in CVS. The attached driver for testing

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.3 [ 10581 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb.zip [ 12384 ]

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

Attachment: OdbcFb_x64.zip [ 12385 ]

@firebird-automations
Copy link
Author

Commented by: Stephen Boyd (sboydlns)

I have tested the fix and it seems to be working. Thanks for the prompt patch.

@firebird-automations
Copy link
Author

Modified by: @alexpotapchenko

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants