DBD::ADO DBD::ADO is a DBI driver for Microsoft ADO (Active Data Objects).
Download

DBD::ADO Ranking & Summary

DBD::ADO Tags

Perl module driver DBI driver DBI ADO Microsoft ADO

DBD::ADO Description

DBD::ADO is a DBI driver for Microsoft ADO (Active Data Objects). SYNOPSIS use DBI(); my $dbh = DBI->connect("dbi:ADO:$dsn", $usr, $pwd, $att ) or die $DBI::errstr;DBI MethodsconnectUse the DBI connect method to establish a database connection: my $dbh = DBI->connect("dbi:ADO:$dsn", $usr, $pwd, $att ) or die $DBI::errstr;where $dsn - is an ADO ConnectionString $usr - is a user name $pwd - is a password $att - is a hash reference with additional attributesTypical connection attributes are RaiseError => 1 PrintError => 0 AutoCommit => 0See the DBI module documentation for full details.Driver specific connection attributes are: ado_ConnectionTimeout ado_ModeThese attributes initialize the corresponding ADO Connection properties before opening the connection.An ADO ConnectionString usually contains either a 'Provider' or a 'File Name' argument. If you omit these arguments, Provider defaults to MSDASQL (Microsoft OLE DB Provider for ODBC). Therefore you can pass an ODBC connection string (with DSN or DSN-less) as valid ADO connection string. If you use the OLE DB Provider for ODBC, it may be better to omit this additional layer and use DBD::ODBC with the ODBC driver.In addition the following attributes may be set in the connection string: Attributes CommandTimeout ConnectionString ConnectionTimeout CursorLocation DefaultDatabase IsolationLevel ModeWarning: This feature is supported for backward compatibility. It's saver to use the driver specific attributes described above. Anyway, the application is responsible for passing the correct values when setting any of these attributes.See the ADO documentation for more information on connection strings.ADO ConnectionString examples: test File Name=test.udl Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:datatest.mdb Provider=VFPOLEDB;Data Source=C:datatest.dbc Provider=MSDAORA Requirements: · Perl · DBI · ADO · Win32::OLE

DBD::ADO Related Software