Re: windows sybase error messages

It sounds like you either don't have the Sybase client software installed on the windows box, or you don't have entries in your interfaces file for the server you're trying to access. Can you logon to the server/database you want with something like isql or the equivalent? If not, that's where the problem lies.

Comment on Re: windows sybase error messages Select or Download Code

Replies are listed 'Best First'.
Re^2: windows sybase error messages by martymart (Deacon) on Aug 26, 2004 at 15:28 UTC
Thanks for the quick response, I did in fact install the Open Client and ODBC drivers for Sybase 12.0. Is this what you mean? Plus I was able to connect to this database from the same windows machine using some db client software. As for an interfaces file, I don't really know about that, although I did have to make an entry into the file: C:\sybase\ini\sql.ini to get the client software to work. So yes, I can logon to the database.	[reply]
Re^3: windows sybase error messages by VSarkiss (Monsignor) on Aug 26, 2004 at 15:40 UTC
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` [download] And see if that does the trick.	[reply] [d/l] [select]