Hello,
I am attempting to connect to a database (Tivoli Storage Manager) on AIX
4.3 using perl/DBI/ODBC from win2k using the following code: (system
DSN configured for server1 on the box running the script)
use DBI;
$dsn = 'dbi:ODBC:server1';
$uid = 'xxxxxx';
$pwd = 'xxxxxx';
$dbh = DBI->connect("$dsn", "$uid", "$pwd") or die "$DBI::errstr\n";
print "DBI-ODBC connection to $dsn has been established\n";
This generates the following output:
Session established with server SERVER1: AIX-RS/6000
Server Version 4, Release 1, Level 3.0
Server date/time: 09/05/2001 10:31:29 Last access: 09/05/2001 10:30:33
DBI->connect(server1) failed: Optional feature not implemented.
(SQL-S1C00)(DBD:
dbd_db_login/SQLSetConnectOption err=-1) at tsm.pl line 6
Optional feature not implemented. (SQL-S1C00)(DBD:
dbd_db_login/SQLSetConnectOpt
ion err=-1)
My question is, would this message be a problem with the vendor provided
ODBC driver, or a problem with my code?
I've been using DBI to connect to other databases, so I'm a bit suspicious
of the ODBC driver being the problem.
Thank you.