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
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.
See our video tutorials to get a quick start into using ForDBC.
Illus: ForDBC example program (T_ODBCAccessRd) in Visual Studio with Solution- & Server-Explorer
ForDBC comes complete with example 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 10.0 and higher
Salford V4.x (not 5 or higher)
Windows XP and upwards (Win32/Win64 systems).