Can not find database on informix SE server

torrud · #1 (**permalink**) 09-20-06, 06:10

Hi,

I am running a INFORMIX SE Version 7.24.UC5 server on a linux OS and I am trying to change to remote connection. I have changed the sqlhosts to:

Quote:

myInformixServerName sesoctcp myServerName sqlexec_dbtcp

Additional I opened the port for the service in the /etc/services.

Now I can ping the server and all seems to be ok, but if I try to connect the server I get the following exception:

Quote:

Connection failed: Database not found or no system permission. (error: 329)

The log file only shows the following:

Quote:

2006-09-20 11:55:28.696944 sqlexec myIP myUsername -X(null)

Any suggestions what I am doing wrong?

torrud · #2 (**permalink**) 10-05-06, 07:59

No ideas? It is possible to increase the logged informations? Maybe there are some points of interests.

Tyveleyn · #3 (**permalink**) 10-05-06, 08:15

Here's a part of the output for errno 329 from the finderr utility:

Quote:

If you are using INFORMIX-SE, the visible databases are directories
with names in the form dbname.dbs. You must be able to read from and
write to them. The database server looks first in the current working
directory and then in each directory named in the DBPATH environment
variable. The most common cause of this error is an incorrect setting
or no setting for the DBPATH environment variable.

Maybe this can be helpful.

Good luck,
Hans

Internet Services

Web Development

Digital Marketing

Consumer Tech