An ODBC driver uses the Open Database Connectivity (ODBC) interface by 
Microsoft that allows applications to access data in database management 
systems (DBMS) using SQL as a standard for accessing the data. ODBC 
permits maximum interoperability, which means a single application can 
access different DBMS by using different ODBC drivers.

I had a single Paradox application a few years ago that you could swap 
between Firebird, Postgres or MS SQL databases (as long as the databases 
were present and ODBC drivers were configured) by just setting a startup 
parameter. So one company may have MS SQL Server, which was the original 
design, but another company without such a big wallet wanted Firebird 
and for another who chose to listen to my advice I used PostgreSQL. I 
just had the one application.

Tom Krieg wrote on 27/06/2019 10:22 AM:
> ODBC is a Microsoft standard way for connecting to databases. It's been 
> deprecated in the past but is now coming into favour again. You need to 
> download the Firebird ODBC driver from their website and install it, and 
> then use the Windows ODBC connection snap-in to create a system wide 
> connection. If you have the BDE set correctly, an alias for the ODBC 
> connection will be created automatically. Then you just use that alias 
> to connect to the database in Paradox with an ODBC connection string.
> 
> Liz McGuire wrote an article on the community website about how to use 
> ODBC in Paradox. She uses MS SQL but the same advice applies to Firebird.
> 
> Günter wrote on 26/06/2019 5:49 PM:
>> i still trying to do it with Firebird, and i am not sure what yo mean
>> with "and connect via ODBC", there is a entry in the BDE called
>> "Firebird/InterBase(r) driver", but my current access is via Native
>> INTRBASE connection. can you explain how to access via ODBC, i mean in 
>> OPAL?
>>
> 
> 


-- 
Tom Krieg
Contact me via the contact page at:
https://sdassociates.com.au