connect to SQL Server using perl

Hi,

I am using TS 6.7.1 on solaris10.

I am trying to write a perl script which needs to connect to SQL Server 2005 (installed on a windows server).
I am not sure what all the steps which need to be followed in order to achieve that.

I read some threads and did following steps:
Created perl script with

my $dbh = DBI-> connect('dbi Smiley Surprised

DBC:driver={SQL Server};
Server='.$DATABASE_SERVER.',1433;Database='.${DATABASE_NAME},$DATABASE_USERNAME,$DATABASE_PASSWORD, {RaiseError=> 1, AutoCommit=>1}) or die
"cannot open database";

Downloaded DBD-ODBC-1.15.tar and trying to install this.
It says to set the following environment variables:

DBI_DSN
DBI_USER
DBI_PASS
ODBCHOME

but I am not sure what would be the value of ODBCHOME, can somebody please help me what all steps I need to follow in order to connect to SQL Server using perl script.

Find more posts tagged with

Comments

Bhargav Coca

Did you set up the DSN? Are you using the right parameters?

Thanks

nakumar

Please look into this link :

http://www.datadirect.com/developer/odbc/odbc_perl/index.ssp

sasikumarg

When calling the database, the following Environment variables needs to be set: TEMP SYSTEMROOT When we added #--- Set some environment variables needed for DBI drivers $ENV{TEMP} = "C:\\temp"; $ENV{SYSTEMROOT} = "C:\\win2003";

Also try to add this using BEGIN{ } in perl script...