PDA

View Full Version : Help Help PLZ


moreno
04-05-02, 12:15
Hi all,
I'm new to informix, I seted up INFORMIX-Oline Dynamic Server version 7.23 on NT.
I started it manuelly, and when I try to connect to the server I receve this error:
[Informix][SQLinformix]SQL Error(-908): Attempt to connect to the databse server(servername) Fallaid...:

azrealhk
04-08-02, 00:13
It has been sometime, since i had this problem.

However please check your
host file, to see if you have an entry for your Informix server. It should use tcp as a protocol.
Also check your sqlhosts file you see if you have an entry for your informix server and that you connection protocol is set to something like onsoctcp or onshmtcp.

moreno
04-08-02, 10:45
where is host file??? and sqlhosts fiel???

Thanks

azrealhk
04-08-02, 11:59
The host file should be in your windowns NT directory

C:\winNT

and the sqlhost file should be in the directory you installed
you Informix windows CLI.

Try find the files

should be called hosts
and sqlhosts

Sometimes WinNT will overwrite you hosts files.

I forgot to mention, you should also check your protocols and services
files, both should be in the WinNT directory also.

I am sorry but i cannot remember the actual values that should be in the files. I could look it up, but no garunteed to be accurate.

chulapat
04-11-02, 23:10
hosts file of Windows NT is in /winnt/system32/drivers/etc/hosts
sqlhosts file of Windows NT is located in the registry but you can modify it through Informix's Application called "setnet32"

Error 908 is the symtom that you cannot connect to your database server, there are many causes of this error, for examples.
1. Database server is down or shutdown.
2. Network connection between server and client is not available.
3. Wrong informix client configuration on client side.

Could you test something that will help you identify your cause of problem.
1. On command line utility, use command "onstat -" to make sure that
your database server is still online.
2. Try to connect to your database server through dbaccess (dbaccess is a simple database application on every informix server, you can use this application by using an informix command line utility, then type "dbaccess" and press enter, there is menu named "connect" in this program, try to use this command to connect to your database server.
If you cannot connect to your database server by showing error 908,
I think it may have a wrong configuration on your database server itself.


If you want me to diagnose your error please send me your configuration, onconfig file, hosts file, and detail of sqlhosts file on this webboard. I will help you solve this problem.