Dec 30, 2009, 1:56 AM
Post #1 of 2
connecting to database
I am new to perl. I need to create a perl script that will connect to database and run the sql file to fetch the data and then to put that data in some txt file. I have some sample perl script that r being used in my project. I ned to create new scripts similer to them. In the sample perl script to connect to the sql server DBI is not being used. They are using something like as follows:
system "$MSSQL_OSQL -U$USRNAME -P$PSWNAME -S$SVRNAME -d$DBNAME -l 120 < $SQL > $OUT";
MSSQL_OSQL : is some directory path in microsoft sql server
USR : user name
PSWNAME : pwd
SVRNAME : srvr name
DBNAME : database name
SQL and OUT : path to some sql and output file.
But i am not able to understand that how it wud work?
when i am trying to run my script it gives error :
"path for MSSQL_OSQL " is not recognized as an internal or external command,
operable program or batch file.
please guide me ...