From Lesta@t-online.de  Sun Oct 24 12:36:11 1999
Received: from mailout01.btx.dtag.de (mailout01.btx.dtag.de [194.25.2.149])
	by swi.psy.uva.nl (8.9.3/8.9.3) with ESMTP id MAA27942
	for <prolog@swi.psy.uva.nl>; Sun, 24 Oct 1999 12:36:11 +0200 (MET DST)
Received: from fwd08.btx.dtag.de ([194.25.2.168])
	by mailout01.btx.dtag.de with smtp 
	id 11fL0m-0008AA-00; Sun, 24 Oct 1999 12:36:28 +0200
Received: from t-online.de (05121269112-0001(btxid)@[62.158.100.175]) 
	by fwd08.btx.dtag.de with smtp
	id <m11fL0i-0006xsC>; Sun, 24 Oct 1999 12:36:24 +0200
Message-ID: <3812E082.D571D1D@t-online.de>
Date: Sun, 24 Oct 1999 12:33:38 +0200
X-Mailer: Mozilla 4.05 [de]C-DT  (Win95; I)
MIME-Version: 1.0
To: Stefano De Giorgi <s.degiorgi@tin.it>
CC: prolog@swi.psy.uva.nl
Subject: Re: ODBC interface
References: <000c01bf1d7d$fc240600$7843abd4@w98>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Sender: 05121269112-0001@t-dialin.net
From: Lesta@t-online.de (Uwe Lesta)

Stefano De Giorgi schrieb:
> 
> Hi,
> I need to access relational DBMS (MS-Access or Oracle) from SWI-Prolog,
> do you know if there exists a free ODBC interface for SWI-Prolog?

NO, as far as i know.

But there is an ODBC -Interface for SICS and Quintus Prolog
called ProData/ProDBI from "Rob Lucas and Keylink Computers Ltd."

Janusz Launberg from sicstus wrote in the sics mailing list about it :

> We have not used Prodata much in our projects. It's fair to say there are
> not many users of this product. There are, however, a few commercial users
> of ProData on Windows NT with the latest version of SICStus.  ProData is
> basically identical to ProDBI (ODBC version) for Quintus Prolog. One should
> expect that the performance of ProData/ProDBI may be a problem when high
> performance is required in heavy DB applications. Some of our Quintus
> Prolog customers had to interact with the relational database at the
> application level to meet performance requirements. 

I had tested it for a month. Not so bad especially on the first
prototypes.
But i need only to read the database. So i wrote some DB reports to a
db.pl
file and work with it. SWI-Polog consults such factbases very fast
(much faster as sics :-).

Generally i am interested too on an ODBC-Interface. 
So if someone like to ask "Rob Lucas" to get the sources for porting to
SWI-Prolog
(Perhaps SWI). I agree to do the work.
-- 


Regards

Uwe
Lesta@t-online.de

