[PHP] Informix Connection
I have php 4.1.2 running on a linux 7.2 box. I want to make a connection to an Informix 7.2SE database running on a HP-UX 10.2 box. My issues are as follows - 1) Do I need informix software of any description running on the linux web server? 2) Can I configure the php informix modules into and up and running php build that doesn't currently have these modules. 3) Is there a step by step or guide on this type of connection anywhere? This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Informix Connection
Speaking form experience, get ready for a few headaches on this. edit /usr/informix/etc/sqlhosts and have it look like this: demo_on onipcshmon_hostname on_servername demo_se seipcpipse_hostname sqlexec archives1 setlitcp archives1.mdah.state.ms.us sqlexec where archives1 is your host name. Have /usr/informix/lib/sqlexecd archives1 running (I have it start on startup and then wait 5 seconds and then start apache, seems to need this elay for whatever reason. You will need the Informix SDK installed on your box, it has the nessessary libs and stuff that php will need. You will need to compile php using --with-informix. I'll email you back in a second with an email sent to me on how to compile it all. Adam On Thu, 3 Oct 2002, Mark Colvin wrote: I have php 4.1.2 running on a linux 7.2 box. I want to make a connection to an Informix 7.2SE database running on a HP-UX 10.2 box. My issues are as follows - 1) Do I need informix software of any description running on the linux web server? 2) Can I configure the php informix modules into and up and running php build that doesn't currently have these modules. 3) Is there a step by step or guide on this type of connection anywhere? This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] informix connection problem
hi, we are using informix 7.31.UC6 as our database server. when we are trying to connect informix by dbaccess we are setting the below environment variables are as: export DBNLS=1;export LANG=tr_TR;export LC_COLLATE=tr_TR.ISO8859-9;export LC_CTYPE=tr_TR.ISO8859-9 but when we are rying to vonnect informix by PHP i am using the following commands to set those variables __ putenv(DBNLS=1); putenv(LANG=tr_TR); putenv(LC_COLLATE=tr_TR.ISO8859-9); putenv(LC_CTYPE=tr_TR.ISO8859-9); $veri_baglan = ifx_connect(mydb@ol_srv1 ,XXX,XXX); if (! $veri_baglan) die (Informix connection error); __ but I am usually getting this connection error message: Warning: ifx_connect : E [SQLSTATE=IX 000 SQLCODE=-23115] in /home/sapphire/public_html/PHP/lib_functions/a.php on line 18 Informix connection error and sometimes, strangely we are connecting to the database.. the informix configuration in the php.ini file is as: ifx.allow_persistent = On ifx.max_persistent = -1 ifx.max_links = -1 ifx.textasvarchar = 0 ifx.byteasvarchar = 0 ifx.charasvarchar = 0 ifx.blobinfile = 0 ifx.nullformat = 0 This error information is about locales,but the env. variables are set to true values that we can connect to database from command prompt, and sometimes by PHP.. What is the problem, why are we sometimes connecting and sometimes not able to? What else should I set or do? Thank you for the answers.. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]