> > > Hi all, > > I am accessing a Win2K-based MS SQL Server database from Unix-based > (mod_)perl scripts. I am doing this using DBD::Proxy and the dbiproxy > from the DBI distribution. > > Now I am about to leave my job and management is concerned > about who is > going to maintain the setup. As nobody has got any experience > with the > Perl DBI they don't want to maintain the proxy. They've got > to maintain > the SQL Server and ODBC anyway, so the question would be: will it be > easier to dig up some ODBC-libraries for Unix and maintain > them rather > than the current setup.
The easier question is one of politics, funding, etc. I use, in testing, EasySoft's ODBC-ODBC bridge which is a supported, commercial product. There are other commercial products, but nothing free that I'm aware of. This is in the DBI FAQ, FYI. You may get some mileage out of DBI with DBD::Sybase (or DBD::ODBC) using FreeTDS, too -- but I'll presume the argument against FreeTDS (for example) would be the same as against dbi-proxy. (Of course, not knowing the Unix platform you're on, may affect the product availability). So the question will become (for them) use something free that's working or buy something commercial that will be supported...and the costs of the commercial ODBC driver would need to weigh in on that. Regards, Jeff
