×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ODBC Configuration!

ODBC Configuration!

ODBC Configuration!

(OP)
We are using INFORMIX dynamic server 7.31 and HP-UX 10.20. The telnet and ftp connection between PC (Windows 98 II Edition) and UNIX serve is working fine. We are trying to access the database on HP-D/370 from PC using ODBC. I have set the evironment parameters (INFORMIXDIR,PATH) & made entries in services & hosts file on PC. And also created user DSN using INTERSOLV 3.01 32-BIT INFORMIX & also tried with INFORMIX 2.80 32 BIT. The Protocol which is defined is onsoctcp. But it is not working.
When we try to check connectivity with ILogin Demo it is giving the following error.
Database: Sqlcode = -930 Refer to Informix Find Error Utility or manual.
 
The Informix Finderror says "Cannot Connect to Database Server Servername". The possible solution given is to check whether network is operational or server is active or not.
 
The server name, service protocol,host name & IP address all are O.K. I would like to know what I am missing.
 
And I also I would like to know how the Informix communicates with the client. i.e mode & method.
 
Thanking advance for the reply,
 
G.R.P.

RE: ODBC Configuration!

Hi,
Try putting the following in the  options of setnet32 utility.
sa=2
once again verify that the server name and service. Let me know if this does not solve the problem
Regards
Partha

RE: ODBC Configuration!

(OP)
Dear Partha,

Thanks for your Suggestion. My problem is solved. It was a very silly problem. My Configuartion parameter everything was O.K. The only thing which we need to take care is the entries in hosts file should start from the begining of the line. There was a space which was creating problem. Another thinig is after the last entry in hosts file we should press enter and make blank line.

GRP

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close