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

Which version of CSDK are you using on windows ?

NS

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

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

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

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

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

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.