Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I would like to know if there is any way I can transfer data captured from the internet using Perl Script to SQL Server database. How could the be done? I have read a lot of materials that intructs me to enable SQL in Netware and alse make sure ODBC for Netware is running on the server with the SQL Server. And I have done all of these, what do I do next?

20040311 Edit by Corion: Moved from Meditation to SoPW

Replies are listed 'Best First'.
Re: Netware-SQL server transfer
by Grygonos (Chaplain) on Mar 11, 2004 at 17:04 UTC

    First of all... I'll assume your question is ...can i get data off of the internet using a perl script and put it into a SQL Server DB

    Short Answer: Yes
    Long Answer: have a look at DBI and WWW::Mechanize or LWP.

    BTW Netware has ZERO to do with it. If I'm understanding your question correctly. All you need is a SQL Server DB, which you have access to, with (optionally) an ODBC datasource setup for that DB. You can also create it dynamically. Please be sure and put

    use strict; use warnings;
    in your script.. will save you heartache in the end.


    Grygonos