We have been using sybase with PHP4 and now are looking to move to PHP5. I ran
into an installation problem with PHP5 and starting looking at the bug reports
and can't tell for sure whether sybase is being supported any longer.
I was working with PHP5 source rpm on Fedora 6 when I ran into a
I got a similar setup up and running a few months ago. Sadly I am
having connection problems, else I would give you the configure string I
used. When netowrk does come around, I will see what I can do.
Steven
[EMAIL PROTECTED] wrote:
We have been using sybase with PHP4 and now are looking
Does anyone has any detailed installation tips? I am on Solaris 10, using
the /usr/sfw/bin/gcc (3.4.3)
I am getting link errors against the php-cli
disabling the php-cli, the link errors come against the apache binaries, all
of the sybase stuff is undefined
Help!
When retrieving ODBC results from Sybase SQL Anywhere 6 and 9 from a
CALLed procedure, the output to the browser is being arbitrarily
truncated.
?php
$DataSourceUserID = user;
$DataSourcePassword = pass;
$DataSourceName = source;
$ODBCConnect =
Anthony Robins wrote:
When retrieving ODBC results from Sybase SQL Anywhere 6 and 9 from a
CALLed procedure, the output to the browser is being arbitrarily
truncated.
?php
$DataSourceUserID = user;
$DataSourcePassword = pass;
$DataSourceName = source;
$ODBCConnect =
lookups and
calculations that the CALLed statement does...
Anthony Robins
Original Message
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Sybase CALL statement problems
Date: Tue, 29 Mar 2005 09:33:53 -0600
Anthony Robins wrote:
When retrieving ODBC results
Anthony Robins wrote:
I have checked my logfiles, and everything seems to be running
smoothly and error free. The truncation occurs wether I use the
odbc_result_all function or something like:
WHILE( odbc_fetch_row( $CallTest ) ):
FOR( $ii = 1; $ii = odbc_num_fields( $CallTest ); ++$ii ):
On transactions, no this is my biggest concern. Say a php script
performs a
begin tran then aborts early due to an error (user error for
instance), but
the script error handling fails to rollback the transaction before it exits.
Just 1 poorly coded script.
Now the begin tran is still open, the
Hi Brian
Why don't you just avoid using sybace_pconnect() with transactions?
I use ODBTP to connect to SQL Server and Sybase databases, and this is not
an issue. The reason is because ODBTP involves the use of a mediating
service that pools all connections, and automatically rollbacks
Bob,
I agree there are inherit limitations and better ways to pool
db connections. Any decent middleware package would probably
handle these problems very easily.
I just thought that some people may have found simplier ways to
realize the benefits of pconnect and reduce some of the side effects.
I've been using PHP4/5 and Sybase for several years, using standard
sybase_connect. Today I tried playing around with pconnect to get
aquainted.
I expected one simple condition of a use database from one web page
affecting another, and easilly handled that with a connection wrapper that
re-uses
The biggest problem I've had with persistent connections is the problems
that arise when the connection goes down. You have to monitor the
connection status anyways (and reconnect on a failure), so it was
usually easier to just connect every time. I don't know if this is
specific to sybase.
Ever since we have been using PHP to access data in our Sybase database,
database permissions have been spontaneously disappearing from the tables
that are being looked at! It happens on the time frame of a couple months
between times. To fix it, I have to go into Sybase and grant select
Is Sybase support in PHP5 working?
I get:
/bin/sh /usr/portage/tmp/php-5.0.0b3/libtool --silent --preserve-dup-deps
--mode=compile gcc -Iext/sybase/ -I/usr/portage/tmp/php-5.0.0b3/ext/sybase/
-DPHP_ATOM_INC -I/usr/portage/tmp/php-5.0.0b3/include
-I/usr/portage/tmp/php-5.0.0b3/main
Hi, a need a problem.
When I try to connect a my DB Sybase from PHP, I have this error.:
Warning: sybase_connect(): Sybase: Server message: Changed database context to
'INTERNACIONAL_CDR'. (severity 10, procedure N/A) in
E:\WWWRoot\internacionalonline\adodb\adodb-sybase.inc.php on line 86
Hi all,
As many, I'm forced to start my message too with the problem statement
that I can't connect to my sybase database. I have to be more honest
even in saying that I don't even know the difference in --enable-sybase
and --enable-sybase-ct (I have tried both).
I'm by no means an SQL nitwit..
Try:
$sql = select * from item where \bib#\ = 300;
- Original Message -
From: Jeremy Peterson [EMAIL PROTECTED]
To: PHP DB [EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 4:34 AM
Subject: [PHP-DB] Sybase Query- Problems with Pound Sign
I am having a problem with a query that has
I am having a problem with a query that has a pound sign in it. The
results are quite puzzling, it seems like the page doesn't load if the
query is present. I have tested this on other tables without the pound
sign and they work beautifully, seems like the pound sign is the
troublemaker to
Hi Guys. Is it possible to specify a sybase timeout with the current stable
version of php? I am using --with-sybase (dblib) compiled against sybase
OCS.
Thanks
Mills
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Jeremy Peterson wrote:
I am having a problem with a query that has a pound sign in it. The
results are quite puzzling, it seems like the page doesn't load if the
query is present. I have tested this on other tables without the pound
sign and they work beautifully, seems like the pound sign
Folks,
I am trying to connect to a sybase server (12.5) using PEAR DB object.
When connecting to the database from Linux, everything goes as expected.
However, when running on HPUX (Apache 1.3.27/PHP 4.3.1 DSO), I get the
following error:
php_code:
$this-$db =
SQL error: [INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): user api
layer: internal Client Library error: Read from the server has timed out., SQL state
S1T00 in SQLConnect in
Anyone had this problem? I cannot find anywhere that will allow me to change the
timeout.
Ryan
Ryan
Figured it out. it requires a default logon id on the connection tab on the odbc
connection. Who knows why...
Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Thursday, February 20, 2003 12:50 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Sybase timouts
SQL error: [INTERSOLV
hi,
I would like to ask if PHP is capable of accessing a jaguar component
server,
My web server and jaguar cts is in separate box.
jaguar cts can serve CORBA, is PHP capable of using CORBA objects?
any suggestions are highly appreciated.
-- buics
--
We are what we repeatedly do. Excellence,
We have installed PHP 4.2.2 in a Solaris 2.6, with Netscape Enterprise
Server 3.5.1 and Sybase SQL Server/11.0.3.3.
We compiled PHP with following options, and it was successful completed with
no errors.
./configure --with-nsapi=/opt/netscape/suitespot --enable-track-vars
--enable-libgcc
My Linux box is setup with Sybase ASE 11.9.2-3 (same for the common
files) and the openclient is 11.1.1-3. The server I'm connecting to is
running 11.9.2.5. phpinfo shows sybase_ct support. PHP version is
4.1.2.
I'm getting intermittent connection failures on various queries. Maybe
1 out of
Hello,
I have problem with Sybase. When I try to get data from binary column
using sybase_query, the output consist of 4, most significant digits
only, wheras the rest is omitted. My PHP script looks like follows:
?
$conn = sybase_connect ( . , ... ,
Infrastructure Technology Provider
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 2:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Sybase - MSSQL Server 2000
PHP.NET indicates that to connect to MSSQL Server, from Linux use
PHP.NET indicates that to connect to MSSQL Server, from Linux use Sybase.
I've installed Sybase, PHP and Apache and everything works well on my Linux
server when I connect to the Sybase test database.
When I try to connect to my MS SQL server, I get this...
sybase$ isql -S mssql-server -U
Message -
From: Igor Georgiev [EMAIL PROTECTED]
To: Andrey Hristov [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 2:20 PM
Subject: Re: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem
with cp1215
I recive this
PHP -
in DB - îÏÒÍÁÔÉ×ÎÁ ÕÒÅÄÂÁ
-
PHP 4.1.2
Apache 1.3.23
Slackware 7.1
Sybase: Adaptive Server Anywhere 8
iODBC - libiodbc-3.0.5
database created with 1251CYR collation
work fine with cyrillic strings trough windows app (ODBC)
but with PHP on linux trough iODBC Adaptive Server Anywhere ODBC driver 8.0.x not
Do you receive ???s ?
Regards,
Andrey
- Original Message -
From: Igor Georgiev [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 27, 2002 7:11 PM
Subject: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem with cp1215
PHP 4.1.2
Apache 1.3.23
Slackware 7.1
[EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 2:20 PM
Subject: Re: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem with cp1215
I recive this
PHP -
in DB - Нормативна уредба
- Original Message -
From: Andrey Hristov [EMAIL PROTECTED]
To: Igor
:07 PM
Subject: Re: [PHP-DB] Sybase: Adaptive Server Anywhere 8 on Linux: problem
with cp1215
This seems a unicode problem to me.
Here we have similar problem when PHP connects to Access 2000 and receives
???s. No problems with Access 97. Are you sure that the
data is 1 byte not unicode format
PROTECTED]
Sent: Tuesday, February 05, 2002 4:43 AM
Subject: [PHP-DB] sybase or SQL Server
whatever the way I compile php,apache I have always the same error message
:
Call to undefined function: sybase_connect (or mssql_connect)
--
PHP Database Mailing List (http://www.php.net
Hello,
I've got problem with working php 4.1.0 under apache 13.20 with Sybase
SQL.
I installed Sybase ASE 11.0.3 with Open Client Lib and developt part and
compiled php 4.1. with sybase support ( FreeBSD 4.4) as a apache module and
usual executable file.
# ./configure
from Apache when trying to connect to Sybase?
Regards
Richard Hillström
-Original Message-
From: Denis GALINSH [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 4:23 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sybase with php4.1 and apache 13.20 problem
Hello,
I've got problem
Hello,
I am very new to PHP and am having problems finding out information
regarding loading up the Sybase extensions for IIS on Win2K. Any help would
be greatly appreciated.
Art Chevalier
Sybase Replication Administrator
Space and Naval Warfare Center, Chesapeake
1-757-523-8303
--
PHP
hello,
I would like to use sybase stored procedures and need to know, in what
way they are supportet in PHP. In the manual, one can read that stored
procedures are not yet fully supported. Does anybody have any newer
information on what Sybase features can be used with PHP4?
Thank you very much
Did someone succeed installing Php with sybase-ct extension, on a Linux
system containing ASE 12.5?
When compiling, it doesn't find the include, because with the new version of
ASE the are in $SYBASE/OSE/include, rather than $SYBASE/include. I moved the
include file where compiler could find it,
Hallo,
ich nutze per ODBC eine remote procedure auf einem Sybase Server. Die
Prozedur liefert mir unter anderem eine Variable zurück, die ich in PHP
weiternutzen muß. Kann mir jemand einen Hinweis geben, wie ich die
Variable der ODBC Abfrage in eine PHP Variable übertragen kann?
Hier das
Hi,
I run a remote procedure via ODBC on a sybse server. The procedure
returns an integer in a variable @VARIABLE. I have to use the integer
as a variable $VARIABLE in PHP. Does anybody know how to get the
content of @VARIABLE into $VARIABLE?
This is the code I use:
odbc_exec ($conn,declare
:
Fax to:
19-09-2001 12:50 Subject: [PHP-DB] sybase
remote procedure ergebnis in variable
hello !
I have a problem, My SP does not return anything neither to Sybase Interactive SQL nor
to PHP.
When i use to try it from Sybase Central it adds me to may Query "Select [var] from
DUMMY" after execuring procedure.
What should I do to recive the contents directly from Stred Proced. ?
:
Fax to:
19-09-2001 13:55 Subject: Antw: Re: [PHP-DB]
sybase remote procedure
Dear All,
In the past I had installed an Apache server with PHP 4.0.6 and Sybase CT
extension on Mandrake Linux 8, all ok.
On the Mandrake machine, I had installed Sybase ASE 11.9.2, that was only
used for test; most of the time the php code used sybase ct lib to refer to
another database server
You don't need the Sybase dataserver but you still need the Sybase shared
libraries that PHP is linked against.
So restore all the .so's in $SYBASE/lib, and apache should start. Offhand,
I'm not sure if 12.5 came with a different version of the open client
libraries than 11.9.2 did, but if
Hi,
I try to connect to Sybase ASA 6.0 on Windows machine via TDS4.2
(freetds-0.51).
But I have'nt success ..could you help me please ?
My connection string is:
$cn=sybase_connect(labbiszeninv, dba,sql) or die (Sybase must die);
here is freetds interface file:
labbiszeninv
query tcp
Hi,
I try to connect to Sybase ASA 6.0 on Windows machine via TDS4.2
(freetds-0.51).
But I have'nt success ..could you help me please ?
My connection string is:
$cn=sybase_connect(labbiszeninv, dba,sql) or die (Sybase must die);
here is freetds interface file:
labbiszeninv
query tcp
Hi,
I try to connect to Sybase ASA 6.0 on Windows machine via TDS4.2
(freetds-0.51).
But I have'nt success ..could you help me please ?
My connection string is:
$cn=sybase_connect(labbiszeninv, dba,sql) or die (Sybase must die);
here is freetds interface file:
labbiszeninv
query tcp
Sorry to ask this here, but I don´t know where to ask else ...
Does someone know a good mailinglist about
specific sybase questions? I have some questions about BCP ...
MfG
Marcel Walter
Dresdner Kleinwort Wasserstein
Foreign Exchange Money Market
Address:Jürgen-Ponto-Platz 1, 60301
I am almost crazy now after playing with these codes
over 10 hours.
I don't expect to call sybase_query() one by one for
executing sql batch. It just doesn't work for me like
what I said yesterday. Now I try to make a stored
procedure for these sql batch. So I can call
sybase_query() only once.
Hi,
Query Analyzer perfectly.
e.g.
SP1: (works)
CREATE PROCEDURE SP1 AS
insert into mytable values(...)
select * from mytable
Only one result set.
SP2: (doesn't work)
CREATE PROCEDURE SP2 AS
select * from mytable
select * from mytable
Two result sets
SP3: (doesn't work)
Hi,
I am working on Unix(Solaris 2.8) with Apache 1.3 and
php4. I need to connect MS-SQL Server without ODBC. I
know there is an option that using freetds but I
haven't tried it yet.
Someone told me that sybase functions can work with
MS-SQL Server directly. So I called sybase_xxx()
instead of
Greetings,
Would Sybase extensions for php work for MSSQL7?
They say mssql_xxx is an alias for sybase_xxx.
(I desperately need to get smth. working)
Karl.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
Hello,
If I do a sybase_query(select getdate(),$Conn) this will return the
current date in the format Nov 3 1998 8:06PM (so I don't have seconds).
I think this leads to the usage of CS_SHORT_DATE in
ext/sybase_ct/php_sybase_ct.c (Line 275).
Does somebody know, if there is a solution for
Hi i found this:
Undocumented parameter "charset" ...
The complete prototype of sybase_connect is : int sybase_connect([string
host [, string user [, string password [, string charset).
If , after a "sybase_connect", you receive a message like :
" Sybase message: Cannot find the requested
http://www.php.net/manual/de/function.sybase-connect.php
--
PHP Database 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]
I just installed a Sybase_CT module in php 4.0 on a linux machine. I'm
trying to move a web site from a buggy and crashy NT box but I'm having
trouble with the mssql_result call.
This is what I get.
Warning: 2 is not a valid Sybase result resource in
/var/www/html/crap.php on line 54
Line 54
I just installed a Sybase_CT module in php 4.0 on a linux machine. I'm
trying to move a web site from a buggy and crashy NT box but I'm having
trouble with the mssql_result call.
This is what I get.
Warning: 2 is not a valid Sybase result resource in
/var/www/html/crap.php on line 54
Line 54
60 matches
Mail list logo