Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Angry Unanswered: Installing 9.20 UC1 on Redhat 9.0

    I am trying to Install 9.20 UC1 on Redhat 9.0. I have tried following their books but they are a pain in the.. They jump all over the place manual to manual, and page to page and since they are come in PDF it is even worse.

    I can get it up and running but have trouble accessing it from Windows ODBC. I have an application that is talking to it and some works some does not. I think I am messing up on setting sqlhosts, onconfig, env. vari., and services.

    env. vari.
    INFORMIXSERVER=in4mix

    onconfig
    DBSERVERNAME in4mix

    sqlhosts
    in4mix onsoctcp informix in4mix

    services
    informix 3000/tcp #IDS 9.2

    Please what am messing up.

    Since it is 9.20 UC1 I am trying to get updates but IBM seems unfriendly with updates.

    Thanks for any help...
    James

  2. #2
    Join Date
    Jan 2004
    Posts
    6

    Question Re: Installing 9.20 UC1 on Redhat 9.0

    Which version of CSDK are you using on windows ?

    NS

    Originally posted by stedlj
    I am trying to Install 9.20 UC1 on Redhat 9.0. I have tried following their books but they are a pain in the.. They jump all over the place manual to manual, and page to page and since they are come in PDF it is even worse.

    I can get it up and running but have trouble accessing it from Windows ODBC. I have an application that is talking to it and some works some does not. I think I am messing up on setting sqlhosts, onconfig, env. vari., and services.

    env. vari.
    INFORMIXSERVER=in4mix

    onconfig
    DBSERVERNAME in4mix

    sqlhosts
    in4mix onsoctcp informix in4mix

    services
    informix 3000/tcp #IDS 9.2

    Please what am messing up.

    Since it is 9.20 UC1 I am trying to get updates but IBM seems unfriendly with updates.

    Thanks for any help...
    James

  3. #3
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi James,

    You say:

    sqlhosts
    in4mix onsoctcp informix in4mix

    services
    informix 3000/tcp #IDS 9.2

    The 4th column of $INFORMIXDIR/etc/sqlhosts implies the service name, and it is linked with 1st column of /etc/services file. Hence, the /etc/services file entry would look like:

    in4mix 3000/tcp #IDS 9.2

    Regards,
    Shriyan

  4. #4
    Join Date
    Jan 2004
    Posts
    17

    Re: Installing 9.20 UC1 on Redhat 9.0

    I have installed Informix Connect 2.7 and using ODBC driver 3.34.

    Originally posted by psilu
    Which version of CSDK are you using on windows ?

    NS

  5. #5
    Join Date
    Jan 2004
    Posts
    6
    Informix sqlhosts entry should be

    informixserver protocol hostname service entry/port #

    For Example if i have a sqlhosts entry as

    demo_on onsoctcp adara demo

    Where adara is the hostname on which informix server runs.
    My /etc/services should look like

    demo 8000/tcp # informix server

    You can specify port number directly in the 4 th column instead of service name.

    Hope this helps
    NS

  6. #6
    Join Date
    Jan 2004
    Posts
    17

    Red face Worse

    I decided on doing a full rebuild and now I can not get it to complete "oninit -iv" stops at "Initializing log/checkpoint information..." Guess I'll try another rebuild... Wish this app would run on MySQL I would have been done days ago.

    In general "Not happy"!

    James...

  7. #7
    Join Date
    Jan 2004
    Posts
    17
    I think I have everything set correctly now on the server side.

    Here is what I understand needs to match what!

    /opt/informix/etc/onconfig
    DBSERVERNAME our_in4mix

    Environment Variables in .bach_profile
    export INFORMIXSERVER=our_in4mix

    /etc/hosts
    192.168.1.106 ourdb.something.com

    etc/services
    on_ourdb 3000/tcp #IDS 9.2

    /opt/informix/etc/sqlhosts
    our_in4mix onsoctcp ourdb on_ourdb


    Now I need help to setup the ODBC in Windows XP?

    Add line to C:\WINDOWS\system32\drivers\etc\services
    on_ourdb 3000/tcp #IDS 9.2

    Add lines to C:\WINDOWS\system32\drivers\etc\hosts
    192.168.1.106 ourdb.something.com
    192.168.1.106 ourdb

    Setup ODBC using Informix 3.34 32-bit
    Data source name: db_source

    Server Name: our_in4mix
    Host Name: ourdb
    Service: our_informix
    Protocol: onsoctcp

    I think everything is right, but it does not work!
    Thanks for your help,
    James...
    Last edited by stedlj; 01-15-04 at 13:55.

  8. #8
    Join Date
    Jan 2004
    Posts
    17

    Found answer!

    I got it working when I changed sqlhosts from

    our_in4mix onsoctcp ourdb on_ourdb

    to

    our_in4mix onsoctcp 192.168.1.106 on_ourdb

    I had it listed in the hosts file but it did not like it? Once I made this change I could connect via ODBC.

Posting Permissions

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