Help! ODBC problems - what to look at on server side

[WiccaChic]

Hi all. Having an ODBC problem all of a sudden. Same ODBC stack and config on (about 300) pcs thats been working for 2 years stopped working today when trying to connect to one of my three informix (AIX/rs6000) servers.

I am pretty sure the trouble is on the server side since the same pcs can connect to two other servers via odbc with exact same configs just different IP addresses of course. What do I look for on the server side? This is the first time I have even considered the matter and I realize I dont even know what makes ODBC work on the AIX server side. Help please!

Oh yeah, I am getting a message in the online.log noting the failure, its -952 and indicates that the user password is wrong. Thats not true, the passwords are fine and I have tried multiple user accounts all of which work for everything except ODBC.

I am lost!

 

[vpshriyan]

Hi Wic,

All the system/user dsn specifications in ODBC setup refers to back-end parameters configured for the client-server computings. Hence, you need to configure and test your back-end Unix box first.

At your server box check the below:

grep $INFORMIXSERVER $INFORMIXDIR/etc/$ONCONFIG # should return one line
grep $INFORMIXSERVER $INFORMIXDIR/etc/sqlhosts # should return one line

SOCDB=`grep DBSERVERALIASES $INFORMIXDIR/etc/$ONCONFIG | awk '{print $2}'`
SERV=`grep $SOCDB $INFORMIXDIR/etc/sqlhosts | awk '{print $4}'`
grep -i $SERV /etc/services # should return one line

You can varify the service related network information by:
onstat -g ntt

see the thread name and address column & locate thread named soctcplst.

This thread will help you in setting up the back-end/front-end drivers in detail:
thread876-409375

Regards,
Shriyan
"It takes a lot of patients to be a successful doctor."