Error getting metadata information from Informix...

Hi, I am writing an OLEDB client application in .NET to extract metadata information from Informix. I am able to connect to the Informix server. However, when I try to retrieve the metadata information, I can get the following error: EIX000: (-111) ISAM error: no record found. E42000: (-206) The specified table sysmaster:informix.oledbversion) is not in the database. Here is the code snippet that causes the error. object [] restricts = new object[] {null, null, null, "Table"}; DataTable dt = oleDbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, restricts); I would appreciate it if someone can tell me what could be the problem. Thank you in advance for your help. Sunny

You must set/create oledb support in your Informix server (sysmaster database), sql script is located (actually 2; coledbp.sql, cdotnet.sql) in <INFORMIXDIR>/ETC directory (client-sdk installation) This will fix your problem, regards, Matej <sunny076@yahoo.com> wrote in message news:1108174859.190706.200300@g14g2000cwa.googlegroups.com... > > Hi, > > I am writing an OLEDB client application in .NET to extract metadata > information from Informix. I am able to connect to the Informix server. > However, when I try to retrieve the metadata information, I can get the > following error: > > EIX000: (-111) ISAM error: no record found. > E42000: (-206) The specified table sysmaster:informix.oledbversion) is > not in the database. > > Here is the code snippet that causes the error. > > object [] restricts = new object[] {null, null, null, "Table"}; > DataTable dt = > oleDbConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, restricts); > > I would appreciate it if someone can tell me what could be the problem. > > Thank you in advance for your help. > > Sunny >