Ingres ODBC on Windows 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramaiyan:Palanivel - 27 Jan 2004 18:54 GMT

I have installed the Ingres ODBC drivers on the w2k machine. The database
connection is through. The problem here is Ingres is giving the error
message on the date format being wrong. I set the Date to MM/dd/yyyy on the
Regional settings of that PC.

Anyone has any idea what could be wrong?

Thanks!

Palani

Reply to this Message

Mike Lay - 28 Jan 2004 12:54 GMT

> I have installed the Ingres ODBC drivers on the w2k machine. The database
> connection is through. The problem here is Ingres is giving the error
[quoted text clipped - 6 lines]
>
> Palani

Well, that depends on what date format you were expecting, and what date
format the target machine is expecting. I've noted problems where the
two disagree (US vs European for example).

Fire up a DOS box and type INGPRENV. You should see something like

C:\>ingprenv
II_LANGUAGE=ENGLISH
II_TIMEZONE_NAME=UNITED-KINGDOM
TERM_INGRES=IBMPC
II_INSTALLATION=II

Signature

Mike Lay - Clinical Trial Service Unit
"I can barely speak for myself, let alone the CTSU"
w: http://www.ctsu.ox.ac.uk/
e: michael dot lay at ctsu (with an ox, an ac, and an uk on the end).

Reply to this Message