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

[Dave A. <da...@ca...>]

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