From owner-freebsd-questions  Thu Feb 28  8:31:21 2002
Delivered-To: freebsd-questions@freebsd.org
Received: from web13404.mail.yahoo.com (web13404.mail.yahoo.com [216.136.175.62])
	by hub.freebsd.org (Postfix) with SMTP id 0DA1A37B402
	for <questions@freebsd.org>; Thu, 28 Feb 2002 08:31:16 -0800 (PST)
Message-ID: <20020228163115.68409.qmail@web13404.mail.yahoo.com>
Received: from [128.111.214.65] by web13404.mail.yahoo.com via HTTP; Thu, 28 Feb 2002 08:31:15 PST
Date: Thu, 28 Feb 2002 08:31:15 -0800 (PST)
From: Chris Dempsey <chrisdempsey@yahoo.com>
Subject: Re: Access database, Unix and php
To: Tim Kellers <timothyk@wallnet.com>, questions@freebsd.org
Cc: kellers@njit.edu
In-Reply-To: <200202270306.g1R369432667@serv1.wallnet.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG

--- Tim Kellers <timothyk@wallnet.com> wrote:
> 
> In an evironment that can be maddenly heterogenous,
> I need to connect --using 
> php-- to an Access database that resides on a Win2k
> server.  Recently, the 
> day before yesterday in fact, Cold Fusion Server's
> CFMail capability gave up 
> the ghost and I'm looking for an alternative way to
> post web information 
> received via a form to a database and have it auto
> generate e-mail to the 
> poster.

Try checking for bad emails in the /mail/*
subdirectories - it almost always is the culprit in
cfmail problems.  Also, I would definitely use MySQL
on FreeBSD instead of an Access database.  Access
databases are *not* good for a system that will get
more than a minimum load.

> 
> I know how to do that in php(4) and MySQL --in fact
> I have that component 
> working.  But (and there is always a but), the form
> I have to use has 
> selections that are stored in an Access database on
> one of the Win 2K 
> machines.
> 
> Samba is installed on the server that is running
> php/MySQL.  I don't have the 
> time at this point (or truthfully the desire even if
> I had the time) to 
> install the Windows variant of php and MySQL on the
> Win 2k box..  Heck, I 
> don't even have the time to do the reinstall of Cold
> Fusion 5  on the Win 2k 
> box.

If you decide to go with PHP and MySQL, definitely go
with a *nix operating system.  I realize that they are
supposed to work, but they were definitely designed
for *nix.

> 
> If anyone has experience using Unix tools (like Unix
> ODBC) or can point me to 
> a reference where I might learn how to make a
> Unix<-->Access db connection, 
> I'd be most appreciative.
> 
> TIA,
> 
> Tim Kellers
> CPE/NJIT
> 
> To Unsubscribe: send mail to majordomo@FreeBSD.org
> with "unsubscribe freebsd-questions" in the body of
> the message


=====
Christopher P Dempsey
---------------------

chrisdempsey@yahoo.com

__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message