You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by "Castellon, Francisco" <ca...@syncrude.com> on 2001/07/25 19:45:26 UTC

ODBC for Apache

Hi I am running on Windows98SE, Apache 1.20, mod_perl 1.25, php 4.0.6, and
have the latest Apache::ASP installed and have Activestate's Perl installed
(build 626).

I want to be able to access, Oracle, SQL and MSAccess databases as well as a
couple of other Databases that support ODBC. I want to access these DBs from
my apache server. What do i need??

Do i need to install WIN32::ODBC or DBD::ODBC?
Is Win32::ODBC even compatible with apache? I am running activestate's perl
What is Win32::DBIODBC?
what do i need and in what order? ( i.e. DBD then DBI then DBI::ODBC ???)
where do i get Apache DBI from?
is all supported under windows 98SE?
is there a win32::ODBC? compatible with Apache?

is there like a *.ppd file i can use to install it all? or can i do it
through CPAN?

Thanx for all your help.

Francisco


Re: ODBC for Apache

Posted by Tim Bunce <Ti...@pobox.com>.
On Fri, Jul 27, 2001 at 05:38:12PM -0700, Adi Fairbank wrote:
> Joshua Chamas wrote:
> > 
> > "Castellon, Francisco" wrote:
> > >
> > > Hi I am running on Windows98SE, Apache 1.20, mod_perl 1.25, php 4.0.6, and
> > > have the latest Apache::ASP installed and have Activestate's Perl installed
> > > (build 626).
> > >
> > > I want to be able to access, Oracle, SQL and MSAccess databases as well as a
> > > couple of other Databases that support ODBC. I want to access these DBs from
> > > my apache server. What do i need??
> > >
> > 
> > DBD::ODBC is your ticket, running under DBI
> >   http://dbi.symbolstone.org/
> > 
> > You can probably install DBD::ODBC for Activestate perl with
> > the ppm installer, as they will likely already have compiled
> > it for you.  Apache::DBI is installed with CPAN.
> > 
> 
> What's the stability of DBD::ODBC like?  It claims to be alpha software. 
> Does anyone have any experience with it in a production environment?  Is it
> at least stable with MS SQL server?

The Alpha tag is a relic. I believe DBD::ODBC is fine and in widespread production use.

Tim.

Re: ODBC for Apache

Posted by Adi Fairbank <ad...@certsite.com>.
Joshua Chamas wrote:
> 
> "Castellon, Francisco" wrote:
> >
> > Hi I am running on Windows98SE, Apache 1.20, mod_perl 1.25, php 4.0.6, and
> > have the latest Apache::ASP installed and have Activestate's Perl installed
> > (build 626).
> >
> > I want to be able to access, Oracle, SQL and MSAccess databases as well as a
> > couple of other Databases that support ODBC. I want to access these DBs from
> > my apache server. What do i need??
> >
> 
> DBD::ODBC is your ticket, running under DBI
>   http://dbi.symbolstone.org/
> 
> You can probably install DBD::ODBC for Activestate perl with
> the ppm installer, as they will likely already have compiled
> it for you.  Apache::DBI is installed with CPAN.
> 

What's the stability of DBD::ODBC like?  It claims to be alpha software. 
Does anyone have any experience with it in a production environment?  Is it
at least stable with MS SQL server?

-Adi


Re: ODBC for Apache

Posted by Joshua Chamas <jo...@chamas.com>.
"Castellon, Francisco" wrote:
> 
> Hi I am running on Windows98SE, Apache 1.20, mod_perl 1.25, php 4.0.6, and
> have the latest Apache::ASP installed and have Activestate's Perl installed
> (build 626).
> 
> I want to be able to access, Oracle, SQL and MSAccess databases as well as a
> couple of other Databases that support ODBC. I want to access these DBs from
> my apache server. What do i need??
> 

DBD::ODBC is your ticket, running under DBI 
  http://dbi.symbolstone.org/

You can probably install DBD::ODBC for Activestate perl with 
the ppm installer, as they will likely already have compiled
it for you.  Apache::DBI is installed with CPAN.

--Josh

_________________________________________________________________
Joshua Chamas                           Chamas Enterprises Inc.
NodeWorks Founder                       Huntington Beach, CA  USA 
http://www.nodeworks.com                1-714-625-4051