RE: [PHP-INST] PHP + OPENLINK ERROR

Hi Andre, Can you please open a free support case at http://www.openlinksw.com/support/suppindx.htm ? This will help with tracking and resolution, and we can have someone in support reproduce your problems and work with you on a fix. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Andre Felipe [mailto:Andre.Felipe@embrapa.br] > Sent: Monday, December 11, 2000 12:32 PM > To: ahill@openlinksw.com > Cc: Georges da Mata Claessen; php-install@lists.php.net > Subject: Re: [PHP-INST] PHP + OPENLINK ERROR > > > Hi Andrew, > > Unfortunately (or not, since it woud means to change finished > applications ;-)) your solution did not work. I tryed the code below > but the error message is still the same. Looking around I saw > that a lot of users have related this same problem with Openlink > ODBC and PHP4. > Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or > access, SQL state 37000 in > SQLPrepare in > /software/apache/htdocs/aplic/teste/teste.htm on line 25 > Here's the new code: > <? > $db = odbc_connect("DSN=Producao;UID=notes" , "" , ""); > > $query = "select nomefunc, matrica from srhtb002"; > $queryprep = odbc_prepare ($db, $query); // Line 25 > $result = odbc_execute($queryprep ); > print "ok. result = $result"; > > $nextrow = odbc_fetch_row($result, 1); > > if (! $nextrow ) { > print "Não achou nada...<br>"; > } > else { > print odbc_result($result , 1 ); > print "<br>"; > print odbc_result($result , 2 ); > } > ?> > > Lets see if we can fix this, ok? > > Best regards, > André Felipe > > > Andrew Hill wrote: > > > Hi Andre, > > > > How is it going ! :) > > > > I believe that you are experiencing a known issue with odbc_do and > > odbc_exec. > > These functions "directly execute" e.g. they do not first prepare a > > statement. > > > > Try using odbc_prepare followed by odbc_execute, to see if this makes a > > difference. > > > > I have not dug much deeper into the problem, but swapping in a > prepare seems > > to resolve it. > > > > Please let me know how you get on with this. > > > > Best regards, > > Andrew > > ---------------------------------------------------- > > Andrew Hill > > Director Technology Evangelism > > OpenLink Software > > http://www.openlinksw.com > > XML & E-Business Infrastructure Technology Provider > > > > > -----Original Message----- > > > From: Andre Felipe [mailto:Andre.Felipe@embrapa.br] > > > Sent: Monday, December 11, 2000 12:00 PM > > > To: ahill@openlinksw.com > > > Cc: Georges da Mata Claessen; php-install@lists.php.net > > > Subject: Re: [PHP-INST] 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 > > > > > > > > > > > > > -- > > 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 > > >