Hi Steve,
It is a bug in the Firebird ODBC driver. Create issue in the bug tracker
http://tracker.firebirdsql.org/browse/ODBC please.
On 11.11.2013 23:23, Steve Boyd wrote:
> 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.
>
> Is there any chance that this peculiar SQL syntax could be recognized
> by the ODBC driver?
>
> Thanks
>
>
>
>
> ------------------------------------------------------------------------
> <http://www.avast.com/>
>
> This email is free from viruses and malware because avast! Antivirus
> <http://www.avast.com/> protection is active.
>
>
>
> ------------------------------------------------------------------------------
> November Webinars for C, C++, Fortran Developers
> Accelerate application performance with scalable programming models. Explore
> techniques for threading, error checking, porting, and tuning. Get the most
> from the latest Intel processors and coprocessors. See abstracts and register
> http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
--
Alexander Potapchenko
Team leader
LASP Technologies, http://www.lasptech.ru
|
