Re: Informix error with ifx_pconnect()
On Mon, 24 May 2004 09:02:37 -0400, D. Sandmann wrote: > Still have not resolved this, any help from this group would be appreciated. > > Thanks, > David You are correct that this problem is related to environment either that or an installation problem. If you installed any other Informix products, try reinstalling the CSDK or install a later release of CSDK/iClient. If the Apache interface was compiled with a later SDK than the client's CSDK/iClient version you would also see this problem. Art S. Kagel
Still have not resolved this, any help from this group would be appreciated. Thanks, David "D. Sandmann" <dsandmann@emcosales.com> wrote in message news:10aq15ik5s66ge6@corp.supernews.com... > I have had this problem in the past on another machine and fixed it by > setting the environment variables for INFORMIXDIR and INFORMIXSERVER. When > adding the same lines on the new machine I still get the following message: > > Warning: ifx_pconnect(): E [SQLSTATE=IX 001 SQLCODE=-1829] in > :\\webroot\\PHPinclude\\db_vars.inc on line 7 > > I tried doing what I did before, but still is not working. Doing > "phpinfo();" The following information is displayed: > > PHP Version 4.3.6 > > System Windows NT DAVIDS 5.1 build 2600 > Build Date Apr 14 2004 17:17:11 > Server API Apache 2.0 Handler > > Under apache2handler: > Apache Version Apache/2.0.49 (Win32) PHP/4.3.6 > > Under Apache Environment: > INFORMIXDIR C:\\informix > INFORMIXSERVER dbserver > > And under Environment I have: > INFORMIXDIR C:\\informix > > I am using the Informix-Client 9.21 2.30.TC1. I have been able to connect to > the Informix database using ILogin Demo and I have been able to connect > using WinSQL. > > Any help would be appreciated. > > Thanks, > David > >
What is your connect string, if you are running in safe_mode, and you should be, then php.ini values will be ignored for uid, passwd etc "D. Sandmann" wrote: > > Still have not resolved this, any help from this group would be appreciated. > > Thanks, > David > > "D. Sandmann" <dsandmann@emcosales.com> wrote in message > news:10aq15ik5s66ge6@corp.supernews.com... > > I have had this problem in the past on another machine and fixed it by > > setting the environment variables for INFORMIXDIR and INFORMIXSERVER. When > > adding the same lines on the new machine I still get the following > message: > > > > Warning: ifx_pconnect(): E [SQLSTATE=IX 001 SQLCODE=-1829] in > > :\\webroot\\PHPinclude\\db_vars.inc on line 7 > > > > I tried doing what I did before, but still is not working. Doing > > "phpinfo();" The following information is displayed: > > > > PHP Version 4.3.6 > > > > System Windows NT DAVIDS 5.1 build 2600 > > Build Date Apr 14 2004 17:17:11 > > Server API Apache 2.0 Handler > > > > Under apache2handler: > > Apache Version Apache/2.0.49 (Win32) PHP/4.3.6 > > > > Under Apache Environment: > > INFORMIXDIR C:\\informix > > INFORMIXSERVER dbserver > > > > And under Environment I have: > > INFORMIXDIR C:\\informix > > > > I am using the Informix-Client 9.21 2.30.TC1. I have been able to connect > to > > the Informix database using ILogin Demo and I have been able to connect > > using WinSQL. > > > > Any help would be appreciated. > > > > Thanks, > > David > > > > -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #