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

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

On 13.11.2013 0:50, Steve Boyd wrote:
> That fixed it. Thank you very much for your prompt response.
>
> I assume that this will get released as an installer image at some point?
Of course.

>
>
> On 11/12/13 2:42 PM, Alexander Potapchenko wrote:
>> 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
>>
>>
>> ------------------------------------------------------------------------------
>> DreamFactory - Open Source REST&  JSON Services for HTML5&  Native Apps
>> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
>> Free app hosting. Or install the open source package on any LAMP server.
>> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
>> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&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.
>
>
>
> ------------------------------------------------------------------------------
> DreamFactory - Open Source REST&  JSON Services for HTML5&  Native Apps
> OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
> Free app hosting. Or install the open source package on any LAMP server.
> Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
> http://pubads.g.doubleclick.net/gampad/clk?id=63469471&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