I've gotten it working with SQL Server 2000 without too many problems.

I used the

    try server login = yes
    try domain login = no
[download]

One thing to note is that if tables don't belong to the sa user, you have to reference them as user.table, or you get VERY uninformative error messages.

Apart from that, DBD::Sybase works just fine.
--
Mike

I had a solution working two years ago, with Perl on Solaris 2.6 (Sun SPARC) and SQL-Server 7 on WinNT 4.

Back then I wrote the following documentation:

MS SQL-Server (NT) to Perl (Solaris)

Setup:

• Perl interface for MS-SQL-Server
• Perl is running on the local Sun (Solaris) machine
• SQL Server is hosted on a remote Windows NT box

Thanks for the steps. I pretty much followed through with those. And then tried to use the test.pl (saved as CGI and run from my solaris website.

Here's the test.cgi code:


#!/usr/local/bin/perl
#
use DBI;

my $dbh = DBI->connect("dbi:Sybase:server=JDBC", 'guest', 'sybase', {P
+rintError => 0});

die "Unable for connect to server $DBI::errstr"
    unless $dbh;

my $rc;
my $sth;

$sth = $dbh->prepare("select \@\@servername");
if($sth->execute) {
    while(@dat = $sth->fetchrow) {
        print "@dat\n";
    }
}
[download]

And here's the error I got:


install_driver(Sybase) failed: Can't continue after import errors at /
+usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBD/Sybase.pm line 9
+2
BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.
+6.1/sun4-solaris/DBD/Sybase.pm line 92.
Compilation failed in require at (eval 626) line 3.
[download]