Windows ODBC Client setup

[tasminracer]

Hi,
has anyone had any success with setting up the odbc drivers.


im sure i've set the server up fine.

entries in sqlhosts and services plus a server alias and a reboot for good measure.

on the PC ( win xp pro) i've installed the odbc drivers from the SDK

added the entry to windows\system32\drivers\etc\services

got the Host name resolving ok.

but when i use the dbping utility and try to do the I-connect test i get the -931 error which is can not locate service name.. but the blinking thing is in the services file!!! arghh im sure its the pc end as its not yet talking to the server

any help would stop me going insane

ta

Graham

 

[bgfarmer]

Do you have the entry in the /etc/services file on the system? Check sqlhosts against it

 

[tasminracer]

yep entires in /etc/services that matches sql hosts and an entry in services on teh pc.

I can get it to work if i put the port number rather than the service name in the odbc driver. so it looks like the problem is with the pc.

I wonder if its like lmhosts where you have to process the file rather than hosts where you simply list the addresses


cheers G

 

[ladwig]

Hi,
what system do you use for the Informix server. If it is a Windows Server you habe to build up the sqlhosts in the registry, Unix in dir /informix.

 

[breizhti]

Did you use setnet32 to setup the client configuration ?

 

[2ITLTD]

I wish someone could add somemore info to this thread, as I am experiencing the same problem. i.e -931. I have setup a Windows PC as my Informix DB and now want to connect to it via an ODBC Client. but keep getting errors. Why is it so difficult to set this thing up?? Can anyone help further?

 

[appi]

Hi,

For an real Windows Environment (DB and Client) you can configure and test the connection via setnet32. If there is any problem pls post the error message.
Pleas make sure that you've installed the best ODBC Driver from Informix Client SDK (CSDK for your environment).
Which of these components have you installed yet ?
Informix DB (Version, OS), CSDK (Version, OS) ?

regards
Uwe

 

[2ITLTD]

Just to say I got it working by using the info provided in by -

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/32/pid/876/qid/409375

Just added the turbo1 service into my services file and hey presto, with a bit of fiddling with the host name/service and db name I got it working, thanks to all concerned.