Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    5

    Unanswered: Newbie:Accessing MS-Access from Perl

    Hi all,

    I wanted to know if it is possible to connect to MS-Access database from a Perl script, on a Windows-2000 box.Searched the net for some tutorials, but could not find any.Could anyone help me out??

    -Cusp

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120

    Re: Newbie:Accessing MS-Access from Perl

    Have a look at DBI and DBD::ODBC:

    http://search.cpan.org/author/TIMB/DBI-1.32

    http://search.cpan.org/author/JURL/DBD-ODBC-1.04

    You can get both for win32 at activestate (www.activestate.com).

  3. #3
    Join Date
    Feb 2003
    Location
    Other side of the ocean
    Posts
    6

    use Win32::ODBC

    like suggested above;

    ...
    use Win32::ODBC;
    $dsn = "<yourDSNtoACCESS>";
    $db = new Win32::ODBC($dsn);
    ...
    $sql3 ="select * from blabla WHERE blabla..";
    $db->Sql($sql);

    ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •