Re: [PHP] sybase installation error
It's not finding your Sybase client libraries. Why, how, or where, I dunno... Check config.log and see what it says about Sybase. Also make sure that the Sybase .so library file thingies are where PHP thinks they will be. If they are not, you can sometimes just put a symlink from where PHP is looking to where they really are, and that will fix it. On Tue, August 28, 2007 9:53 am, Melanie Pfefer wrote: hi, I am getting an error when I issue 'make' command: ../configure --with-apxs2=/usr/local/apache/bin/apxs --with-sybase-ct=/opt/sybase/OCS-12_5 it finishes with: ld: fatal: library -lsybtcl: not found ld: fatal: File processing errors. No output written to .libs/libphp5.so collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `libphp5.la' ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Please vote for this great band: http://acl.mp3.com/feature/soundandjury/?band=COMPANY-OF-THIEVES Requires email confirmation. One vote per day per email limit. Obvious ballot-stuffing will be revoked. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] sybase installation error
hi, I am getting an error when I issue 'make' command: ../configure --with-apxs2=/usr/local/apache/bin/apxs --with-sybase-ct=/opt/sybase/OCS-12_5 it finishes with: ld: fatal: library -lsybtcl: not found ld: fatal: File processing errors. No output written to .libs/libphp5.so collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `libphp5.la' ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sybase and PHP
After looking through sybase.com and coming up with nothing I thought it might be better to see if anyone has already been down this road: I've got a very old laptop with a tiny little hard drive with very little free space on it. It's being used as a 'rogue' intranet server and doing a suprisingly good job of it. Right now we are needing to access one of the company's sybase servers to retrieve customer data, but I don't think we can afford the extra space needed to install too much extra on this poor thing. Does anyone know how to build PHP with sybase support without having a sybase server running on the local machine.or for that matter does anyone know how to install an ODBC driver for the same setup? I'm willing to accept information on either one at this point. It's running rh7.3 w/ php 5 and apache 2. Any help at all would be very much appreciated. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP + Sybase - auto_commit disabled
My site got it's Sybase 'auto_commit' disabled, I mean, if I type a (INSERT, UPDATE, DELETE) query on ISQL's console I got the correct result, but the same doesn't happen when I run the query via PHP. Check the code below: ? //includes with database connection and stuff $xSql= INSERT INTO oab_mailing_logs (nvaNomeMailing, nvaInicioEnvio, nvaFimEnvio, dtDataEnvio, numTamanhoMailing, intLidos) VALUES ('teste', '0', '0', '2003-01-01', 0, 0); $xQuery = sybase_query($xSql); if($xQuery) //sybase_query returns me nothing. $xQuery is not tested on the 'if' clause, it just pass through both 'if' and 'else'. { OK!br; } else { Erro!br; } //sybase_query(commit); //if I uncomment 'sybase_query(commit)' I got what I want, I mean, the INSERT is done correctly, but note that I hadn't to do this before, it's just stop running as it used to //echo xQuery- .$xQuery.br; //it outputs '1' echo Executando a query: b.$xSql./bbr; echo Linhas afetadas: .sybase_affected_rows($xQuery); //there's not output here... it's kinda empty sybase_free_result($xQuery); ? I haven't got any kind of error message, even on Sybase errorlog. Can you help me ? Thanks and the best regards -- Nilo Desenvolvedor WEB A B I L I T Y Soluções interativas +55 21 38526657 www.ability.com.br -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP + Sybase - auto_commit disabled
My site got it's Sybase 'auto_commit' disabled, I mean, if I type a (INSERT, UPDATE, DELETE) query on ISQL's console I got the correct result, but the same doesn't happen when I run the query via PHP. Check the code below: ? //includes with database connection and stuff $xSql= INSERT INTO oab_mailing_logs (nvaNomeMailing, nvaInicioEnvio, nvaFimEnvio, dtDataEnvio, numTamanhoMailing, intLidos) VALUES ('teste', '0', '0', '2003-01-01', 0, 0); $xQuery = sybase_query($xSql); if($xQuery) //sybase_query returns me nothing. $xQuery is not tested on the 'if' clause, it just pass through both 'if' and 'else'. { OK!br; } else { Erro!br; } //sybase_query(commit); //if I uncomment 'sybase_query(commit)' I got what I want, I mean, the INSERT is done correctly, but note that I hadn't to do this before, it's just stop running as it used to //echo xQuery- .$xQuery.br; //it outputs '1' echo Executando a query: b.$xSql./bbr; echo Linhas afetadas: .sybase_affected_rows($xQuery); //there's not output here... it's kinda empty sybase_free_result($xQuery); ? I haven't got any kind of error message, even on Sybase errorlog. Can you help me ? Thanks and the best regards -- Nilo Desenvolvedor WEB A B I L I T Y Soluções interativas +55 21 38526657 www.ability.com.br -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP + Sybase - auto_commit disabled
I don't know a lot about sybase, but if it's anything like oracle it works like this: A query from the console will be commited when the console is exited (plus of course any select queries performing checks at the console will reveal the result as it will be after the commit has occurred). With auto_commit turned off, a php connection needs to tell the database to actually commit before it breaks the connection (otherwise the transaction - ie update query) will roll back, ie go back to the state it was before you attempted the update. Therefore you wil lneed the sybase_query(commit) line in place to commit the transaction. Mark -Original Message- From: Nilo [mailto:[EMAIL PROTECTED] Sent: 25 July 2003 15:42 To: php-general Cc: lgjunior; Rodolfo Subject: [PHP] PHP + Sybase - auto_commit disabled My site got it's Sybase 'auto_commit' disabled, I mean, if I type a (INSERT, UPDATE, DELETE) query on ISQL's console I got the correct result, but the same doesn't happen when I run the query via PHP. Check the code below: ? //includes with database connection and stuff $xSql= INSERT INTO oab_mailing_logs (nvaNomeMailing, nvaInicioEnvio, nvaFimEnvio, dtDataEnvio, numTamanhoMailing, intLidos) VALUES ('teste', '0', '0', '2003-01-01', 0, 0); $xQuery = sybase_query($xSql); if($xQuery) //sybase_query returns me nothing. $xQuery is not tested on the 'if' clause, it just pass through both 'if' and 'else'. { OK!br; } else { Erro!br; } //sybase_query(commit); //if I uncomment 'sybase_query(commit)' I got what I want, I mean, the INSERT is done correctly, but note that I hadn't to do this before, it's just stop running as it used to //echo xQuery- .$xQuery.br; //it outputs '1' echo Executando a query: b.$xSql./bbr; echo Linhas afetadas: .sybase_affected_rows($xQuery); //there's not output here... it's kinda empty sybase_free_result($xQuery); ? I haven't got any kind of error message, even on Sybase errorlog. Can you help me ? Thanks and the best regards -- Nilo Desenvolvedor WEB A B I L I T Y Soluções interativas +55 21 38526657 www.ability.com.br -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHP + Sybase - auto_commit disabled
I forgot to tell that the column 'PKintIDLog' (identity column) is incremented as if the insert was done correctly. For example: I select the max PKintIDLog column value and I got '20', then I try to insert some data on the table via PHP, I select the max PKintIDLog (I should get '21', right ?), but I got '20' cuz I had no row affected. So I insert some data via ISQL console, select the max PKintIDLog and I got '22'. Even with the misinsertion the identity column is incremented. It's pretty weird, isn't it ? I don't know a lot about sybase, but if it's anything like oracle it works like this: A query from the console will be commited when the console is exited (plus of course any select queries performing checks at the console will reveal the result as it will be after the commit has occurred). With auto_commit turned off, a php connection needs to tell the database to actually commit before it breaks the connection (otherwise the transaction - ie update query) will roll back, ie go back to the state it was before you attempted the update. Therefore you wil lneed the sybase_query(commit) line in place to commit the transaction. Mark -Original Message- From: Nilo [mailto:[EMAIL PROTECTED] Sent: 25 July 2003 15:42 To: php-general Cc: lgjunior; Rodolfo Subject: [PHP] PHP + Sybase - auto_commit disabled My site got it's Sybase 'auto_commit' disabled, I mean, if I type a (INSERT, UPDATE, DELETE) query on ISQL's console I got the correct result, but the same doesn't happen when I run the query via PHP. Check the code below: ? //includes with database connection and stuff $xSql= INSERT INTO oab_mailing_logs (nvaNomeMailing, nvaInicioEnvio, nvaFimEnvio, dtDataEnvio, numTamanhoMailing, intLidos) VALUES ('teste', '0', '0', '2003-01-01', 0, 0); $xQuery = sybase_query($xSql); if($xQuery) //sybase_query returns me nothing. $xQuery is not tested on the 'if' clause, it just pass through both 'if' and 'else'. { OK!br; } else { Erro!br; } //sybase_query(commit); //if I uncomment 'sybase_query(commit)' I got what I want, I mean, the INSERT is done correctly, but note that I hadn't to do this before, it's just stop running as it used to //echo xQuery- .$xQuery.br; //it outputs '1' echo Executando a query: b.$xSql./bbr; echo Linhas afetadas: .sybase_affected_rows($xQuery); //there's not output here... it's kinda empty sybase_free_result($xQuery); ? I haven't got any kind of error message, even on Sybase errorlog. Can you help me ? Thanks and the best regards -- Nilo Desenvolvedor WEB A B I L I T Y Soluções interativas +55 21 38526657 www.ability.com.br -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sybase and PHP
Hi, I want to connect to a Sybase database running on another windoze server without having to a buy a copy of sybase for linux. How can I compile PHP to have the sybase functions, but not the local database program. -Michael -- Michael A Smith [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sybase and PHP
U just need the sybase client on the linux machine and the file that contains your TNS names... -- BigDog On Wed, 2003-06-25 at 23:26, Michael A Smith wrote: Hi, I want to connect to a Sybase database running on another windoze server without having to a buy a copy of sybase for linux. How can I compile PHP to have the sybase functions, but not the local database program. -Michael -- Michael A Smith [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] sybase error
Hi all I have installed php 4.3.2 RC1 with the --with-sybase=/pathtomysysbase dir configure switch. I have had no installation problems but now when i go to load a page with the sybase_connect() function call in it i get the following error: Fatal error: Call to undefined function: sybase_connect() I take it this means that the sybase_connect function is not available but am wondering why this would be if i have used the --with-sybase configure option? I have also tried --with-sybase-ct and get the same problem. Thanks for any help in advance! __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sybase result index invalid
I am having trouble retrieving any type of result using Sybase and PHP. Regardless of function call, I receive the following error: Warning: 1 is not a Sybase result index in /var/apache/ I have successfully executed and retrieved results using the same queries using isql from the command line, but I haven't been successful using PHP. Client API Version: Sybase DB-Library/11.1.1/P-EBF8058/sun_svr4/SPARC Solaris 2.5.1/1/OPT/Sat Aug 8 01:37:44 1998 Help! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sybase Fetch Array Question
Can someone let me know when you call sybase_fetch_array that the internal row pointer of the sybase result is increased. So that subsequent calls using sybase_fetch_array will return a result 1 more than the previous result return? Okay that was weird B i g D o g -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sybase Fetch Array Question
Can someone let me know when you call sybase_fetch_array that the internal row pointer of the sybase result is increased. So that subsequent calls using sybase_fetch_array will return a result 1 more than the previous result return? Hey, I just wanted to let you know that when you call sybase_fetch_array that the internal row pointer of the sybase result is increased. I had a feeling you wanted to know that. Also, you should know that subsequent calls using sybase_fetch_array will return a result 1 more than the previous result return. Documentation is at www.php.net/sybase_fetch_row ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sybase Database CONNECTIVITY!
Hi, How can I connect PHP application on Linux to the Sybase database which is lying on the different machine. Please help me. Regards, Vivek
[PHP] Sybase Segfault
Any Sybase/Mandrake gurus want to help me out?... http://bugs.php.net/?id=14074 -- Like Music? http://l-i-e.com/artists.htm -- 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]
[PHP] Sybase Result Paging
Hi all ! Does anybody has a solution of paging result for Sybase + PHP ? Like Prev 1 2 3 4 5 Next Thanks. -- 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]
[PHP] sybase on linux RH 7.1?
has any1 installed sybase on linux RH 7.1? where can i get a good manual? am getting errors trying to ./startserver -f ./RUN_SYBASE Caleb Carvalho Application Engineer Tier 1 CSO Europe LoadRunner/APM - Enterprise Testing and Performance Management Solutions - Mercury Interactive 410 Frimley Business Park Frimley, Surrey. GU16 7ST United Kingdom Telephone : +44 (0)1276 808300 _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- 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]
[PHP] sybase database connections and ipchains...
Php 4.04pl1 running on a linux box. When putting up some filters for the box, I ran into an interesting issue. I put up the filter to allow all traffic from the php box to the database box. I run isql and get a connect just fine. I run a php report and it dies without connecting to the database. Without the filters, all is well and nothing seems wrong. Has anyone else had similar troubles? --Robert -- 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]
Re: [PHP] Sybase port definition
I have one problem our sybase uses port 5000 how can i tel php to send all traffic on this port ? Wild Guesses: Either your "interfaces" file specifies port 5000 for the servername you are using, or you do something like: sybase_connect("servername:5000", 'username', 'password'); -- Visit the Zend Store at http://www.zend.com/store/ Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm -- 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]
[PHP] Sybase port definition
Hi folk's I have one problem our sybase uses port 5000 how can i tel php to send all traffic on this port ? thank's jaro -- 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]
[PHP] Sybase
Can someone give me an example of a simple sybase query page? here is what i have: ? $server = "someserver"; $user = "sybuser"; $pass = "sybpass"; $query = "select * from SomeSillyTable where ThatSillyGuy='me'"; sybase_connect ($server, $user, $pass); sybase_query ($query); sybase_close (); ? Here is what I get: Warning: -1 is not a Sybase link index in /www/smurfy/include/clumpysql.php on line 7 Warning: -1 is not a Sybase link index in /www/smurfy/include/clumpysql.php on line 8 -- 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]