[Fwd: Re: 'bout Revolution and FireBird]

Thu Oct 2 07:13:06 EDT 2003

Julio,

I encourage you to ask more about RevDB to Tuviah Snyder (RunRev's
technical manager and RevDB developer).
-- 
Bien cordialement, Pierre Sahores

100, rue de Paris
F - 77140 Nemours

GSM:   +33 6 03 95 77 70
Pro:   +33 1 41 60 52 68
Dom:   +33 1 64 45 05 33
Fax:   +33 1 64 45 05 33

Inspection académique de Seine-Saint-Denis
Applications et SGBD ACID SQL (WEB et PGI)
Penser et produire "delta de rentabilité"
-------------- next part --------------
Return-Path: <use-revolution-admin at lists.runrev.com>
Delivered-To: psahores at easynet.fr
Received: (qmail 7656 invoked from network); 2 Oct 2003 15:50:59 -0000
Received: from unknown (HELO mx2.mail.easynet.fr) ([10.0.1.57])
	(envelope-sender <use-revolution-admin at lists.runrev.com>) by
	mailhub2.mail.easynet.fr (qmail-ldap-1.03) with SMTP for
	<psahores at easynet.fr>; 2 Oct 2003 15:50:59 -0000
Received: from www.runrev.com (www.runrev.com [64.23.0.192]) by
	mx2.mail.easynet.fr (Postfix) with ESMTP id 5B5C47A8B for
	<psahores at easynet.fr>; Thu,  2 Oct 2003 17:50:46 +0200 (CEST)
Received: from www.runrev.com (IDENT:mailman at localhost.localdomain
	[127.0.0.1]) by www.runrev.com (8.9.3/8.9.3) with ESMTP id LAA30906; Thu, 2
	Oct 2003 11:01:15 -0400
Received: from www.kmax.ici ([194.167.42.210]) by www.runrev.com
	(8.9.3/8.9.3) with ESMTP id LAA30841 for <use-revolution at lists.runrev.com>;
	Thu, 2 Oct 2003 11:00:55 -0400
Received: by www.kmax.ici (Postfix, from userid 500) id 510951963D; Thu,  2
	Oct 2003 17:50:09 +0200 (CEST)
Subject: Re: 'bout Revolution and FireBird
From: Pierre Sahores <psahores at easynet.fr>
To: "use-revolution at lists.runrev.com" <use-revolution at lists.runrev.com>
In-Reply-To: <003f01c388ea$5d06fe10$0100a8c0 at avatar>
References: <003f01c388ea$5d06fe10$0100a8c0 at avatar>
Content-Type: text/plain; charset=UTF-8
Organization: 
Message-Id: <1065109808.3664.35.camel at www.kmax.ici>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.3 
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by www.runrev.com id
	LAA30841
Sender: use-revolution-admin at lists.runrev.com
Errors-To: use-revolution-admin at lists.runrev.com
X-BeenThere: use-revolution at lists.runrev.com
X-Mailman-Version: 2.0.8
Precedence: bulk
Reply-To: use-revolution at lists.runrev.com
List-Help: <mailto:use-revolution-request at lists.runrev.com?subject=help>
List-Post: <mailto:use-revolution at lists.runrev.com>
List-Subscribe: <http://lists.runrev.com/mailman/listinfo/use-revolution>,
	<mailto:use-revolution-request at lists.runrev.com?subject=subscribe>
List-Id: How to use Revolution <use-revolution.lists.runrev.com>
List-Unsubscribe:
	<http://lists.runrev.com/mailman/listinfo/use-revolution>,
	<mailto:use-revolution-request at lists.runrev.com?subject=unsubscribe>
List-Archive: <http://lists.runrev.com/pipermail/use-revolution/>
X-Original-Date: 02 Oct 2003 17:50:09 +0200
Date: 02 Oct 2003 17:50:09 +0200

Hi Jlio,

Revolution is full featured to let us build fine web's/erp's clients and
server side applications. I used Metacard and Revolution extensively
since 98 in this way with full satisfaction.

There are, for yet, two ways you can use to connect Revolution to
FireBird (in between, FB is a great acid compliant db !) :

- the build-in "RevDB" library to connect both Rev's client-side
front-end, via "POST method" requests to your remote or localhost server
- the build-in shell() command in sending direct SQL's statements to the
FireBird command-line client via "pipe" statements. This way can be
usefull to bind server-side Rev's apps to your FireBird back-end (in
root mode). It's the way i used for years, before Tuviah did the RevDB
lib available to us (Rev 1.1.1 and above).

I would recommand you to use the first way, even if the second, i used
extensively (Linux/OSX, Apache, MC/RR, PostgreSQL) for years, can be
usefull too, if needed.

See below an example of code you can test and adapt to your own needs :

>    put "psql -h localhost projecoles -U postgres" into PgPath
>    put shell("echo" && quote & "select * from etablist order by
etab0011" && quote && "|" && PgPath) into AccPpx

Have fun !

Bests, Pierre

Le jeu 02/10/2003  15:37, Jlio Csar Kdel a crit :
> I was developing a commercial system in VB 6, but many clients request
> me Linux compatibility, which I can't achieve with VB, then, I found
> Revolution and downloaded a trial version to see its capabilities... I
> already know that Revolution have support for MySQL and ODBC, but I
> using FireBird (a Interbase compatible database engine). In Windows, I
> have an OCX DLL that implement ODBC with FireBird (and thus, allowing
> VB access to FireBird). But, I don't know how this work on Linux
> systems... It will be possible to use FireBird on Linux, or even ODBC?
> Any help on this issue will be welcome... ;-)
>  
> Thanx in advance,
> Tenebree Software
> http://www.tenebree.com
>  
-- 
Bien cordialement, Pierre Sahores

100, rue de Paris
F - 77140 Nemours

GSM:   +33 6 03 95 77 70
Pro:   +33 1 41 60 52 68
Dom:   +33 1 64 45 05 33
Fax:   +33 1 64 45 05 33

Inspection acadmique de Seine-Saint-Denis
Applications et SGBD ACID SQL (WEB et PGI)
Penser et produire "delta de rentabilit"
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution