Linux/Perl in a machine accessing MSSQL in another machine
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:
> query tcp ether 18.104.22.168 1433
> master tcp ether 22.214.171.124 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 ;-)
More information about the FreeTDS