Re: INFORMIX OLE DB Provider Connection problem
Vadim Lou had an Informix OLE DB provider connection problem. Leopold The Cat said this often happens when coledbp.sql has not been run against sysmaster. Reinhard Habichtsberg, with the same problem on Unix and Linux servers, was told to copy the script to the Unix box and run it there, and the connection then worked. Vadim found the script only in IDS 7.31 TC2, not 7.30. Solved. One unrelated recruitment post followed.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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 > >
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 > > > > > >
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 > > > > > > > > > > > >
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
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 > > > > > >
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 > >