Make sure the destination database is running and that you have modified the batch file's 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, where NAS21 is the default installation directory:
<drive>:\NAS21\Apps\GXApp\load_ora.bat
<drive>:\NAS21\Apps\GXApp\load_syb.bat
<drive>:\NAS21\Apps\GXApp\load_ifmx.bat
<drive>:\NAS21\Apps\GXApp\load_mssql.bat
<drive>:\NAS21\Apps\GXApp\load_db2.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 data source name and a database name. You can also directly edit the odbc.ini file.
To configure the new data source for access through a native driver, do one of the following:
-
For Oracle databases, use the Oracle Network Manager to add the data source 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 data sources.
-
For Sybase databases, use the sybinit or dsedit utility to add the data source 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 data source, or edit the odbc.ini file manually.
-
For Microsoft SQL Server databases, use the SQL Enterprise Manager to add the data source to the kivasoft.dat file.
The sample data source is now configured and can be accessed by the
sample applications.