Re: PHP + OPENLINK ERROR

Hi Andrew, remember me? In fact, this problem isnt exactlty THE problem. We're using here PHP 3.0.12 with Openlink Version 2.7B (Release 3.2) as of Fri Nov 26 1999 (cvsid 00050). The REAL problem is that when we upgrade to PHP 4.0 or higher the odbc functions dont work anymore. The error message is: Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in SQLExecDirect in /software/apache/htdocs/aplic/teste/teste.htm on line 25 I had posted a message earlier about this problem, but had no responses. Here's the message: Hi friends, after some digging I've found that to compile PHP 4.0.2 (or 4.0.3PL1 or 4.0.4RC4) with Openlink ODBC on Sun Solaris we must alter php_odbc.c, changing: "SQLINTEGER len" to "SDWORD len". Ok, it now compiles. But ODBC functions that used to work in PHP 3.0.12 doesn't work anymore. The following code gives the error: Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL state 37000 in SQLExecDirect in /software/apache/htdocs/aplic/teste/teste.htm on line 28 <? $db = odbc_connect("DSN=Producao;UID=notes" , "" , ""); $query = "select nomefunc, matrica from srhtb002"; $result = odbc_exec ($db, $query); // THIS is line 28 print "ok. result = $result"; $nextrow = odbc_fetch_row($result, 1); if (! $nextrow ) { print "Nothing...<br>"; } else { print odbc_result($result , 1 ); print "<br>"; print odbc_result($result , 2 ); } ?> Does these ODBC functions changed their sintax ???????? Best regards, André Felipe Andrew Hill wrote: > 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 > > > > > > > > -- > 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