Results 1 to 5 of 5

Thread: Help Help PLZ

  1. #1
    Join Date
    Feb 2002
    Location
    quebec city
    Posts
    3

    Red face Unanswered: Help Help PLZ

    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...:

  2. #2
    Join Date
    Apr 2002
    Posts
    4
    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.

  3. #3
    Join Date
    Feb 2002
    Location
    quebec city
    Posts
    3
    where is host file??? and sqlhosts fiel???

    Thanks

  4. #4
    Join Date
    Apr 2002
    Posts
    4
    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.

  5. #5
    Join Date
    Feb 2002
    Location
    Bangkok
    Posts
    11
    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.
    Erawan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •