Informix and VB with ADO OLE DB 
Author Message
 Informix and VB with ADO OLE DB

Hi,
I have a program in VB which connects to Informix 9.21 on Linux.
When I connect and work with the program everything is fine but the dates.
It cannot recognize my date format. I know the default for Informix is MDY,
but I want to change it to DMY4/ .
I have worked with JDBC previously and I know there's a way to specify with
DBDATE the format you would like to work with, you just simply put it on the
connection string.... but here with OLE DB how is it done? I have looked for
some info on the manuals, but found nothing...  and tried puting the DBDATE
value on the connection string but it doesn't work... I also have tried to
set the setnet variable DBDATE, but no success.

Does anyone can help me with this...
Thnx



Fri, 19 Mar 2004 23:12:47 GMT
 Informix and VB with ADO OLE DB

Christian Robles schrieb:

Quote:
> I have a program in VB which connects to Informix 9.21 on Linux.
> When I connect and work with the program everything is fine but the dates.
> It cannot recognize my date format. I know the default for Informix is MDY,
> but I want to change it to DMY4/ .

The only date format supported by OLE DB is YYYY-MM-DD, so set DBDATE accordingly
in setnet32. In your VB program, use the FORMAT method to display the dates the
way you want.

HTH, Richard
--
+-------------------------------+---------------------------------------+

| Klinik fr Anaesthesiologie   | Tel : +49-89-7095-6110                |
| Klinikum der Univ. Mnchen    | FAX : +49-89-7095-6420                |
| 81366 Mnchen, Germany        | GSM : +49-172-8933578                 |
+-------------------------------+---------------------------------------+



Sat, 20 Mar 2004 15:19:32 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. VB and ADO OLE DB with Informix Dates

2. Updatable ADO OLE DB Informix cursors for Informix 7.3

3. Cannot Add Row with Informix OLE DB and ADO

4. Cannot Add Row with Informix OLE DB and ADO

5. Informix OLE DB Provider and ADO?

6. Updateble cursor on VB6 - Informix 7.3 via ADO/OLE DB

7. Cannot Add Row with Informix OLE DB and ADO

8. ADO cursor types with OLE DB Informix 7.2

9. ADO - Informix OLE DB provider

10. ADO OLE DB driver for INFORMIX ?

11. Informix OLE DB Provider and ADO?

12. VB hangs in ADO/OLE DB/Oracle project


 
Powered by phpBB® Forum Software