Make sure the destination database is running and that you have modified the shell scripts login and password to match that of your database administrator account.
To connect to the database and load the data, do one of the following:
<drive>:\kiva\kes\Apps\GXApp\load_ora.bat
<drive>:\kiva\kes\Apps\GXApp\load_syb.bat
<drive>:\kiva\kes\Apps\GXApp\load_ifmx.bat
<drive>:\kiva\kes\Apps\GXApp\load_mssql.bat
You can also invoke these files from within the database client utilities.
Make sure you connect to the database as a system user.
The sample data is loaded when the SQL file finishes running.
If you are going to access the database through an ODBC driver, use the ODBC Data Source Manager and add ksample as a datasource and a database name. You can also directly edit the odbc.ini file.
To configure the new datasource for access through a native driver, do one of the following:
-
For Oracle databases, use the Oracle Network Manager to add the datasource to the tnsnames.ora file, or edit the file manually. This file might reside on the local Oracle database, or in the Oracle Name Server, if you are supporting distributed datasources.
-
For Sybase databases, use the sybinit or dsedit utility to add the datasource to the interfaces file, or edit the file manually.
-
For Informix databases, the native database driver is implemented as an ODBC driver. Therefore, use the ODBC Data Source Manager to add the sample datasource, or edit the odbc.ini file manually.
-
For Microsoft SQL Server databases, use the SQL Enterprise Manager to add the datasource to the kivasoft.dat file.
The sample datasource is now configured and can be accessed by the
sample applications.