Chuck, Did you get ODBC connections working from UNIX? If so, which ODBC client library and which Access ODBC driver did you use? The people I work with have had nothing but trouble trying to get ODBC working from UNIX to SQL Server. (And we'd really like to have this!!)
Regards, Matt Hicks -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 12:46 PM To: [EMAIL PROTECTED] Subject: Re: Newbie - .mdb requirements >Hi! > >I am new to Perl CGI programming and have been researching what is >needed to write a scipt to connect to an Access DB. What I have noticed >so far is the recommended perl modules are DBD::ODBC and/or Win32::ODBC >- is this correct? The only complication I can see arising is that the >module I select would need to work on both Win 2000 and UNIX platforms, >so would the DBD::ODBC module be the choice? Yes, DBD::ODBC is probably your best choice, but more importantly you need DBI first! you would then do something like: use strict; use DBI; my $datasource = "DBD:ODBC:MY_DSN_NAME"; # try to connect my $dbh = DBI->connect($datasource) or die "Couldn't connect to $datasource: " . $DBI->errstr; # do some queries # close the connection $dbh->disconnect; >Also, how do I go about finding out what modules are already on my >computer - I am not certain if how I went about my search was correct? >In the command prompt I entered: > >find `perl -e `print "@INC"'` -name `*.pm' -print > >The response was: >File not found - `*.pm' This one someone else may have a better idea for, if you are on win32 you can use PPM to query installed packages, on *nix I believe the CPAN module in the shell mode (which ppm is basically a copy of) can do the same thing. Good luck! Chuck _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
