[Firebird-odbc-devel] Using Firebird ODBC in MS Word

[André Knappstein]

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.

[Maury Markowitz]

Post by André Knappstein
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:

[André Knappstein]

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.

Post by Maury Markowitz

Post by André Knappstein
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.
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Firebird-odbc-devel mailing list
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

[Thomas Steinmaurer]

Post by André Knappstein
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?

[André Knappstein]

Post by Thomas Steinmaurer

Post by André Knappstein
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.

[Alexander Potapchenko]

Hi,

Tell in-depth information how to reproduce your problem please.

Post by André Knappstein
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.

[André Knappstein]

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)

Post by Alexander Potapchenko
Hi,
Tell in-depth information how to reproduce your problem please.

Post by André Knappstein
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: [phone]
Telefax: [phone]
e-mail: ***@beta-eigenheim.de

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

[André Knappstein]

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 :-)

Post by Alexander Potapchenko
Hi,
Tell in-depth information how to reproduce your problem please.

Post by André Knappstein
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: [phone]
Telefax: [phone]
e-mail: ***@beta-eigenheim.de

Amtsgericht Hamm Nr. B 420
Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus

USt-IDNr.: DE 125215402

[Alexander Potapchenko]

Post by André Knappstein
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.

Post by André Knappstein
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