On Tue, 2004-05-11 at 18:40, Richard Crawford wrote: > Is there a DBD for SQL Server so that I can connect to our SQL Server > 2000 database with DBI? I've hunted all over CPAN but I can't seem to > find one.
Richard, I'm running a mod_perl site connected to a SQL Server 2000 backend via DBD::ODBC with a driver from OpenlinkSW. Go to http://www.openlinksw.com. They will let you download a full working driver, but it has a 30 license. If you need more than 30 days you'll have to redownload the driver and it'll email you another 30 day license. It took us about 6 months of "testing" before we bought the driver for about $600, buti it was well worth it. They'll also give you the iODBC SDK (driver manager) and phone support even if you're evaluating. Lot's of praise on the phone support as they worked with me for 5 days and had a developer helping me as I was having trouble getting it interfaced with mod_perl for some weird reason. Long story short mod_perl was only seeing unixODBC (another driver manager) and so I had use unixODBC instead of iODBC. No biggie, it was tracking this down that was the problem. Hope this helps, Kevin -- Kevin Old <[EMAIL PROTECTED]> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
