Menu
▾
▴
Re: [Firebird-odbc-devel] MS Office compatability
|
From: Bart S. <bar...@gm...> - 2011-03-23 12:08:12
|
Can you connect in Excel via ADO, ODBC and a DSN-less connection string with some VBA code? RBS On Wed, Mar 23, 2011 at 11:04 AM, Dave Albiston <da...@ca...> wrote: > Hi there > > The configuration settings are correct. We proved it by setting up a dsn > on the actual database server with the same settings and it worked. > > It does not work on the workstations. But the same settings are used in > a delphi application running on the workstations which connects without > a problem. > > Judging by the feedback on this thread, it sounds like MS Office is not > an issue. > > Is there a way to investigate why I get the > > "Open database 'server_name:alias_name' failed" > > Is there a trace log of some kind? There appears to be something > peculiar about my client's PCs. The driver works on everything else I > have tested it on. > > > On 23/03/11 10:10, Marco Held wrote: >> Hello Dave, >> >> when pressing the Test button, do you get any error message? Please send us >> all your settings you filled in to the configuration of the ODBC DSN. >> >> Regards, Marco >> >> >> >> >> Marco Held >> >> phone: +49 271 77202 27 >> e-mail: mh...@de... >> >> >> >> demig Prozessautomatisierung GmbH – www.demig.de – in...@de... >> Haardtstraße 40 – D-57076 Siegen – Tel. +49 271 77202 0 – Fax +49 271 >> 77202 92 >> Registergericht Siegen HRB 2819 – Geschäftsführer Joachim Herbst, Winfried >> Held >> >> -----Ursprüngliche Nachricht----- >> Von: Dave Albiston [mailto:da...@ca...] >> Gesendet: Mittwoch, 23. März 2011 10:43 >> An: Bart Smissaert >> Cc: fir...@li... >> Betreff: Re: [Firebird-odbc-devel] MS Office compatability >> >> Hi Bart >> >> We are using server_name:alias_name. It work fine with the my Delphi >> application so I think it can be ruled out as the cause of the problem. >> >> We are not using Office to connect. At the moment we are just trying to >> set up the System dsn but the Test connection button always fails. >> >> I was under the impression that Office installs a different set of MDAC >> components but that doesn't seem to be an issue. >> >> On 23/03/11 08:39, Bart Smissaert wrote: >>> Have been using the Phoenix ODBC driver with various Office versions >>> for years and no problem. >>> Find that if there is any trouble it usually is a faulty connection >> string. >>> What is the connection string you are using? >>> >>> RBS >>> >>> >>> On Wed, Mar 23, 2011 at 8:25 AM, Dave Albiston >>> <da...@ca...> wrote: >>>> Hi Olaf >>>> >>>> My client is using 32 bit XP with Office 2003 and Office 2007. At the >>>> moment we are just trying to set up the ODBC connection but the Test >>>> Connection button always fails. >>>> >>>> A delphi application (using IBX components) is working so we know the >>>> connection string and login credentials are correct and that the link >>>> from the Firebird client to the server is OK. >>>> >>>> Is there some way to trace the cause of the failure with ODBC? >>>> >>>> On 22/03/11 14:43, Olaf Kluge wrote: >>>>> >>>>> 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 >>>> >>>> >> ---------------------------------------------------------------------------- >> -- >>>> Enable your software for Intel(R) Active Management Technology to meet >> the >>>> growing manageability and security demands of your customers. Businesses >>>> are taking advantage of Intel(R) vPro (TM) technology - will your >> software >>>> be a part of the solution? Download the Intel(R) Manageability Checker >>>> today! http://p.sf.net/sfu/intel-dev2devmar >>>> _______________________________________________ >>>> Firebird-odbc-devel mailing list >>>> Fir...@li... >>>> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel >>>> >>> >> > > -- > > Dave Albiston > > Cairngorm Software Ltd > > Phone No. +44 (0)1383 729087 > Mobile No. +44 (0)7711 904030 > > ------------------------------------------------------------------------------ > Enable your software for Intel(R) Active Management Technology to meet the > growing manageability and security demands of your customers. Businesses > are taking advantage of Intel(R) vPro (TM) technology - will your software > be a part of the solution? Download the Intel(R) Manageability Checker > today! http://p.sf.net/sfu/intel-dev2devmar > _______________________________________________ > Firebird-odbc-devel mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel > |
