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

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!

Re: DBD::Sybase + freetds from Linux to Microsoft SQL Server 2000

On Sat, 2006-02-04 at 22:13 -0600, JupiterHost.Net wrote:
> 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?

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.

Now the connect() call:

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

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.

Michael
--
Michael Peppler - mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com/
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

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

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