|
Unix VPS
Support
FAQ
Network
Miscellaneous
|
| SQLEngine::Driver::Sybase::MSSQL(3) | User Contributed Perl Documentation | SQLEngine::Driver::Sybase::MSSQL(3) |
NAME
DBIx::SQLEngine::Driver::Sybase::MSSQL - Support Microsoft SQL via DBD::SybaseSYNOPSIS
DBI Wrapper: Adds methods to a DBI database handle.my $sqldb = DBIx::SQLEngine->new( 'dbi:Sybase:server=MyServer' );
Portability Subclasses: Uses driver's idioms or emulation.
$sqldb->select_dbms_flavor('MSSQL');
$hash_ary = $sqldb->fetch_select(
table => 'students'
limit => 5, offset => 10
);
DESCRIPTION
This package provides a subclass of DBIx::SQLEngine::Driver::Sybase which compensates for configurations in which DBD::Sybase is being used to communicate with a Microsoft SQL Server database.If you are connecting to a Microsoft SQL Server through ODBC, you should use the regular MSSQL driver; see DBIx::SQLEngine::Driver::MSSQL
For more information, see "Using DBD::Sybase with MS-SQL" in DBD::Sybase.
Under Development
Note that this driver class has been added recently and not yet tested in real-world conditions.About DBMS Flavors
This subclass of the Sybase driver must be specifically triggered, because the package is unable to automatically detect the difference between using DBD::Sybase with a Sybase server and using it with a Microsoft server.To do this, call select_dbms_flavor after connecting:
my $sqldb = DBIx::SQLEngine->new( 'dbi:Sybase:server=MyServer' );
$sqldb->select_dbms_flavor('MSSQL');
For more information, see the documentation for the superclass, DBIx::SQLEngine::Driver::Sybase.
INTERNAL STATEMENT METHODS (DBI STH)
No Placeholders
When using DBD::Sybase to talk to a Microsoft SQL Server, "?"-style placeholders are not supported.Uses the NoPlaceholders trait. For more information, see DBIx::SQLEngine::Driver::Trait::NoPlaceholders.
INTERNAL STATEMENT METHODS (DBI STH)
Statement Handle Lifecycle
- prepare_execute()
- After the normal prepare_execute cycle, this also sets the sth's LongReadLen to dbms_longreadlen_bufsize().
- dbms_longreadlen_bufsize()
- Set to 1_000_000.
SEE ALSO
See DBIx::SQLEngine for the overall interface and developer documentation.See DBIx::SQLEngine::Docs::ReadMe for general information about this distribution, including installation and license information.
| 2004-11-13 | perl v5.32.1 |
Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.