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

[Steve B. <sbo...@gm...>]

When I replace \windows\system32\odbcfb.dll with this one I can no 
longer access the datasource at all. I get an DLL load error. Is the 
supplied DLL the 32-bit or 64-bit version? If 32-bit, can I get the 64-bit?

Thanks

On 11/12/13 1:10 PM, Alexander Potapchenko wrote:
> 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
>
>
> ------------------------------------------------------------------------------
> 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



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com