SEO

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

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
>
>

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

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 #

I am using ifx_pconnect passing the database connection string, login and
password.

I am currently using the Informix-Client SDK 9.53 2.81.TC3 which is now
giving me the following error:

Unknown(): Unable to load dynamic library 'extensions\php_ifx.dll' - the
specified module could not be found.

This is happening when I restart Apache. Going to try a previous version of
the Client see what happens with that.

David

P.S. Previous Client version I was trying was: 9.21 2.30.TC1 which was
working on another computer/version of apache & php.

"Paul Watson" <paul@oninit.com> wrote in message
news:40B20E2D.85C3FAC4@oninit.com...
> 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
>

Just tried CSDK 9.52 2.80.TC1 and got the same message as below. Anyone know
where I can get other versions of the client to try?


"D. Sandmann" <dsandmann@emcosales.com> wrote in message
news:10b4d162clpfl0b@corp.supernews.com...
> I am using ifx_pconnect passing the database connection string, login and
> password.
>
> I am currently using the Informix-Client SDK 9.53 2.81.TC3 which is now
> giving me the following error:
>
> Unknown(): Unable to load dynamic library 'extensions\php_ifx.dll' -
the
> specified module could not be found.
>
> This is happening when I restart Apache. Going to try a previous version
of
> the Client see what happens with that.
>
> David
>
> P.S. Previous Client version I was trying was: 9.21 2.30.TC1 which was
> working on another computer/version of apache & php.

"D. Sandmann" <dsandmann@emcosales.com> wrote in message
news:10b4g5kittjl2af@corp.supernews.com...
> Just tried CSDK 9.52 2.80.TC1 and got the same message as below. Anyone
know
> where I can get other versions of the client to try?

You can get newer versions from IBM's snappily-named URL
http://www14.software.ibm.com/webapp...FM5S&s=c&type=

Have downloaded those versions, still no luck

Thanks anyways,
David

"Neil Truby" <neil.truby@ardenta.com> wrote in message
news:2heueoFccnsjU1@uni-berlin.de...
> "D. Sandmann" <dsandmann@emcosales.com> wrote in message
> news:10b4g5kittjl2af@corp.supernews.com...
> > Just tried CSDK 9.52 2.80.TC1 and got the same message as below. Anyone
> know
> > where I can get other versions of the client to try?
>
> You can get newer versions from IBM's snappily-named URL
>
http://www14.software.ibm.com/webapp...FM5S&s=c&type=
>
>

I note you can connect via the ILogin demo, so IMHO it's probably
not the SDK, more likely to be the php build (unlikely as the
phpinfo seems OK) or the apache built or starting environment. If this
was a proper OS then I'd assume it was a path issue as the error is
a missing library. Is the php_ifx.dll actually on the server?

Can you run a command php connection string, if that works the problem
is apache and/or apache environment

Cheers
Paul

"D. Sandmann" wrote:
>
> I am using ifx_pconnect passing the database connection string, login and
> password.
>
> I am currently using the Informix-Client SDK 9.53 2.81.TC3 which is now
> giving me the following error:
>
> Unknown(): Unable to load dynamic library 'extensions\php_ifx.dll' - the
> specified module could not be found.
>
> This is happening when I restart Apache. Going to try a previous version of
> the Client see what happens with that.
>
> David
>
> P.S. Previous Client version I was trying was: 9.21 2.30.TC1 which was
> working on another computer/version of apache & php.
>
> "Paul Watson" <paul@oninit.com> wrote in message
> news:40B20E2D.85C3FAC4@oninit.com...
> > 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
> >

--
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 #

Interesting concept: RTFM.

;-)

Sorry I couldn't resist. Seriously you should read the PHP
docs that tell you what to do with dll's. You will need to
make the dll available to PHP for your windows environment.
Until you either copy the dll to a place where PHP and your
web server can find it, your dll will not be used at runtime.
Windows is such an abomination when it comes to the environment
so you will probably have to stop/start apache or other web
server several times to test to make sure the dll loads. Until
Apache or other web server is restarted the dll's won't load
at runtime like you would hope. This is pivotal, the dll loads
at web server startup. You can check to see if you have the
support you seek with a simple php program:

<?php
phpinfo();
?>

Save it as 'phpinfo.php' or whatever, and put it in your
htdocs directory. From your web browser, run the phpinfo.php
program. If you don't see the dll in the report it didn't load
and you won't be able to use it. phpMyAdmin calls this function
as well from the front-page menu, so if you have phpMyAdmin
installed you can run that instead of the above phpinfo.php .
You also will probably have to screw around with your php.ini
and also check your apache httpd.conf to make sure apache is
aware of php--all are covered in the fine manuals. There are
several critical apached settings in the httpd.conf, and a
couple of IFMX settings in the php.ini. Get these straight
and you will be set.


"D. Sandmann" <dsandmann@emcosales.com> wrote in message news:10b4j8adrsh4799@corp.supernews.com...
> Have downloaded those versions, still no luck
>
> Thanks anyways,
> David
>
> "Neil Truby" <neil.truby@ardenta.com> wrote in message
> news:2heueoFccnsjU1@uni-berlin.de...
> > "D. Sandmann" <dsandmann@emcosales.com> wrote in message
> > news:10b4g5kittjl2af@corp.supernews.com...
> > > Just tried CSDK 9.52 2.80.TC1 and got the same message as below. Anyone
> > know
> > > where I can get other versions of the client to try?
> >
> > You can get newer versions from IBM's snappily-named URL
> >
> http://www14.software.ibm.com/webapp...FM5S&s=c&type=
> >
> >
>
>