ODBC problem with Informix server connecting to client application

[Alan Casey]

> All,
>
> I have a problem connecting an Informix database on a server on a Win NT
> platform to a client application on a remote PC.
> . I managed to set up the database alright and populated the tables from
> within DBaccess using the notepad editor, but we could not set up the
> connection properly. Everytime we booted up the Laser software (ie. the
> client application) we got the data connection error message come up i.e.
> errors saying 'could not locate master_sn table' etc. etc. So I am not
sure
> whether the problem is the database itself or the connection to the Laser.
A
> few questions:
>
> 1. Should the database be saved in the /etc/ folder and have an *.sql
> extension? There were 3 databases in the dbaccess window, 2 of which were
> there already and viewable in the /etc directory, but the none I created I
> could not find. How can I verify that the database I created exists other
> that from within dbaccess?
>
> 2. In the Setnet32 app on the client PC, I have changed all the server,
> host, service name to the settings of the Informix server we installed. I
> set the Informixdir and Informix server as defined. Is this all correct?
>
> 3. We configured the ODBC system data source to that of the Informix
server
> and host etc. but still could not communicate.
>
>
> 4.We even copied the database on to the local machine and tried to connect
> to it, did not work, might suggest a problem with the database?
>
> Any help would be appreciated.
>
> Rgds
> Alan
>
>