DBI connect('host=testserver.internal.com;port-7100;database=Reportingdb','sa',...)

Maybe that "port-7100" would work better if it read "port=7100"?

Hi There,
Actually, I think you could be wrong there. I got this syntax from http://search.cpan.org/~mewp/DBD-Sybase-1.04/Sybase.pm.
If you built DBD::Sybase with OpenClient 12.5.1 or later, then you can use the host and port values to define the server you want to connect to. This will by-pass the server name lookup in the interfaces file. This is useful in the case where the server hasn't been entered in the interfaces file.
$dbh = DBI->connect("dbi:Sybase:host=db1.domain.com;port-4100",$user, $passwd);

Plus, this script does work fine on my other linux machine. Although I know where you're coming from as I made the same mistake myself cause I used to connect to mysql databases. If I was to connect to mysql it would look like:
$dbh = DBI->connect("DBI:mysql:database=$database;host=$host;port=$port", "$username","$password")

Martymart

$dbh = DBI->connect("dbi:Sybase:host=db1.domain.com;port-4100",$user, $passwd);

Oops!

Will be fixed in the next version... :-)

Michael

That's what we call in professional lingo a "typo". I couldn't imagine that the dsn for DBD::Sybase would have a wacky non-standard way of specifying just the port, so I had to consult the source (http://search.cpan.org/src/MEWP/DBD-Sybase-1.04/dbdimp.c):

  if(strchr(dsn, '=')) {
    extractFromDsn("server=", dsn, imp_dbh->server, 64);
    ... blah blah blah ...
    extractFromDsn("host=", dsn, imp_dbh->host, 64);
    extractFromDsn("port=", dsn, imp_dbh->port, 20);
    extractFromDsn("maxConnect=", dsn, imp_dbh->maxConnect, 25);
[download]

As you can see, it is clearly looking for "port=", and not "port-". Why your dsn would would work with "port-" is beyond me. *shrug*

--
edan

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.

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.

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.

Alternatively - use the "standard" way of defining the server, by using a logical server name and an entry in the interfaces file (sql.ini on Windows).

Michael