Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Sybase Functions : sybase_connect

sybase_connect

Opens a Sybase server connection (PHP 4, PHP 5)
resource sybase_connect ( [string servername [, string username [, string password [, string charset [, string appname]]]]] )

Example 2523. sybase_connect() example

<?php
$link
= sybase_connect('SYBASE', '', '')
       or die(
"Could not connect !");
echo
"Connected successfully";
sybase_close($link);
?>

Code Examples / Notes » sybase_connect

bkw

To decrease the level of messages sent back from the dbserver (such as 'changed context...') try:
    sybase_min_server_severity(11);


naguiwerian

To connect from win32 to Sybase on Unix , you can use sybase open client and make sure to use the hostname in sybase_connect as it is defined in the OC sql.ini file .. it worked that way !

23-aug-2002 04:09

Set the appname using the 5th optional parameter:
http://lxr.php.net/source/php-src/ext/sybase_ct/php_sybase_ct.c#713
sybase_connect(
 $host= 'host',
 $user= 'user',
 $pass= 'pass',
 $charset= NULL,
 $appname= 'myapp'
);


gregory

If you are having trouble connecting to your sybase database on unix, try checking that the SYBASE environmental variable is set correctly. I was getting connection errors until I found out that this variable had not been set through the server.

martin dot man

if you are going to use DSO version of php compiled with sybase support, check that apache is not linked against libdb2. In such case call to dbopen from libsybdb.so will result in a call to dbopen from libdb2.so which is loaded earlier that libsybdb.so, as a workaround either recompile apache without db2 support or link php staticaly with libsybdb.a.
the symptom of wrong behavior is that sybase_connect does not return neither 0 nor meaningful value, it simply returns nothing...


brunello95

freetds is a great, free tool to access your sybase tables with PHP. The setup can be a bit tricky. Use the following to put the environment variables that you need:
<?php
putenv ("SYBASE=/usr/local/freetds");
putenv ("SYBPLATFORM=linux");
putenv ("LD_LIBRARY_PATH=/usr/local/freetds/lib");
putenv ("LC_ALL=default");
putenv ('PATH=\"/usr/local/freetds/bin:$PATH\"');
putenv ("DSQUERY=SYBASE");
?>
Even if not using freetds, you'll need those env vars to make any sybase connection work. Another option is to just load them into your box from the command line.


Change Language


Follow Navioo On Twitter
sybase_affected_rows
sybase_close
sybase_connect
sybase_data_seek
sybase_deadlock_retry_count
sybase_fetch_array
sybase_fetch_assoc
sybase_fetch_field
sybase_fetch_object
sybase_fetch_row
sybase_field_seek
sybase_free_result
sybase_get_last_message
sybase_min_client_severity
sybase_min_error_severity
sybase_min_message_severity
sybase_min_server_severity
sybase_num_fields
sybase_num_rows
sybase_pconnect
sybase_query
sybase_result
sybase_select_db
sybase_set_message_handler
sybase_unbuffered_query
eXTReMe Tracker