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..
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:
";
sybase_select_db ( "my_db", $conn);
$
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 --wi
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 ge
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 Dat
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
Ry
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
permission
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 pro
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
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
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: [
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
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
Wh
Hi,
I am porting an application which currently makes use of the ODBC PEAR DB
object to use the SyBase DB object instead. However, there does not seem to
be a way to retrieve multiple result sets using the SyBase object.
The transfer to SyBase, and indeed the stored procedure which generates
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 userna
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,
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 -I/usr/port
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-use
When retrieving ODBC results from Sybase SQL Anywhere 6 and 9 from a
CALLed procedure, the output to the browser is being arbitrarily
truncated.
The resulting output does contain proper data, but as I said, it
simply gets chopped off at a seemingly random point (I have had it
chop anywhere from
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 to
To all the experts,
I have a small problem with PHP4 connecting to Sybase.
Everytime when I connect to a sybase database, the following warning
comes up:
Warning: Sybase message: Cannot find the requested character
set in Syscharsets: name = 'ܮX'. (severity 11)
Looks like there is a char
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 PROTE
ROTECTED]>
To: <[EMAIL 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)
>
>
>
>
> --
>
p; E-Business 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 t
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. You
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, th
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
transactio
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
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.
$DataSourcePassword = "pass";
$DataSourceName = "source";
$ODBCConnect =
odbc_connect($DataSourceName,$DataSourceUserID,$DataSou
mum and maximum values for various 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
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 ):
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 c
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]
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,"
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. ?
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 = @DB::connect("sybase://$D
On RH 7.2, Apache 1.3.22, PHP 4.1 and ASE 11.9.2 I get :
"Warning: Sybase: Unable to allocate connection record"
Env $SYBASE is set ok as it is seen by PHP.
After restarting apache (compiled with php and php is with-sybase-ct) it
works well for about 3 hours than I start receiving this annoying m
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
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
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!
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 m
Hi
http://www.php.net/bugs.php?id=7609
This bug report (7609) concerned new connections being made when calling
sybase_connect().
The last reponse was
[2001-02-11 15:09:51][EMAIL PROTECTED]
I guess this should not happen, anyone with sybase should
verify this..
I'm using PHP 4.0.5 on Apache 1
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
que
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
que
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
que
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 (
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 Beisp
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 me
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 --with-sybase=/usr/home/syb
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. B
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: (
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 it
:
19-09-2001 12:50 Subject: [PHP-DB] sybase
remote procedure ergebnis in variable
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, a
Yep, I wish I could name the fields, but alas it is not my database
application. For some reason it works... :)
When I use isql it works as expected, thus the problem.
At 10:41 PM 8/5/2003 -0400, John W. Holmes wrote:
Jeremy Peterson wrote:
I am having a problem with a query that has a pound
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- Probl
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 is
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 pr
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 r
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 r
Fax to:
19-09-2001 13:55 Subject: Antw: Re: [PHP-DB]
sybase remote procedure ergebnis in
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
ODBC.INI-
Hello.
Im trying to tune PHP4 and Sybase SQL Anywere under win98. Is this possible?
What difference beside Sybase-CT and Sybase in file php.ini?
In sql.ini I wrote:
[MUSIC]
master=NLWNSCK, 192.168.1.44 ,1498
query=NLWNSCK, 192.168.1.44 ,1498
192.168.1.44 this is IP adress in LAN
also I try 127
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
P
>
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 - Нормативна уредба
> - Original Message
L PROTECTED]>
Sent: Thursday, March 28, 2002 1: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
rmat?
>
> Andrey
> - Original 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: probl
67 matches
Mail list logo