From owner-freebsd-questions Tue Feb 26 19:47:35 2002 Delivered-To: freebsd-questions@freebsd.org Received: from mail-shield1.njit.edu (mail.njit.edu [128.235.251.171]) by hub.freebsd.org (Postfix) with ESMTP id 5E83737B400 for ; Tue, 26 Feb 2002 19:47:31 -0800 (PST) Received: (from uucp@localhost) by mail-shield1.njit.edu (8.11.6/8.11.6) id g1R3jtU10619; Tue, 26 Feb 2002 22:45:55 -0500 (EST) Received: from nodnsquery(128.235.251.173) by mail-shield1.njit.edu via csmap (V4.1) id srcAAAtfaqVu; Tue, 26 Feb 02 22:45:55 -0500 Received: from adm.njit.edu (adm.njit.edu [128.235.184.76]) by mail-gw5.njit.edu (8.11.6/8.11.6) with ESMTP id g1R3jsF15225; Tue, 26 Feb 2002 22:45:55 -0500 Received: by adm.njit.edu with Internet Mail Service (5.5.2653.19) id ; Tue, 26 Feb 2002 22:44:56 -0500 Message-ID: From: "Kellers, Timothy" To: "'Bill Moran '" , "'Tim Kellers '" , "'questions@freebsd.org '" Cc: "'kellers@njit.edu '" Subject: RE: Access database, Unix and php Date: Tue, 26 Feb 2002 22:44:47 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Thanks for the input Bill, but I do sort of have to go in exactly the opposite direction (If it's possible) I have to get Apache + php to see an Acces database on the remote server. But, I do appreciate your input, when all else (might) fail, I'll be sure to give it a go. Thanks, Tim -----Original Message----- From: Bill Moran To: Tim Kellers; questions@freebsd.org Cc: kellers@njit.edu Sent: 2/26/02 10:39 PM Subject: Re: Access database, Unix and php On Tuesday 26 February 2002 22:09, Tim Kellers 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. > > 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. You could install the ODBC drivers for MySQL in the W2K machine and use that to access the data on the MySQL server on the FreeBSD machine. I've used these Windows ODBC drivers in production and they work pretty well. I know that's not exactly what you're asking, but I thought I'd put it out there in case you hadn't thought of it. > 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 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 -- Bill Moran Potential Technology technical services http://www.potentialtech.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message