> > "Simon Oliver" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > <snip> > > Easiest route is to set up a system DSN via the ODBC > administrator and > > then just specify the DSN name in the connection string. > > > > Alternatively, use a DSN-less connection string: > > > > my $dsn = "driver=Adaptive Server Anywhere > > 8.0;DBN=database;ENG=server;LINKS=tcpip{host=192.168.0.99}"; > > > > my $dbh = DBI->connect("dbi:$dbd:$dsn", $uid, $pwd, $attr) > > or die "Error: Connecting to datasource: $DBI::errstr"; > > > > However, on testing with Perl 5.8, DBI 1.30 / DBD::ODBC > 0.43 I notice > > that I get an unexpected error: > > > > failed: [Sybase][ODBC Driver][Adaptive Server > Anywhere]General error: > > Connection was terminated (SQL-S1000)(DBD: > > dbd_db_login/SQLSetConnectOption err=-1) > > > > A quick look in the ODBC SQL trace file indeictes the following > > problem: > > > > perl -w 500-4ec EXIT SQLSetConnectOption with > return code -1 > > (SQL_ERROR) > > HDBC 01D515E8 > > SQLINTEGER 102 <SQL_AUTOCOMMIT> > > SQLPOINTER 0x00000001 > > > > DIAG [S1000] [Sybase][ODBC Driver][Adaptive Server Anywhere]General > > error: Connection was terminated (-308) > > > > But this error does not occur when using a DSN name rather than a > > DSN-less connection or when using DBD::ADO. > > > Yikes! Which leaves me where? lol > > >
I'd suggest that you try the system DSN first. Regards, Jeff
