We would like to use apache/mod_perl to connect to MS SQL Server databases.
--Matt -----Original Message----- From: Mark Bergeron [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 9:59 AM To: Hicks, Matthew; '[EMAIL PROTECTED]' Cc: Poulson, Shawn Subject: Re: Re: Newbie - .mdb requirements Working from Unix to SQL Server? What is it you guys are trying to do? Mark Bergeron' -----Original Message----- From: "Hicks, Matthew"<[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'"<[EMAIL PROTECTED] ate.com> Cc: "Poulson, Shawn"<[EMAIL PROTECTED]> Date: Mon Oct 01 09:53:57 PDT 2001 Subject: Re: Newbie - .mdb requirements >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 ___ _ | _ ) ___ ___ | | | _ \/ _ \/ _ \|_| |___/\___/\___/(_) ___________________________________________________ GO.com Mail Get Your Free, Private E-mail at http://mail.go.com _______________________________________________ Perl-Win32-Web mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
