Skip to Content.
Sympa Menu

freetds - Re: DBD::Sybase and SQL2000 login-problems

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: DBD::Sybase and SQL2000 login-problems
  • Date: Fri, 9 Nov 2001 07:51:43 -0500 (EST)


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





Archive powered by MHonArc 2.6.24.

Top of Page