Re: [Firebird-odbc-devel] MS Office compatability

[Olaf K. <ola...@sa...>]

Hello,

yes, I have testet it with firebird odbc 2.0.0.150. I use two connections to
firebird. All tables are connected to a system.dsn, stored procedures with
an ADO-connection.

What operating sytem you are using on your clients? 32 or 64bit? Can you
connect with the ODBC-DSN (Test-Button). 

Olaf

Thanks Olaf

Can you confirm that you are using MS Office with the latest version
(RC2) of the Firebird driver.

I am looking for an explanation why the driver works perfectly on my machine
but fails to connect on the client's desktop machines which have MS Office
installed. It works on their server which does not have MS Office. The
connection string and user details are all correct.

On 22/03/11 11:43, Olaf Kluge wrote:
>
> Hello Dave,
>
> since Microsoft Windows XP, MDAC 2.8 is integrated. In Windows 2000 
> you need to install the MDAC manually.
>
> We use Microsoft Office, especially Access to connect to firebird. I 
> have tested the gemini-odbc-driver, also the firebird-odbc-driver and 
> both works very well within all me known firebird-versions.
>
> You can use ODBC with all Applications using ODBC. With the 
> odbc-driver-manager you can test the connection to firebird.
>
> Best regards, Olaf
> _____________________
>
>
>
> My client is unsuccessful in connecting to the database using the ODBC 
> driver. I have tested the driver on all my machines and it works.
>
> Reading up on this, I discovered that MS Office (and other MS 
> products) install a different set of MDAC components. On the MS 
> knowledgebase, I discovered this:
>
> "With so many recent MDAC releases, applications have experienced 
> version incompatibility issues under certain circumstances."
>
> All my client's machines have MS Office installed, but I don't use it.
> Is the Firebird driver compatable with MS Office?

-- 

Dave Albiston

Cairngorm Software Ltd

Phone No. +44 (0)1383 729087
Mobile No. +44 (0)7711 904030