Re: DBI:Sybase connect error

[Ow Mun Heng]

On Wed, 2007-08-29 at 14:32 +0000, vizzz wrote:
> I'm trying to log into a sql server 2005 express through perl using
> DBI and DBD::Sybase module.
> this is my freetds.conf file (located under /etc/freetds/freetds.conf)
> 
> [MyServer70]
>         host = 10.0.2.12
>         port = 1449
>         tds version = 7.0
> 
> running this simple script:
> 
> #!/usr/bin/perl
> 
> use DBI ;
> $user = 'test_user' ;
> $passwd = 'aaa' ;
> 
> $dbh = DBI->connect('DBI:Sybase:server=MyServer70', $user, $passwd);

Do you need freetds? I (think) i'm connecting natively using Sybase..


    $dbh = DBI->connect
              (
                "DBI:Sybase:host=$mssql_server_name;
                port=$mssql_server_port,
                database=$mssql_default_db",
                $mssql_user, $mssql_passwd,
                {RaiseError => 0, PrintError => 0}
              )