What is the best Perl library to use to connect and access MSSQL2008 Database from winXP PC?by blackadder (Hermit)
|on Oct 12, 2009 at 11:50 UTC||Need Help??|
blackadder has asked for the
wisdom of the Perl Monks concerning the following question:
Dear Monks, greetings
I need to connect to a MSSQL2008 database from my winXP laptop. I have googled and searched on PM for an answer, but I got a bit confused!
I wasn't sure wether to go for:
DBI, or DBD::ODBC (am I correct in assuming those two packages will only work from Linux/Unix box?)
Win32::ODBC (some say its no longer supported by Mssql2008)
Win32::ADO or Win32::OLE (which is better!? but I thought one issues ADO command using Win32::OLE)
Or Win32::Sql (Does it work with MSSQL2008? And I could NOT install win32::sql package as it was not found in any of my repositories in PPM - which contains all PPM respositories that i know of!)
Can someone please enlighten me??THANKS!