From owner-freebsd-questions Sun Jul 9 12: 2:48 2000 Delivered-To: freebsd-questions@freebsd.org Received: from durango.picus.com (durango.picus.com [209.100.20.19]) by hub.freebsd.org (Postfix) with ESMTP id 12C1837B56E for ; Sun, 9 Jul 2000 12:02:44 -0700 (PDT) (envelope-from troy@picus.com) Received: from arcadia [209.100.20.198] by durango.picus.com (SMTPD32-5.05) id ABC211290096; Sun, 09 Jul 2000 15:00:18 -0400 Reply-To: From: "Troy Settle" To: "Danny" , "J Peltier" , Subject: RE: Apache on BSD SQL on NT Date: Sun, 9 Jul 2000 15:01:57 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: Normal In-Reply-To: <00070515024005.00335@dannyh.freebsd.org> Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG After installing the apache13 port, install the mod_php3 port (I don't know about php4 yet). When you do a make on the mod_php3 port, you'll be presented with a dialog asking what options you wnat support for. One of those options is Sybase-CT. Select it and whatever other options you want, and let the build proceed (the port will pull in freetds as a dependancy). Once completed, review the documentation for FreeTDS. You'll need to make sure you have the following: 1. Proper entry in your interfaces file, located somewhere under /usr/local/etc/ 2. SYBASE environment variable needs to be set to '/usr/local' before running Apache. I do this in the apachectl script so that it's set every time I stop/start apache manually. Once done, you should be able to access your SQL7 server without issue. I've done it, and it works well enough. Sorry the details here are sketchy, but the whole setup is on a vmware system that I don't have ready access to (need to license it). G'luck, -- Troy Settle Network Analyst Picus Communications 540.633.6327 It's always a long day... 86400 doesn't fit into a short ** -----Original Message----- ** From: owner-freebsd-questions@FreeBSD.ORG ** [mailto:owner-freebsd-questions@FreeBSD.ORG]On Behalf Of Danny ** Sent: Wednesday, July 05, 2000 1:01 AM ** To: J Peltier; freebsd-questions@FreeBSD.ORG ** Subject: Re: Apache on BSD SQL on NT ** ** ** ** I believe you can't do that. ** Why not get your client to use mysql or postesql ? ** ** You should check out the php3 web site www.php.net web site for ** more details. ** ** ** On Wed, 05 Jul 2000, J Peltier wrote: ** > >%_I know this prolly isn't the right place to ask but is it ** possible for a BSD machine running apache and php to access a ** MS-SQL database? If so how? ** > ** > ** > ** ** ---------------------------------------- ** Content-Type: text/html; name="unnamed" ** Content-Transfer-Encoding: quoted-printable ** Content-Description: ** ---------------------------------------- ** ** -- ** ** ---------------------------------------------------------------- ** You are not authorized to use my email address for any purpose. ** This is a violation of my privacy. Remove my email ** address from your databases immediately. ** ---------------------------------------------------------------- ** ** ** To Unsubscribe: send mail to majordomo@FreeBSD.org ** with "unsubscribe freebsd-questions" in the body of the message ** To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message