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