DBD::Sybase and SQL2000 login-problems

Brian Bruns camber at ais.org
Fri Nov 9 07:51:43 EST 2001


Verify that the sql server is set up to receive 'SQL Server logins' as 
opposed to 'domain' or 'integrated' logins.  There is a mixed mode that 
accepts both if you want to use that.

brian

On Fri, 9 Nov 2001, Ingemar Fällman wrote:

> Hi 
> 
> I have a problem, I checked out CVS-source on Fri Nov  9 12:37:28 2001
> and compiled it using 
> 
> ./configure  --build=i386-linux-gnu --host=i386-linux-gnu --with-gnu-ld
> --with-tdsver=7.0 --enable-msdblib --prefix=/usr --sysconfdir=/etc/freetds
> I also use DBD-Sybase-0.93.
> 
> Everyting compiles and the install works fine, but when I try to connect I
> get the error:
> 
> DBI->connect(server=MyServer70;) failed: Server message number=18456
> severity=14 state=1 line=0 text=Login failed for user 'sipclient'. at
> ./tdstest.pl line 13
> 
> This is my configuration and my log, I realy hope someone can help me..
> 
> freetds.conf:
> #######################################################
> [global]
> 	tds version = 4.2
> 	initial block size = 512
> 	swap broken dates = no
> 	swap broken money = no
> 	try server login = yes
> 	try domain login = no
> 	cross domain login = no
> 	dump file = /tmp/freetds.log
> 	debug level = 10
> 
> [MyServer70]
> 	host = 212.32.190.16
> 	port = 1433
> 	tds version = 7.0#######################################################
> 
> tdstest.pl:
> #######################################################
> #!/usr/bin/perl
> 
> use DBI;
> 
> BEGIN {
>     $ENV{SYBASE} = '/usr';
> }
> 
> $user = 'sipclient';
> $password = ''; # I removed the password now, but it should be here
> $dsn = 'dbi:Sybase:server=MyServer70;';
> 
> $dbh = DBI->connect($dsn, $user, $passwd);
> #######################################################
> I am grateful for any help.
> 
> Regards
>    Ingemar Fällman
> 
> ---
> You are currently subscribed to freetds as: [camber at ais.org]
> To unsubscribe, forward this message to $subst('Email.Unsub')
> 




More information about the FreeTDS mailing list