Re: Date-Fields via ADO

From: Ross McKay (rosko_at_zeta.NOT.THIS.BIT.org.au)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 07:41:54 GMT

On Wed, 28 Apr 2004 00:06:03 -0700, André wrote:

>Suppose I do have a neat, clean new system on my computer.
>What do I need to connect to my firebird-database on the server via
>MS-Query?

* Interbase client (usually need to install this first)
* an Interbase ODBC driver

>So far I do have MDAC 2.7 installed on Win2k and I do have installed 2
>different ODBC-drivers for Firebird.
>
>I do not have any problems with field types besides with type "date". On
>_one_ machine even "date"-fields are working, but until now I cannot find
>out, what is different on this machine.
>
>All machines have MDAC 2.70.9001 installed.

G'day André,

Firstly, I must come clean and say that I haven't played with Firebird.
My experience is with 4.2-6.0 of Interbase. However, AFAIK the basic
communications requirements are similar - you need to install the
client, then the ODBC driver, to be able to connect to Interbase.

It sounds to me like you have two different Interbase clients installed
on separate computers. The likely cause is that you installed the
Firebird server on one of these computers, so it got an updated client
into the bargain. The outdated client could have come from anywhere -
perhaps another Interbase version?

Compare the versions of the GDS32.DLL files on both computers, find this
file under the \WINNT\System32 folder. If they differ, there's your
answer.

I notice that Easysoft have their own news server and that it carries
specific newsgroups for supporting their drivers, so maybe you'd get
more knowledgeable replies if you tried pointing your newsreader there:

        server: news.easysoft.com
        group: easysoft.public.ib7-odbc

Of course, I'm still happy to continue this conversation here though :) 

-- 
"There is more to life than simply increasing its speed." - Mahatma Gandhi

Relevant Pages

  • Re: Source version control for Delphi 7
    ... I found the Jedi VCS server (I was using SQL ... it looked as if no-one had ever tried to install it. ... But maybe the Jedi VCS is better for FireBird. ... client for another project where someone else set up and configured the ...
    (borland.public.delphi.non-technical)
  • Problem installing advanced client - ccmsetup service stays active.
    ... I am having a problem with 1 PCinstalling the advanced client. ... -Pushed client install from console but install ... SMS Advanced Client is not installed. ...
    (microsoft.public.sms.setup)
  • RE: Fax monitor incoming + outgoing calls?
    ... The detail steps to install share fax client as follows: ... Start server management console, locate Client Computers node, click ... To the folder redirection GPO issue: ... How to stop Folder Redirection in Windows Server 2003 and in Windows 2000 ...
    (microsoft.public.windows.server.sbs)
  • RE: Where does SBS store its client updates?
    ... Thanks for updates. ... I am sorry to hear that SP2 have bring you some inconvenience, ... from the client application. ... You have to remove it manually after install ...
    (microsoft.public.windows.server.sbs)
  • RE: Real Player Working with SBS 2003
    ... > I understand that you encountered problem when using real player on the SBS ... > domain on one of the client computer. ... > Please note that we only need configure the SBS server if you have ISA ... > Install the ISA Firewall client from the Server. ...
    (microsoft.public.windows.server.sbs)