To use SQL Anywhere version 10.0.0 or 10.0.1 with this DBD driver, download and install a current EBF for your version of SQL Anywhere from DEPENDENCIES Dbcapi is included in the client installation of SQL Anywhere 11.0.0 and later. To use DBD::SQLAnywhere, an installation of the SQL Anywhere client software is required and must include the "dbcapi" component (dbcapi.dll on Windows and libdbcapi.so/libdbcapi_r.so on UNIX).
REQUIREMENTSĪs of version 2.0, DBD::SQLAnywhere can be built (but not used) without SQL Anywhere installed. Calling finish() is not sufficient to drop the handle that the server is holding onto: use "undef" instead or reuse the same perl variable for another handle.īe careful when using prepare_cached() since the cache will hold onto statement handles. Note that prepared statements are not dropped from the SQL Anywhere server until the statement handle is destroyed in the perl script. If you encounter this error, make sure you are dropping all of your statement handles and, if so, consult the SQL Anywhere documentation for the MAX_CURSOR_COUNT and MAX_STATEMENT_COUNT options. If that limit is exceeded, a "Resource governor. To help detect handle leaks in client applications, SQL Anywhere defaults to limiting the number of prepared statements and open cursors that any connection can hold at one time to 50 of each. The following is equivalent to the example above: $dbh = DBI->connect( 'dbi:SQLAnywhere:ENG=demo', 'dba', 'sql' ) Prepared Statement and Cursor Limits Similarly, if the third argument is nonblank, it is assumed to be a password and PWD=argument3 will be appended to the SQL Anywhere connection string. If the second argument to connect() is nonblank, it is assumed to be a user name and UID=argument2 will be appended to the SQL Anywhere connection string.
The connection parameters are specified as a list of LABEL=value pairs that are delimited by semicolons.Įxample: $dbh = DBI->connect( 'dbi:SQLAnywhere:ENG=demo UID=dba PWD=sql', '', '' )
SQL Anywhere connection parameters can be passed to DBD::SQLAnywhere by placing the list of parameters after 'dbi:SQLAnywhere:' in the first parameter to connect().
If you are not already familiar with SQL Anywhere connection parameters, please refer to the SQL Anywhere documentation. DESCRIPTIONĭBD::SQLAnywhere is a Perl database driver (DBD) module that works with the DBI module to provide access to Sybase SQL Anywhere databases. # Use 'perldoc DBI' for detailed information about DBI. $dbh = DBI->connect( 'dbi:SQLAnywhere:ENG=demo', $userid, $passwd ) $dbh = DBI->connect( "dbi:SQLAnywhere:ENG=demo UID=$userid PWD=$passwd", '', '' ) DBD::SQLAnywhere - SQLAnywhere database driver for DBI SYNOPSIS use DBI
0 kommentar(er)
