RE: [PHP-INST] PHP + OPENLINK ERROR

Hi Georges, A couple things could cause this problem - basically you have a configuration problem with Openlink, not PHP. Make sure that you can succesfully test the DSN from the PHP box using odbctest before trying to use a DSN from PHP. The error you have received could be caused by either of the following: - the Service Type in the odbc.ini is not on that is recognized - the ing#_sv or oig#_sv agent on the server side is built for the wrong platform, cannot be executed because it's not in a directory with proper permissions, or cannot be found at all. To verify that it is a correct component, try to execute it for a version string: e.g. oig2_sv -? if there is a problem here due to bad file type then it's built for the wrong platform. If you get an error that it cannot find a libiodbc.so.1 or something similar, it means you have not set your environment variables before starting the oprlqb. These are contained in openlink.sh - I recommend putting them in your .profile for ease of use. To verify that they are set, try an: env and look for ODBCINI, ODBCINSTINI, and LD_LIBRARY_PATH. You also may need to append the location of the Ingress lib directory to the LD_LIBRARY_PATH variable, although this is not strictly necessary unless you are trying to connect across build numbers. Start your oplrqb with logging (./oplrqb +loglevel 7) but make sure that you have: . ./openlink.sh before you do so, and then examine the oplrqb.log after reproducing the problem. You should be able to get more info about what is going on. Since this is probably an Openlink configuration issue instead of PHP, please take any future correspondence off-list if you are still experiencing problems after trying these suggestions. You can open a free tech support case at http://www.openlinksw.com/support/suppindx.htm Hope this helps. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Georges da Mata Claessen [mailto:georges@embrapa.br] > Sent: Monday, December 11, 2000 6:35 AM > To: php-general@lists.php.net; php-install@lists.php.net > Subject: [PHP-INST] PHP + OPENLINK ERROR > > > I'm getting this error using PHP 4 with OPENLINK under Solaris 2.7 > > Warning: SQL error: [OpenLink][ODBC]unable to contact the requested > database agent, SQL state 08004 in SQLConnect > in /software/apache/htdocs/estagio/teste/testedesenv.htm on line 2 > > Warning: Supplied argument is not a valid ODBC-Link resource in > /software/apache/htdocs/estagio/teste/testedesenv.htm on line 6 > > We compiled PHP using OPENLINK and we got some errors on the > compilation. Under PHP 3, we could contact the database properly, via > ODBC, but with PHP 4 we always get this error. > > Please if someone from Openlink could help I would be very gratefull. We > are using Ingres here. > > Georges. > > > -- > PHP Install Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-install-unsubscribe@lists.php.net > For additional commands, e-mail: php-install-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >