at - Job with Windows NT
Posted in 2000
Topics: Connectivity: ODBC / JDBC / .NET, Versions, Editions & End-of-Life
Hi, we have a program (written in Delphi) that uses Informix ODBC 3.31. It has to run each night. It reads rows from one database, converts them und puts them to another database. (IDS 7.31 and IDS2000) Starting it as user XXX all works fine. Starting it from an "at - job", we get trouble with the DATE-format. I suppose with the "at - job" the settings of setnet.exe are not be known to the Informix ODBC 3.31 driver. I tried the following: - Defining a setnet environment for nt-user administrator - set DBDATE=DMY4. in the batch program which calls the convert programm - set DBDATE=DMY4. in nt system environment All this doesn't help, we always get the error message that month doesn't match. How can we tell the "at - job" the informix environment we need? If anybody has an idea please tell me. TIA Reinhard
In article <8bv0h2$rn1$1@news05.btx.dtag.de>, Reinhard Habichtsberg
<Reinhard.Habichtsberg@unilux.de> writes
>Hi,
>
>we have a program (written in Delphi) that uses Informix ODBC 3.31. It has to
>run each night.
>It reads rows from one database, converts them und puts them to another
>database.
>(IDS 7.31 and IDS2000)
>
>Starting it as user XXX all works fine.
>
>Starting it from an "at - job", we get trouble with the DATE-format.
>
>I suppose with the "at - job" the settings of setnet.exe are not be known to
>the Informix ODBC 3.31 driver.
>
>I tried the following:
>- Defining a setnet environment for nt-user administrator
>- set DBDATE=DMY4. in the batch program which calls the convert programm
>- set DBDATE=DMY4. in nt system environment
>
set DBDATE=DMY4/ ^
>All this doesn't help, we always get the error message that month doesn't match.
>
>How can we tell the "at - job" the informix environment we need?
>
>If anybody has an idea please tell me.
>
>TIA
>Reinhard
>
>
>
>
--
David Williams