I have separate scripts that tap into both Access databases and an MS SQL server. I imagine that it would be easy enough to combine both calls into one script, get the data you need and do what you want.

I use Win32::ODBC for my connection to the MS SQL Server. I like the syntax that it uses to call stored procedures. A sample connection into the database would be something like:

my $db = new Win32::ODBC( "DSN=INFO;UID=id;PWD=password" );
       if( ! $db )
       {
           die "Error connecting: " . Win32::ODBC::Error() . "\n";
        }
[download]

For my Access database connections I use dbi::ODBC and the call looks like:

my $dbh = DBI->connect("dbi:ODBC:INFO","username","password")
    or die "Unable to connect: " . $DBI::errstr . "\n";
[download]

Note the differences in the way the username and passwords are called in each case. You can either hard code the username and password into the call, or you can place them in a file out of the document root and refer to the file in your call. The "INFO" in each call points to the DSN that is set up through the Windows Admin tools on the server to connect to the database. I'm assuming if you have a DBA background, then you know how to do that.

Most of the information that I needed to understand how to use DBI and Win32::ODBC came from the documentation for the modules and from web searches. Dave Roth has helpful information on Win32::ODBC.

Hope this helps.

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.