Return-Path: Delivered-To: apmail-httpd-users-archive@www.apache.org Received: (qmail 87091 invoked from network); 21 Feb 2006 21:12:15 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 21 Feb 2006 21:12:15 -0000 Received: (qmail 44982 invoked by uid 500); 21 Feb 2006 21:12:04 -0000 Delivered-To: apmail-httpd-users-archive@httpd.apache.org Received: (qmail 44968 invoked by uid 500); 21 Feb 2006 21:12:04 -0000 Mailing-List: contact users-help@httpd.apache.org; run by ezmlm Precedence: bulk Reply-To: users@httpd.apache.org list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list users@httpd.apache.org Received: (qmail 44957 invoked by uid 99); 21 Feb 2006 21:12:04 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 Feb 2006 13:12:04 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [68.142.200.253] (HELO smtp105.biz.mail.mud.yahoo.com) (68.142.200.253) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 21 Feb 2006 13:12:03 -0800 Received: (qmail 32449 invoked from network); 21 Feb 2006 21:11:41 -0000 Received: from unknown (HELO CPQ1) (gpuckett@metamap.com@67.141.44.197 with login) by smtp105.biz.mail.mud.yahoo.com with SMTP; 21 Feb 2006 21:11:40 -0000 From: "Glenn Puckett" To: Cc: Date: Tue, 21 Feb 2006 16:11:28 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01C63701.7AD6CBB0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcY3K2FfWQuXb2hkTN2OSZQekQz5DQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Checked: Checked by ClamAV on apache.org Message-Id: <20060221211203.D260910FB011@asf.osuosl.org> Subject: [users@httpd] Apache/ODBC X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_NextPart_000_0004_01C63701.7AD6CBB0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hello, I am having trouble determining how to make an application work on the Apache web server. Currently this application is installed on a Win2003 Server using IIS. It is based on Perl with databases in FoxPro files. We are starting a long drawn out process of migrating to a Java application probably running Tomcat and MS SQL. I have been asked to first develop a module using the ODBC interface that will extract data from the FoxPro files and build flat files that other Perl programs can access. (Please don't respond that I shouldn't be doing this. I am fully aware of the inadvisability of this approach. However, this is the only way management would agree to consider this migration. If I can't get this step to work management may trash the entire project. I have to prove the new technology each step of the way.) I have written a Java module that accesses the FoxPro files and generates the proper flat files. I have also executed the module from a Perl module using the "system()" command. But when I attempt to execute the Java module from Perl as part of a web CGI running under Apache it fails. I get the message: ERROR 2006-02-21 15:06:26,421 [main] CamaSource::getConnection:41 getConnection() failed ERROR 2006-02-21 15:06:26,421 [main] CamaSource::getConnection:42 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified The data source IS valid as this same module runs both independently as well as from a Perl program run on the command line. The only real difference is that the failure happens when the connection is attempted from the web environment. It appears that Apache is masking or preventing access to the ODBC data sources. I have been searching message boards and blogs for 2 days and have found a lot of references to the libodbc.so module for Apache but can't really find any direct reference to how to install/configure it or where it can be obtained. I am stuck and getting into a real time issue. Can someone please help instruct me how to set up Apache on WinXP to allow modules access to ODBC data sources? It would be greatly appreciated. Thanks, Glenn Puckett ------=_NextPart_000_0004_01C63701.7AD6CBB0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello,

 

I am having trouble determining how to make an = application work on the Apache web server.  Currently this application is installed = on a Win2003 Server using IIS.  It is based on Perl with databases in = FoxPro files. 

 

We are starting a long drawn out process of migrating = to a Java application probably running Tomcat and MS SQL.  I have been = asked to first develop a module using the ODBC interface that will extract data = from the FoxPro files and build flat files that other Perl programs can = access.  (Please don’t respond that I shouldn’t be doing this.  = I am fully aware of the inadvisability of this approach.  However, this = is the only way management would agree to consider this migration.  If I = can’t get this step to work management may trash the entire project.  I = have to prove the new technology each step of the = way.)

 

I have written a Java = module that accesses the FoxPro files and generates the proper flat files.  I = have also executed the module from a Perl module using the = “system()” command.  But when I attempt to execute the Java module from Perl as part of a web = CGI running under Apache it fails.  I get the = message:

 

ERROR 2006-02-21 = 15:06:26,421 [main] CamaSource::getConnection:41 getConnection() = failed

ERROR 2006-02-21 15:06:26,421 [main] CamaSource::getConnection:42 [Microsoft][ODBC Driver Manager] Data = source name not found and no default driver specified

 

The data source IS valid as this same module runs = both independently as well as from a Perl program run on the command line.  The only = real difference is that the failure happens when the connection is attempted = from the web environment.  It appears that Apache is masking or = preventing access to the ODBC data sources.

 

I have been searching message boards and blogs for 2 = days and have found a lot of references to the libodbc.so module for Apache = but can’t really find any direct reference to how to install/configure it or where = it can be obtained.  I am stuck and getting into a real time issue. =

 

Can someone please help instruct me how to set up = Apache on WinXP to allow modules access to ODBC data = sources?

 

It would be greatly = appreciated…

 

Thanks,

 

Glenn Puckett

------=_NextPart_000_0004_01C63701.7AD6CBB0--