Oninit cdi / Archive
Talk to an expert →

Re: INFORMIX OLE DB Provider Connection problem

Posted in 1999

Topics: Server Administration, Security, Permissions & Auditing

Leopold The Cat — — source: Informix-list mailing list archive (1991-1998)

This often happens when people forget to run coledbp.sql against sysmaster. Leopold Vadim Lou <Vad@softline.kiev.ua> wrote in message news:VDM63491BAD33@vadim.softline.kiev.ua... > > Provider = Ifxoledbc.2 > > ADO ConnectionString = Provider=Ifxoledbc.2;Data > Source=stores7@ol_global;User ID=dbadmin;Password=dba;Persist Security > Info=False;Extended Properties="";Connect Timeout=15 > > Connection problem: > > OLE Exception => " X42000:-206:Base table not found " > > Help please ! > > ----------- > Vadim > >

↪ replying to Leopold The Cat
Reinhard Habichtsberg — — source: Informix-list mailing list archive (1991-1998)

Leopold The Cat <leopold_the_cat@yahoo.com> schrieb in im Newsbeitrag: 83m7bb$1li3@webint.na.informix.com... > This often happens when people forget to run coledbp.sql against sysmaster. > We have the same problem. To run coledbp.sql against sysmaster is that only valid for an installation of Informix Server on NT? I did not found this sql-script nor on my UNIX server and nor on my Linux Server. What should I do if I have to connect with OLE DB provider to an Informix Server on Unix box ? Reinhard > Leopold > > Vadim Lou <Vad@softline.kiev.ua> wrote in message > news:VDM63491BAD33@vadim.softline.kiev.ua... > > > > Provider = Ifxoledbc.2 > > > > ADO ConnectionString = Provider=Ifxoledbc.2;Data > > Source=stores7@ol_global;User ID=dbadmin;Password=dba;Persist Security > > Info=False;Extended Properties="";Connect Timeout=15 > > > > Connection problem: > > > > OLE Exception => " X42000:-206:Base table not found " > > > > Help please ! > > > > ----------- > > Vadim > > > > > >

↪ replying to Reinhard Habichtsberg
Leopold The Cat — — source: Informix-list mailing list archive (1991-1998)

Copy it to your UNIX box and run it there? Leopold Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> wrote in message news:83n7as$1cj$1@news06.btx.dtag.de... > > Leopold The Cat <leopold_the_cat@yahoo.com> schrieb in im Newsbeitrag: 83m7bb$1li3@webint.na.informix.com... > > This often happens when people forget to run coledbp.sql against sysmaster. > > > > We have the same problem. To run coledbp.sql against sysmaster is that > only valid for an installation of Informix Server on NT? I did not found this > sql-script nor on my UNIX server and nor on my Linux Server. What should > I do if I have to connect with OLE DB provider to an Informix Server > on Unix box ? > > Reinhard > > > Leopold > > > > Vadim Lou <Vad@softline.kiev.ua> wrote in message > > news:VDM63491BAD33@vadim.softline.kiev.ua... > > > > > > Provider = Ifxoledbc.2 > > > > > > ADO ConnectionString = Provider=Ifxoledbc.2;Data > > > Source=stores7@ol_global;User ID=dbadmin;Password=dba;Persist Security > > > Info=False;Extended Properties="";Connect Timeout=15 > > > > > > Connection problem: > > > > > > OLE Exception => " X42000:-206:Base table not found " > > > > > > Help please ! > > > > > > ----------- > > > Vadim > > > > > > > > > > > >

↪ replying to Leopold The Cat
Reinhard Habichtsberg — — source: Informix-list mailing list archive (1991-1998)

Leopold The Cat <leopold_the_cat@yahoo.com> schrieb in im Newsbeitrag: <83ncf3$bbe1@webint.na.informix.com>... > Copy it to your UNIX box and run it there? > > Leopold > Yes, connection works now. Thank you! Reinhard

↪ replying to Leopold The Cat
Vadim Lou — — source: Informix-list mailing list archive (1991-1998)

Thanks. I found this script in IDS 7.31 TC2 only (7.30 not found). "Leopold The Cat" <leopold_the_cat@yahoo.com> wrote in message news:83m7bb$1li3@webint.na.informix.com... > This often happens when people forget to run coledbp.sql against sysmaster. > > Leopold > > Vadim Lou <Vad@softline.kiev.ua> wrote in message > news:VDM63491BAD33@vadim.softline.kiev.ua... > > > > Provider = Ifxoledbc.2 > > > > ADO ConnectionString = Provider=Ifxoledbc.2;Data > > Source=stores7@ol_global;User ID=dbadmin;Password=dba;Persist Security > > Info=False;Extended Properties="";Connect Timeout=15 > > > > Connection problem: > > > > OLE Exception => " X42000:-206:Base table not found " > > > > Help please ! > > > > ----------- > > Vadim > > > > > >

↪ replying to Reinhard Habichtsberg
Sandra Carr — — source: Informix-list mailing list archive (1991-1998)

Is anyone interested in working as an Informix DBA in Cambridge, MA? If so, please e-mail your resume to sandycarr@mindspring.com. Thanks Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> wrote in message news:83nrlh$62e$1@news05.btx.dtag.de... > Leopold The Cat <leopold_the_cat@yahoo.com> schrieb in im Newsbeitrag: <83ncf3$bbe1@webint.na.informix.com>... > > Copy it to your UNIX box and run it there? > > > > Leopold > > > > Yes, connection works now. Thank you! > > Reinhard > >