VA Smalltalk ODBC Support uses a file called ODBC.INI to store ODBC configuration and connection information. This file contains a data sources section, which provides the ODBC driver manager with a list of data sources supported for your connection requests. Each data source listed in the data sources section has a corresponding data source name (DSN) section, which defines information such as the ODBC driver location, the name of your database server, the name of the database, logon information, and any specific database information.
The ODBC Administrator uses a file called ODBCINST.INI as the source of information about installed drivers. VA Smalltalk ODBC Samples includes an application that you can use to create the ODBCINST.INI file. Under Windows, once you have installed the ODBC drivers, use the ODBC Administrator to create your ODBC.INI file. The ODBC Administrator is provided with VA Smalltalk ODBC Support (under UNIX, you cannot use the ODBC Administrator).
In general, to create your ODBC.INI file for a particular database, you need to refer to the help for that database.
To create the ODBC.INI file, follow these steps:
|
1.
|
Make sure you have loaded the VA: Database, ODBC Samples feature into your image.
|
|
4.
|
The ODBC administrator is not available on UNIX, and you have to edit the odbc.ini file manually.
