[Firebird-odbc-devel] Using Firebird ODBC in MS Word
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. -- 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 Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Re: [Firebird-odbc-devel] Using Firebird ODBC in MS Word
> 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 Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Re: [Firebird-odbc-devel] Using Firebird ODBC in MS Word
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 > Firebird-odbc-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel -- 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 Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
Re: [Firebird-odbc-devel] Using Firebird ODBC in MS Word
> 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/ -- 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 Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
