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!