Re^2: windows sybase error messages

[martymart]

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

[mpeppler]

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

Oops!

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

Michael

[edan]

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);

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*

[VSarkiss]

Good catch. You should report it to mpeppler, either as a /msg here, or to his email listed on his home page.

[Anonymous Monk]

either as a /msg here, or to his email listed on his home page.

That's the wrong approach. You should report the bug as outlined in the documentation. RTFM.

[martymart]

yeah it looks like you're right, I stand corrected! I suppose I shouldn't rely so much on the documentation!
Martymart