sybase_connect

(PHP 4, PHP 5)

sybase_connect — Sybase server로 연결한다.

Description

int sybase_connect ( string $servername , string $username , string $password [, string $ charset ] )

수행이 성공적으로 이루어지면 양수의 Sybase link identifier(식별자)가 반환되며, 에러가 발생하면 FALSE가 반환된다.

sybase_connect() 함수는 Sybase 서버로 연결하는 함수이다. "servername" 인자는 'interface'파일에 의해 정의된 실제 servername이여야 한다.

만약 sybase_connect()함수가 같은 인자를 가지고 두번 호출된다면, 새로운 연결이 생성되는 대신에 먼저 열렸던 link identifier(식별자)가 반환된다.

스크립트의 실행이 끝나자 마자 서버로의 링크는 끝나게 된다. 그렇지 않다면 sybase_close()함수에 의해 이전에 종료된 것이다.

sybase_data_seek

sybase_close

Last updated: Sun, 25 Nov 2007

add a note User Contributed Notes
sybase_connect

brunello95 at aol dot com
15-Mar-2005 10:30


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.

22-Aug-2002 08: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'


);

Martin dot Man at seznam dot cz
15-Nov-2001 09:06


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

naguiwerian at netscape dot net
18-Sep-2001 09:31


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 !

bkw at weisshuhn dot de
06-Apr-2000 05:38


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





     sybase_min_server_severity(11);

gregory at bnl dot gov
04-Feb-2000 07:35


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.

add a note

sybase_data_seek

sybase_close

Last updated: Sun, 25 Nov 2007