ForDBC from QT Software

Access Databases and Spreadsheets in Fortran on a PC under Windows

With ForDBC the Fortran programmer can read and write tables of any database for which an ODBC driver is supplied.

Most databases, such as Oracle, Microsoft, IBM and Sybase, are equipped with an ODBC driver (ODBC=Open Database Connectivity Standard).  This is also true for spreadsheets: Excel and Lotus.

Under Windows an ODBC interface is available. However the ODBC functions are not easy to access by a Fortran programmer because the documentation and the tools supplied by Microsoft are designed for C/C++ or VB programmers.  ForDBC offers help!  The Fortran interface provided by ForDBC is almost complete with respect to the ODBC v3.5 specification. This means that with ForDBC you can call all of these ODBC functions as if they were programmed in Fortran. Furthermore hundreds of ODBC and SQL specific constants are supplied. Simply include them in your Fortran program the source line

USE qtODBC

and you are ready to use the ODBC functions and constants as you find them documented in the Windows ODBC API.  This documentation either comes with your compiler (e.g., Compaq Visual Fortran, or Intel Visual Fortran, or Microsoft Visual Studio) or it can be found in the Microsoft Windows Platform Software Development Kit (SDK) which is supplied with most software development tools offered by Microsoft.  You can also find it on Microsoft’s Developer WebSite.  Getting started with ODBC can be tedious, so ForDBC is equipped with several example programs (completely in Fortran) which show you how to use ODBC. They demonstrate how to read from, or write to, tables in a Microsoft Access database or an Excel spreadsheet.

ForDBC comes with concise documentation which provides you with the essential information that you need for a quick start into ODBC programming.

Users of Compaq Visual Fortran and Intel Visual Fortran are supplied with a complete workspace (.dsw) and solution (.sln), respectively, which contains several sample projects which show how to access a database in several ways.

Licensing

ForDBC comes complete with source code, delivered with the licence and software by e-mail. You can use it in your programs and distribute these without any royalty payments or runtime fees.

ForDBC is available for the following compilers:

Lahey LF95 V5.7
Compaq Visual Fortran V6.6
Intel Visual Fortran 9.x and higher
Salford V4.x (not 5)

Platforms

Windows 98 and upwards (Win32 systems).

What do our Customers say about us?

Here is to the best software support team – ever! Many, many thanks. You have definitely made my day! yay!! :-)

HE

I have now followed your (very clear!) instructions and am happy to report that my problem is solved. Magic! You have made me a much, much happier person!

CS, Reading, UK

Thank you so much for all your help this morning. Endnote works just fine now and I’m enjoying working on this editorial. I am almost tempted to add your name as a co-author, but the journal won’t allow it! Thanks again.

DR RD

Bob delivered an engaging and interesting course. His style was very enjoyable.

For the time being we are unable to offer the following product ranges although we are currently working hard to increase the number of products we can offer in the future. Please contact us to talk about alternative products that we may be able to offer you.