http://www.perlmonks.org?node_id=37543


in reply to How do I connect to Microsoft SQL server 6.5?

I would second using

Be sure to install MDAC 2.1 (or higher)

Also, ignore any advice to use DSN's on the machine, you should really build a complete connect string in your code. that way you stay portable. Nothing like moving it to a newer bigger machine (inevitable with NT) and then having to hand-build a DSN.

You should get suprisingly good results from a combination of Perl and ODBC. It sure beats using that other product from our pals in Redmond.

  • Comment on Re: How do I connect to Microsoft SQL server 6.5?