Yes, I did mean the Open Client (you don't need ODBC for DBD::Sybase) and sql.ini. It's just that sql.ini is called interfaces on Unix-like systems.
If you can connect with any SQL client on that box, then your parameter to DBI->connect is probably incorrect. If you have the server name registered, try not including the host and port, just use the name:
my $dbh = DBI->connect('dbi:Sybase:server=the_server', $user, $passwor
+d);
$dbh->do("use Reportingdb"); # guessing from your error message
And see if that does the trick.
|