For Programmers: Free Programming Magazines  


Home > Archive > PERL Miscellaneous > June 2005 > DBI and MS SQL 2000 Server - Where to start?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DBI and MS SQL 2000 Server - Where to start?
Bob

2005-06-11, 8:56 am

Reposting this, 'cause none of the air-heads on perl.dbi.users could
even be bothered to answer this:

Ok, I am trying to write code on win32 platform to access MS SQL 2000
server. Portability is not really an issue today, but I have decided to
go down the DBI road, just in case. I imagine writing a large Perl/SQL
Server toolkit in perl.

So DBI interface is all I hear about. But what is he DBD that I should
use to acess MS SQL 2000 (and soon 2005) servers? Any of you chaps got
a choice recomendation. It seems to me that there are least three
options:

1. DBI::ADO
2. DBI::Sybase - with some FREETDS stuff (or is this just for *NIX?)
3: DBI::ODBC - ADO must be better right?

and there are probably even more. I would like to hear from someone
who has done a lot of this before. BTW; I also do a lot of OLE/SQL-DMO
stuff with perl, but the DBI is a new area for me.

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2009 codecomments.com