Issue Details (XML | Word | Printable)

Key: ODBC-169
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Potapchenko
Reporter: Stephen Boyd
Votes: 0
Watchers: 1

If you were logged in you would be able to see more operations.
ODBC Driver

Unknown token errors when attempting to access Firebird 2.5 from Excel 2007

Created: 12/Nov/13 03:16 PM   Updated: 01/Jan/15 03:30 PM
Component/s: None
Affects Version/s: 2.0.2
Fix Version/s: 2.0.3

File Attachments: 1. Zip Archive (1.16 MB)
2. Zip Archive (1.50 MB)

Environment: Firebird 2.5 on Window 2008

 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Potapchenko added a comment - 12/Nov/13 04:52 PM
Fixed in CVS. The attached driver for testing

Stephen Boyd added a comment - 12/Nov/13 08:54 PM
I have tested the fix and it seems to be working. Thanks for the prompt patch.