batcater98 has asked for the wisdom of the Perl Monks concerning the following question:
I am building routines to update SQL database elements, I have been testing with MYSql simply because is it easy and free to test with. Moving to a Prod system I need to convert over to MSSQL 2005. Thought this would be a simple move, but I am having some issues.
Is ODBC the best interface? From what I see yes. But if so, can someone help me get the DBD::ODBC drivers installed on my test system "XP", and then my prod system "Windows 2003". I have been running into issues with the makefile or finding a good ppm install.
Thanks for any help on this.
Comment on Help - Posting Records to MSSQL Database - ODBC?
You could probably also use DBD::Sybase though I don't imagine it will be any easier to install. The most recent DBD::ODBC ppms are often found at esoftmatic, though it seems to be down at the moment.