Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "JupiterHost.Net" <mlists AT jupiterhost.net>
  • To: Michael Peppler <mpeppler AT peppler.org>
  • Cc: FreeTDS AT lists.ibiblio.org, dbi-users AT perl.org
  • Subject: Re: [freetds] DBD::Sybase + freetds from Linux to Microsoft SQL Server 2000 contest
  • Date: Sun, 05 Feb 2006 10:09:52 -0600

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

...

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?

Add an entry in the /etc/freetds.conf file (or wherever the freetds.conf
file is located) that maps to your server - let's call this MYSERVER.

I added this:

[MYSERVER]
host = 1.2.3.4
port = 1433
tds version = 8.0


Now the connect() call:

$dbh = DBI- >connect('dbi:Sybase:server=MYSERVER', ....);


my $dbh = DBI->connect(qw(dbi:Sybase:server=MYSERVER howdy doody)) or die DBI->errstr();

AND IT WORKED!!!!!! Thanks Michael!

Of course you should already have seen this and added the entry to
freetds.conf when you were building DBD::Sybase as it is required for
the "make test" phase.

yeah, that all part of my problem :) I've been working with unixodbc, freetds, DBD::OBDC, and DBD::Sybase to get this to work and my head if spinning. I thought that may be what was supposed ot happen but I've read so manny docs and tried so many things I figured I was probably off.

I'm very grateful for the clarificaion Michael, please send me your paypal address off list and I'll pay you the $20 plus an additional $10 since it was so quick.

Thanks again, very much :)




Archive powered by MHonArc 2.6.24.

Top of Page