[freetds] DBD::Sybase + freetds from Linux to Microsoft SQL Server 2000 contest

JupiterHost.Net mlists at jupiterhost.net
Sat Feb 4 23:13:24 EST 2006


Hello list,

I'm about to go nuts trying to connect to Microsoft SQL Server 2000 from 
a linux machine.

I'll pay $20 to the first person who can get me over this last hump, 
seriously I'll paypal it to you, maybe more if the solution is had 
quickly. No joke, I will pay :)

Here's what I have:

As root I:

1) download and untarred freetds (v0.63)and went into the dir:
./configure --prefix=/opt/freetds
make
make install

2) Dowloaded an unatarred DBD-Sybase (v1.07) and went into the dir:
export SYBASE=/opt/freetds
perl Makefile.PL
make
make install

This connects:
  # /opt/freetds/bin/tsql -H 1.2.3.4 -p 1433 -U howdy -Pdoody
  locale is "en_US.UTF-8"
  locale charset is "UTF-8"
  1> select convert( varchar(30), getdate(), 120 ) as No
  2> go
  No
  2006-02-04 21:40:56
  1>

Now what do I need to do to
  my $dbh = DBI->connect(?????) or die DBI->errstr();

and how can I do a simple test query (verision or date, whatever) and 
print the results?

If I need to install somthing and do it another way please point me in 
the right direction, freetds.org seems a bit vague to me a super 
MSSQL/ODBC newbie :) I'm used to MySQL so this all seems backwards to me :)

TIA!


More information about the FreeTDS mailing list