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

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

I have attached 64-bit driver too.

On 12.11.2013 22:50, Steve Boyd wrote:
> 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
>
>
>
> ------------------------------------------------------------------------
> <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