RE: Does Informix OLEDB support OpenSchema?

Posted in 2003

Roger Lacson — Thu, 5 Jun 2003 14:51:18 -0700 — source: Usenet: comp.databases.informix

Malky, Could you help me how did you setup your ODBC and the string provider did you used. Thanks, I'm glad and appreciate your response in advance. Thankx, Roger Lacson -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]On Behalf Of malky Sent: Wednesday, June 04, 2003 3:32 AM To: informix-list@iiug.org Subject: Does Informix OLEDB support OpenSchema? hi, here is code example: Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset conn.Open "Provider=ifxoledbc;Data Source=my_db;User=informix;Password=informix" Set rs = conn.OpenSchema(adSchemaTables) connection opens successfully, but on OpenSchema i'm getting: ADODB.Connection error number 3251: "Object or provider is not capable of performing requested operation." NOTE: schema opens successfully if i use ODBC. it is only OLEDB problem. is it a known limitation, or there *is* a solution? thanks a lot, malky