Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing the database on MS SQL Server through Perl

Status
Not open for further replies.

sut

Programmer
Jun 6, 2001
12
0
0
US
Hi,
I have my database on MS-SQL Server (Windows 2000). I want to access it through Perl (client's requirement). It would help me greatly if any body can tell me how to do access MS-SQL server database through Perl?

Waiting for suggestions.

Thanks
S
 
If the Perl is running on a MicroSlop OS, you can setup
the SQL Server as an ODBC Data source on the local machine
and use the DBI::ODBC approach.

If the Perl is not on a MicroSlop OS, then you might try
We have successfully connected with Perl
on a RH Linux box via the freeTDS approach to a SQLServer
7 instance. It was something of a pain, but, with some
messing around we got it to work. It does not support some
of the more sophisticated SQL tricks, but, it does simple
SQL "select this from there where something is true" kind of
stuff. My best advice is go to and start
reading. They talk about this in the faq page.

HTH Please use descriptive titles and check the FAQs.
And, beware the evil typo.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top