Please set the DBI tracing level to 9 and send the output (you will also,
probably, have to set the trace file name under Win2k to properly get it
all). It could be DBI or the driver manager, but is probably DBI.
Jeff
>
> 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.
>
>
>
>
