Re: Almost solved : MySQL to MS SQL Server

[Joel West]

I found it..duh!

On Fri, 20 Aug 2004, Joel West wrote:

I am much closer than before:

I compiled FreeTDS from source.

tsql connects no problems

DBD::Sybase compiles no problem and no longer causes errors.

BUT

#!/usr/local/perl
#
use DBI;
use DBD::Sybase;

my $server="192.168.100.2";
my $uid="ss_userid";

my $dbh = DBI->connect("dbi:Sybase:$server", '$uid', '$uid');

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

Gives the error:

DBI connect('192.168.100.2','$uid',...) failed: Server message number=18456 severity=14 state=1 line=0 text=Login failed for user '$uid'.OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
Server 192.168.100.2, database
Message String: Login incorrect.
at test1.pl line 9
Unable for connect to server Server message number=18456 severity=14 state=1 line=0 text=Login failed for user '$uid'.OpenClient message: LAYER = (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (46)
Server 192.168.100.2, database
Message String: Login incorrect.