RE: Informix ODBC

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET

MarkS@WORKWISE.com — Tue, 4 May 1999 11:50:25 -0700 — source: Informix-list mailing list archive (1991-1998)

We have not experienced problems in accessing any Informix 7.x database with commonly available ODBC drivers. We have multiple Informix clients using our application integration and/or automated Alerts solutions with the Intersolv 3.10 32 bit driver. Earlier versions of the driver (either from Informix or Intersolv) were reported to have some issues. Mark Selin WorkWise Software Phone: (206) 545-1191 x234 146 North Canal Street, Suite 200 Fax: (206) 545-9442 Seattle, WA 98103 Web: www.workwise.com -----Original Message----- From: Duncan Kinder [mailto:dckinder@ahcbsd1.ovnet.com] Sent: Tuesday, May 04, 1999 12:20 PM To: informix-list@iiug.org Subject: Informix ODBC It is beginning to sound like ODBC with Informix is a real problem. Is there anywhere - website, book - which address this issue comprehensively -- Regards, Duncan C. Kinder dckinder@mountain.net --

↪ replying to MarkS@WORKWISE.com

Ed Brown — Wed, 5 May 1999 08:52:30 -0500 — source: Informix-list mailing list archive (1991-1998)

Have you ever tried returning values from Informix stored procedures using the Intersolv driver? Just curious. We're getting "Optional feature not implemented" errors in ODBC trace when trying to return values to VB6 using RDO.

↪ replying to Ed Brown

Mark Andrews — Wed, 5 May 1999 16:12:36 +0100 — source: Informix-list mailing list archive (1991-1998)

> Have you ever tried returning values from Informix stored procedures using > the Intersolv driver? > Just curious. We're getting "Optional feature not implemented" errors in > ODBC trace when trying > to return values to VB6 using RDO. I've had no problem doing this. i used the ODBC call syntax in an rdoquery. you set the string to " { call SPNAME (?,?...,?) } " in the rdoquery, where the ? denote a parameter, which can be set using the rdoquery.parameter property. execute it, and you can get the return values using the rdocolumns property. I haven't got an example handy at the moment, but if you need one, i can provide one. There is something about this in the books online, but it mostly applies to SQL Server, so ignore what it says about return codes and use the method i just outlined Regards Mark

↪ replying to Ed Brown

Richard Spitz — Thu, 06 May 1999 10:05:12 +0200 — source: Informix-list mailing list archive (1991-1998)

Ed Brown wrote: > Just curious. We're getting "Optional feature not implemented" errors in > ODBC trace when trying > to return values to VB6 using RDO. Are you sure this is the "real" error you are getting? Check for the other error numbers/descriptions in the errors collection to see whether there might be some other problem. I got the "Optional feature not implemented" error as errors(0).description when the actual problem was really an incorrect password, which was correctly announced in errors(1).description. HTH, Richard -- +--------------------------+------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-6110 | | Klinikum Grosshadern | FAX : +49-89-7095-6420 <-- NEW!!! | | 81366 Munich, Germany | GSM : +49-172-8933578 | +--------------------------+------------------------------------------+