Runtime/Compiler errors

I always get error number -329

Error number -329 can occur for a number of reasons. This may be an error returned from the database engine, but it may also be because Hydra is failing to load the interface for the database you are trying to use. One of the common reasons for this, is that the necessary pre-requisites for working with the database are not present.

Informix OnLine/SE

-1829

The Informix SDK is unable to load the file $INFORMIXDIR/msg/citoxmsg.pam. Check the value of the environment variable INFORMIXDIR.

The Informix server specified in the environment is not recognised. This could either be that the environment variable $INFORMIXSERVER has not been set, or that the value specified is not found in $INFORMIXDIR/etc/sqlhosts

If you are using Informix SE, then it is most likely that the database cannot be located in the directories specified in the environment variable DBPATH, or that you do not have the required priviledges to access/read the database files. Check the setting for $DBPATH, and the 'grant' privileges given to the user you are connecting as.

The Informix connection is unable to validate the user/password for this connection. If you are using the legacy Querix connection method, then you can set the environment variable INFORMIXPASS to the correct password. If you are using the native Informix method, then check the password settings in setnet32 (setnet32 only exists in the Windows environment).

Oracle

In general, with Oracle connections, it is best to ensure that the environment variables ORACLE_SID and ORACLE_HOME are set correctly.

SQL Server

Few connection problems are associated with SQL Server. If you are having problems, it is first necessary to ensure that you have created a DSN for the database connection, and that the instance is available.

If you are having connect problems in GUI mode only, then it is possibly due to the user ID of the process.

I can compile/run in character mode, but have problems when running with Phoenix.

Programs running in GUI may be running as a different user from that which you used to compile the program. Also, it is likely that the environment for the process will be different.

Changing the user ID

Microsoft Windows users can change the default user ID of the GUI process from the control panel. Select 'Administrative tools' > 'Services'. In the Services dialog, select the properties for the service 'qxinetd', and under the 'log on' tab, specify a user for the service. Once you have done this, you must restart the service.

Editing the environment

The GUI process will run through a specifc environment which may differ to that of normal users. You can edit the environment within 'HydraStudio'. Select the 'GUI Servers' tab, above the project tree, and select 'Environment' to open the GUI environment editor.