sybase_connect

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

sybase_connect() establishes a connection to a Sybase server.

In case a second call is made to sybase_connect() with the same arguments, no new link will be established, but instead, the link identifier of the already opened link will be returned.

The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling sybase_close().

Parameters

servername: The servername argument has to be a valid servername that is defined in the 'interfaces' file.
username: Sybase user name
password: Password associated with username.
charset: Specifies the charset for the connection
appname

Return Values

Returns a positive Sybase link identifier on success, or FALSE on failure.

ChangeLog

Version	Description
4.0.2	The `charset` parameter was added.

Examples

Example 2523. sybase_connect() example

copy to clipboard

<?php

$link = sybase_connect('SYBASE', '', '')

        or die("Could not connect !");

echo "Connected successfully";
sybase_close($link);
?>

See Also

sybase_pconnect()

sybase_close()

Code Examples / Notes » sybase_connect

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...

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.