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.Tabl es, 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.googlegr oups.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.Tabl es, restricts);
>
> I would appreciate it if someone can tell me what could be the problem.
>
> Thank you in advance for your help.
>
> Sunny
>

Hi M.Kovacic,

I tried that but from dbaccess said that the table to be created in
coledbp.sql was already created. I am setting up the Informix for
Window, so there is no cdotnet.sql , I guess.

What should I do to fix this problem then?

Thank you in advance,
Sunny

M.Kovacic wrote:
> 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.googlegr oups.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.Tabl es, restricts);
> >
> > I would appreciate it if someone can tell me what could be the
problem.
> >
> > Thank you in advance for your help.
> >
> > Sunny
> >