Seeing 32-bit ODBC Data Sources in OI (Performance,Warehousing)

NOTE:  OpenInsight is a Windows 16-bit application and therefore Revelation Software strongly recommends using only 16-bit ODBC drivers.  In some cases, you may only have a 32-bit driver for your data.  The following instructions show how you can  thunk  the Win 95 ODBC layer to determine whether OpenInsight can use the driver in question.

 Thunking  does not provide exceptional performance, nor 100% compatibility.  This should only be used on a temporary basis.

In Windows 95, ODBC.INI has a section for 32-bit connections named:

[ODBC 32 bit Data Sources]

If it doesn't have a section named:

[ODBC Data Sources]

Then add it (this is the 16-bit connection section).

Now you can copy items from the 32-bit connection section to the 16-bit connection section.  For example, if your INI has:

[ODBC 32 bit Data Sources]

ODBC_dBASE=Microsoft dBASE Driver (*.dbf)

sql6=SQL Server (32 bit)

[ODBC Data Sources]

Then you can change it to:

[ODBC 32 bit Data Sources]

ODBC_dBASE=Microsoft dBASE Driver (*.dbf)

sql6=SQL Server (32 bit)

[ODBC Data Sources]

ODBC_dBASE=Microsoft dBASE Driver (*.dbf)

sql6=SQL Server (32 bit)

At this point, when you create a Connection Object in the Client/Server Workspace, the list of data sources to choose from will include any of the 32-bit data sources that you copied into the 16-bit section of the ODBC.INI.