Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2011

    Unanswered: Connection to INFORMIX database

    I am using Oracle GAteway to connect to INFORMIX database . I need the following information

    Hostname,port,server alias, database

    Can some one please give me commands to get this information on server having INFORMIX database.

    Its on Unix server.
    I know the hostname and database bt how to get port number and server alias


  2. #2
    Join Date
    Sep 2011
    Pont l'Abbé, Brittany, France
    Provided Answers: 1

    the serveralias is contained in the $INFORMIXDIR/etc/$ONCONFIG file
    look at the value for the DBSERVERALIASES.

    Once you got this value, open the $INFORMIXDIR/etc/sqlhosts, find this value in the 1st column, the service name for this instance is in the 4th column. Then find the service name in the /etc/services files, and you'll get the port number.

    And there you go!

Posting Permissions

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