CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

Home: Perl Programming Help: Intermediate:
connecting to database


New User

Dec 30, 2009, 1:56 AM

Post #1 of 2 (922 views)
connecting to database Can't Post


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:



MSSQL_OSQL : is some directory path in microsoft sql server

USR : user name


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 ...

Veteran / Moderator

Dec 30, 2009, 4:58 AM

Post #2 of 2 (916 views)
Re: [anupma_83] connecting to database [In reply to] Can't Post

Perl's DBI module along with the specific DBD module for the database that you're connecting to is Perl's De facto standard method of doing DB scripting.


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives