From owner-freebsd-questions  Fri Jan 30 00:30:21 1998
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Received: (from majordom@localhost)
          by hub.freebsd.org (8.8.8/8.8.8) id AAA16436
          for questions-outgoing; Fri, 30 Jan 1998 00:30:21 -0800 (PST)
          (envelope-from owner-freebsd-questions@FreeBSD.ORG)
Received: from omnix.net (omnix.net [194.183.217.130])
          by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id AAA16431
          for <questions@FreeBSD.ORG>; Fri, 30 Jan 1998 00:30:18 -0800 (PST)
          (envelope-from didier@omnix.net)
Received: from localhost (localhost [127.0.0.1])
          by omnix.net (8.8.7/8.8.7) with SMTP id IAA08857;
          Fri, 30 Jan 1998 08:30:02 GMT
          (envelope-from didier@omnix.net)
Date: Fri, 30 Jan 1998 09:30:01 +0100 (CET)
From: Didier Derny <didier@omnix.net>
To: Karl Pielorz <kpielorz@tdx.co.uk>
cc: questions@FreeBSD.ORG
Subject: Re: ODBC / SQL & Windows NT
In-Reply-To: <34D0A228.7CBFD748@tdx.co.uk>
Message-ID: <Pine.BSF.3.96.980130092413.8247A-100000@omnix.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG
X-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe questions"

On Thu, 29 Jan 1998, Karl Pielorz wrote:

> 
> Hi,
> 
> I would like to be able to use my FreeBSD box as an SQL server, access the SQL
> database from shell / perl / C++ etc. on the FreeBSD box itself, and be able
> to access the SQL server via a remote Windows NT box (i.e. running ODBC
> drviers).
> 
> I've looked at Postgress & mySQL - is what I'm trying to do possible at the
> moment with either of these packages, or how close can you get to this
> 'ideal'? - Does anyone run anything similar?
> 
> I've also heard rumours that mySQL doesn't perform too well under FreeBSD? Can
> anyone comment on this (or the performance of Postgress?)
> 
> Thanks in Advance,
> 
> Kp
> 

Hi,

I'm running Yard SQL, It works really fine with FreeBSD.
I know that's a commercial package but when I tried mSQL it was too
limited, mySQL had no transactions and there were many problems
between Postgresql (my first choice) and ODBC.

I finally chose Yard. an evaluation version is available at www.yard.de.

You can write your programs with  either ESQL or CLI / ODBC.

they have a support for PHP/FI 2.0.

I've ported their PHP Interface to PHP 3.0 and I'm writing some
extensions. (probably freely available in a few weeks [I have to check
with Yard first (a part comes from their source code)].


--
Didier Derny
didier@omnix.net