Linux/Perl in a machine accessing MSSQL in another machine

Geoff Winkless geoff at farmline.com
Thu Jan 20 08:48:17 EST 2000


"Fabiano Bonin" <fabiano at leonilda.com.br> writes:
> I have a Linux box running Perl with DBI, DBD::Sybase, and FreeTDS, and I
> want to access SQL Server runnig on another machine.
> Is that possible?
>
> I'm using the following line to connect:
> my $dbh = DBI->connect( 'dbi:Sybase:test', 'username', 'password',

> RaiseError => 1 } );
>
> in the file /usr/local/freetds/interfaces I have the following lines:
> test
>    query tcp ether 200.231.32.3 1433
>    master tcp ether 200.231.32.3 1433
>
> but it's not connecting.

If this is MS SQL Server then you need to run recompile freetds. Run
configure with the --tds-ver=4.2 flag. If it's not, or if you've already
done this, then sorry for stating the obvious ;-)

Geoff




More information about the FreeTDS mailing list