MFC/ODBC

OS:

WINDOWS 95/98
WINDOWS NT
WINDOWS 2000

Company:

Microsoft

Properties:

Stable native database connector to ODBC with MFC.
MFC/ODBC driver can be compiled only with Microsoft Visual C++ (and however with Borland C++ Builder with MFC support)

Configuration data

Key	Description
CONNECTIONSTRING	ODBC connection string

Remarks:

ODBC connection string is ODBC ability. This string hold all information for the connection, include database name, username, password(!!!), special server-depend parameters etc. An simplest examples:

Connect to Ms Access database using default values.

	DSN=access_proba

Connect to same Ms Access database with advanced configuration

	DSN=access_proba;DBQ=c:\ib\proba.mdb;DriverId=281;FIL=MS Access;MaxBufferSize=512;PageTimeout=5;UID=admin

Connect to local Interbase server

	DSN=ib_proba;UID=SYSDBA;PWD=secret;Hostname=<local>;NetworkProt=<local>;Database=c:\ib\proba.gdb

Connect to dBase III files

	DSN=dbf;DBQ=c:\ib;DefaultDir=c:\ib;FIL=dBase III

Connect to ODBC text database

	DSN=text;DBQ=c:\IB;DefaultDir=c:\IB

Instead of guess CONNECTIONSTRING for your ODBC database, you may use pogram named "odbc_param" (or "o_param").

This program ask you for ODBC DSN, then connect and show you CONNECTIONSTRING and some extra info about the database.

The program is included into the distribution

Here you are a screenshot:

=============================
ODBC Param Helper Version 1.0
=============================
        Copyleft 01.2000, Nikolay Mijaylov
        "http://www.nmmm.nu/" <nmmm@nmmm.nu>
        Distribution: GPL

Database        : c:\INFO_MAP
ODBC String     : ODBC;DSN=access_proba
Transactions    : Nope
[cr]

ODBC w/s BDE

ODBC executable is smaller
BDE executable needs of 10MB support libraries
However ODBC is slower
However ODBC support less ability SQL
In most cases BDE supports native database API