background image
<< DB_FetchNext function | Restoring the Sample Database >>

Switching from the Access database to the text database

<< DB_FetchNext function | Restoring the Sample Database >>
140
Getting Started: A Tutorial
8 T
ESTING
D
ATABASES
Switching from the Access database to the text database
Switching from the Access database to the text database
Even though you have installed the ODBC driver and used the Access
database with the GMO application, you can switch back to using the text
database.
1
Exit the GMO application, if it is running
Click File/Exit.
2
Open the Database Administrator dialog
From the Windows Start menu, click Settings/Control Panel/Data
Sources (ODBC)
.
3
Remove a DSN
Click the User DSN tab. Select Green2. Click Remove.
4
Confirm the removal
On the Confirmation dialog, click Yes.
5
Close the ODBC Data Source Administrator dialog
Click OK.
6
Start the GMO application
The GMO application now uses the text database.
DB_FinishSql
and DB_
Disconnect
The DB_FinishSQL function removes the results of
the SELECT statement and releases the system
resource, that is, the specified statement handle,
hstmnt. Note that DB_FinishSql is not strictly
necessary in this example, because the DB_
Disconnect function, which releases all statements for
the connection, follows immediately.
Function
Description