Re: Error getting metadata information from Informix...
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.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
> >