Menu
▾
▴
firebird-odbc-devel
|
From: André K. <Kna...@be...> - 2013-03-20 13:26:50
|
Hi Gang! Is there a known technical reason why I can open literally any ODBC driven data source in MS Word (2007 and higher), but *not* Firebird? Do I have to make any settings which escaped me so far, or will it just not work or is the problem widely unknown so far? I'd like to prepare some views in Firebird and make them available for some assistants (creating mail merges). There is no problem in MS Excel (via MSQuery), but using the same *.dqy throws "unable to connect to datasource: library 'C:\program files\Firebi' failed to load", with an additional information "SQL-Status 08004, return code: SQL_ERROR". Creating a new connection throws "Unable to retrieve table metadata" (original in German: "Es konnten keine Tabellenlisten von der Datenquelle bezogen werden"). using driver .152 thanks for any hint. |
|
From: Maury M. <mau...@gm...> - 2013-03-20 13:32:14
|
> Hi Gang! > > Is there a known technical reason why I can open literally any ODBC > driven data source in MS Word (2007 and higher), but *not* Firebird? This may be a problem with 32-bit vs. 64-bit versions of the connector. A number of components of the MS stack are still 32-bit only. This includes MS Query, and I believe may be true for VBA in general, or at least it's ADO resources. You may wish to try installing both the 32-bit and 64-bit versions, making separate DSN's for them, and seeing if that helps. On 2013-03-20, at 9:28 AM, André Knappstein wrote: |
|
From: André K. <Kna...@be...> - 2013-03-20 14:35:33
|
Thanks for the reply, Maury. Sorry for not specifying this from the beginning. Problem is in 32-Bit-only OS, Win7. Did not even try on 64-Bit Did try with a locally installed 32-Bit 2.5 Superserver and a remote 1.5.6 Classic Server. >> Hi Gang! >> >> Is there a known technical reason why I can open literally any ODBC >> driven data source in MS Word (2007 and higher), but *not* Firebird? > This may be a problem with 32-bit vs. 64-bit versions of the connector. > A number of components of the MS stack are still 32-bit only. This > includes MS Query, and I believe may be true for VBA in general, or at least it's ADO resources. > You may wish to try installing both the 32-bit and 64-bit versions, > making separate DSN's for them, and seeing if that helps. > On 2013-03-20, at 9:28 AM, André Knappstein wrote: > ------------------------------------------------------------------------------ > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_d2d_mar > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel |
|
From: Thomas S. <ts...@ib...> - 2013-03-20 19:32:30
|
> Is there a known technical reason why I can open literally any ODBC > driven data source in MS Word (2007 and higher), but *not* Firebird? > > Do I have to make any settings which escaped me so far, or will it > just not work or is the problem widely unknown so far? I'd like to > prepare some views in Firebird and make them available for some > assistants (creating mail merges). > > There is no problem in MS Excel (via MSQuery), but using the same > *.dqy throws "unable to connect to datasource: library 'C:\program > files\Firebi' failed to load", with an additional information > "SQL-Status 08004, return code: SQL_ERROR". > > Creating a new connection throws "Unable to retrieve table metadata" > (original in German: "Es konnten keine Tabellenlisten von der > Datenquelle bezogen werden"). What Firebird user are you using for connecting? Is it SYSDBA or the database owner? -- With regards, Thomas Steinmaurer http://www.upscene.com/ |
|
From: André K. <Kna...@be...> - 2013-03-21 11:57:54
|
>> Is there a known technical reason why I can open literally any ODBC >> driven data source in MS Word (2007 and higher), but *not* Firebird? >> >> Do I have to make any settings which escaped me so far, or will it >> just not work or is the problem widely unknown so far? I'd like to >> prepare some views in Firebird and make them available for some >> assistants (creating mail merges). >> >> There is no problem in MS Excel (via MSQuery), but using the same >> *.dqy throws "unable to connect to datasource: library 'C:\program >> files\Firebi' failed to load", with an additional information >> "SQL-Status 08004, return code: SQL_ERROR". >> >> Creating a new connection throws "Unable to retrieve table metadata" >> (original in German: "Es konnten keine Tabellenlisten von der >> Datenquelle bezogen werden"). > What Firebird user are you using for connecting? Is it SYSDBA or the > database owner? SYSDBA for the first test. |
|
From: Alexander P. <ale...@gm...> - 2013-03-21 20:23:10
|
Hi, Tell in-depth information how to reproduce your problem please. On 20.03.2013 17:28, André Knappstein wrote: > Hi Gang! > > Is there a known technical reason why I can open literally any ODBC > driven data source in MS Word (2007 and higher), but *not* Firebird? > > Do I have to make any settings which escaped me so far, or will it > just not work or is the problem widely unknown so far? I'd like to > prepare some views in Firebird and make them available for some > assistants (creating mail merges). > > There is no problem in MS Excel (via MSQuery), but using the same > *.dqy throws "unable to connect to datasource: library 'C:\program > files\Firebi' failed to load", with an additional information > "SQL-Status 08004, return code: SQL_ERROR". > > Creating a new connection throws "Unable to retrieve table metadata" > (original in German: "Es konnten keine Tabellenlisten von der > Datenquelle bezogen werden"). > > using driver .152 > > thanks for any hint. > > > -- Alexander Potapchenko Team leader LASP Technologies, http://www.lasptech.ru |
|
From: André K. <Kna...@be...> - 2013-03-22 12:19:42
|
Alexander, I am probably not too good in providing what you need to help me, so if the following is not sufficient, please ask for more. I will describe the steps leading to the error. I suppose that the database itself and the ODBC DSN are fine because they work well in other applications. 1.) Open MSWord (2007) (SP3) 2.) Select tab "Mailings" 3.) Select "Select recipients" (or similar label...) 3.) Select "use an existing list" 4.) Select "New Datasource" 5.) Select "ODBC/DSN" from the list 6.) Select any valid ODBC-DSN pointing to any Firebird database german error message: Es konnten keine Tabellenlisten von der Datenquelle bezogen werden (Unable to retrieve table metadata from data source) > Hi, > Tell in-depth information how to reproduce your problem please. > On 20.03.2013 17:28, André Knappstein wrote: >> Hi Gang! >> >> Is there a known technical reason why I can open literally any ODBC >> driven data source in MS Word (2007 and higher), but *not* Firebird? >> >> Do I have to make any settings which escaped me so far, or will it >> just not work or is the problem widely unknown so far? I'd like to >> prepare some views in Firebird and make them available for some >> assistants (creating mail merges). >> >> There is no problem in MS Excel (via MSQuery), but using the same >> *.dqy throws "unable to connect to datasource: library 'C:\program >> files\Firebi' failed to load", with an additional information >> "SQL-Status 08004, return code: SQL_ERROR". >> >> Creating a new connection throws "Unable to retrieve table metadata" >> (original in German: "Es konnten keine Tabellenlisten von der >> Datenquelle bezogen werden"). >> >> using driver .152 >> >> thanks for any hint. >> >> >> mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: kna...@be... Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 |
|
From: André K. <Kna...@be...> - 2013-03-22 12:50:20
|
houh, hough, hough... brrrr. please accept my apologies for stealing your time. I remembered that I can also make a "trace" of ODBC calls, something that Mr. Tsvigun once used to find and eliminate a problem in the driver (around 2004). While trying to create the trace I saw that, for whatever reason I'll never understand, I had installed an outdated ODBC driver on this machine. Re-Installing .152, all seems to work fine. Please excuse me for the trouble. Will you come to Luxemburg this year? There are so many guys here I am owing a round of best czech or belgian beer for all the time I'm stealing from them, one more won't matter :-) > Hi, > Tell in-depth information how to reproduce your problem please. > On 20.03.2013 17:28, André Knappstein wrote: >> Hi Gang! >> >> Is there a known technical reason why I can open literally any ODBC >> driven data source in MS Word (2007 and higher), but *not* Firebird? >> >> Do I have to make any settings which escaped me so far, or will it >> just not work or is the problem widely unknown so far? I'd like to >> prepare some views in Firebird and make them available for some >> assistants (creating mail merges). >> >> There is no problem in MS Excel (via MSQuery), but using the same >> *.dqy throws "unable to connect to datasource: library 'C:\program >> files\Firebi' failed to load", with an additional information >> "SQL-Status 08004, return code: SQL_ERROR". >> >> Creating a new connection throws "Unable to retrieve table metadata" >> (original in German: "Es konnten keine Tabellenlisten von der >> Datenquelle bezogen werden"). >> >> using driver .152 >> >> thanks for any hint. >> >> >> mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: kna...@be... Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 |
|
From: Alexander P. <ale...@gm...> - 2013-03-22 13:04:46
|
On 22.03.2013 16:52, André Knappstein wrote: > houh, hough, hough... brrrr. > > please accept my apologies for stealing your time. > > I remembered that I can also make a "trace" of ODBC calls, something > that Mr. Tsvigun once used to find and eliminate a problem in > the driver (around 2004). > While trying to create the trace I saw that, for whatever reason I'll > never understand, I had installed an outdated ODBC driver on this > machine. > Re-Installing .152, all seems to work fine. Please excuse me for the > trouble. André, Yes, MS Word 2007 works fine with odbc driver 152. > Will you come to Luxemburg this year? There are so many guys > here I am owing a round of best czech or belgian beer for all the > time I'm stealing from them, one more won't matter :-) > No, I will not come to Luxemburg this year unfortunately :-) Regards, Alexander -- Alexander Potapchenko Team leader LASP Technologies, http://www.lasptech.ru |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X