Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007

[Alexander P. <ale...@gm...>]

Fixed.

On 12.11.2013 19:18, Steve Boyd wrote:
> Done!
>
> On 11/11/13 3:27 PM, Alexander Potapchenko 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.
>
>
>
> ------------------------------------------------------------------------
> <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