On Mon, Apr 16, 2001 at 07:36:07PM -0700, Peter Scott wrote:
: [I'm going to keep this in the group, others deserve to see the answers.]
:
: At 02:25 AM 4/17/01 +0000, Michael Mitchell wrote:
: >Thanks again!
: >
: >Frequently need to do data validation, NT based intranet, SQL
: >server. Using 32win perl, the Indigo Perl distribution.
: >
: >I know the tables, etc., have access (username/password), etc. Requires
: >both read and insertions.
: >
: >Previously have used VB tool put together by the customer development
: >team, and/or SQL select statements with query analyzer.
: >
: >I know very little about how one would write the basic code, could puzzle
: >through the select statements, but do not know how all that integrates
: >into PERL.
: >
: >I have project ending and may find it difficult to immediately implement
: >in the time left apart from a short-cut.
: >
: >The "shortcut" I hope for is a pointer, or example code. Hope this
: >narrowed parameters enough.
:
: You need DBI. If you can get the book quickly enough, it's your best bet
: by far:
:
: http://www.oreilly.com/catalog/perldbi/
:
: Otherwise, just get it from CPAN and start plowing though:
:
: http://search.cpan.org/search?dist=DBI
:
: I'm assuming there's a DBD for SQL Server. I would imagine there must be,
: but I haven't used it and I don't see anything by that name on
: http://dbi.symbolstone.org/. Probably it's taken care of by the ODBC driver.
The ODBC driver will work ( DBD::ODBC ), There is a DBD::MSSQL too but
I don't know much about it. I would first look on the CPAN (
http://search.cpan.org ) and if that doesn't help, subscribe to the
DBI mailing list found at http://lists.perl.org/.
Win32::ODBC uses windows native ODBC drivers, which I hear is
faster. It is also standard with ActiveState Perl.
http://activestate.com/
Enjoy!
--
Casey West
