Skip to Content.
Sympa Menu

freetds - [freetds] Perl with FreeTDS driver

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Russell Kroboth <rkroboth AT visitraleigh.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Perl with FreeTDS driver
  • Date: Tue, 25 Feb 2003 15:21:13 -0500

Ok, I have my first question.. Clarification on this page:
http://www.freetds.org/userguide/x1576.htm

I hope to use DBD::ODBC with my newly installed FreeTDS ODBC driver, and
write perl scripts which can use this setup.
My connection string in my Perl script is going to be:
my $dsn =
"driver=TDS;Server=192.168.1.54;database=Partners;uid=testuser;pwd=password1
;TDS_Version=7.0;Port=1433";
So when I am getting ready to install DBD::ODBC module, I set the
environment variables, the help page says here is what to do:
$ export SYBASE=/usr/local/freetds
$ export ODBCHOME=/usr/local

My question is:
1) using the ENV variable named "SYBASE" is throwing me off. Is that
something I need, since I'm using the FreeTDS Driver with a MS SQL database?
Is this thing named "SYBASE" there in case I wanted to use the DBD::Sybase
method, and can I leave it out?

2) should ODBC home be the directory where lib/libodbc.so and
lib/libodbcinst.so reside? (/usr in my case)


3) In my case, it's not clear what DBI_DSN should be. Any suggestions?


Thanks!
Rusty Kroboth





Archive powered by MHonArc 2.6.24.

Top of Page