Menu
▾
▴
Re: [Firebird-odbc-devel] Firebird ODBC 2.0.2.153 with Excel 2007
|
From: Steve B. <sbo...@gm...> - 2013-11-12 20:50:30
|
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? 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 --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com |
