Informix and ODBC

Informix and ODBC

I have an Informix database on a remote server and I’m trying to perform ODBC from my client machine. I have installed the client products on my Windows 98 machine and am trying to link through now using setnet32, but I keep getting various error messages. Why is that?

You’re doing the right things. First, get the Informix native connection running properly. This is done with setnet32 and ilogin. Try to ping the target machine using an IP address: e.g., ping

If you get a good ping, try to ping using the name of the machine: e.g., ping myserver.If this doesn’t work, you have a problem with your hosts file. Either fix it or just enter the IP address in the setnet32 (actually, this is a little faster, because Informix won’t have to look up an IP address). Once you can ping the machine, use setnet32 to set up the connection. Be sure to use both the SERVER and HOST tabs and fill out everything.

You can use the same number trick in entering the service. If you have a “turbo” or other-named service set up in your services file, you could either enter turbo as the service or XXXX (Xs being the number of the port for the service; it defaults to 1526). Also, go into the ENVIRONMENT tab and make sure that you’ve set the INFORMIXDIR parameter.

If you’re getting error messages that refer to trust problems, you may need to make entries in the target machine’s hosts.equiv file. This is usually in the same directory as the hosts file. If you just enter + +, it will make all systems in your network trusted.

When you’ve got the setnet32 set up, try using ilogin to connect. At first, just take the defaults and try to connect using the defaults that were set up by setnet32. If that doesn’t work, fill in all the items in the form and try to connect. If this works, but the defaults don’t, you’ve got a setnet32 problem. Use finderr –XXX, where XXX is the error statement that you’re getting. Finderr will give you an idea what the error messages mean.

If this doesn’t work, post back here on DevX with your specific error messages and I’ll try to walk you through it.

Share the Post:
XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

data fivetran pricing

Fivetran Pricing Explained

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

kubernetes logging

Kubernetes Logging: What You Need to Know

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes

ransomware cyber attack

Why Is Ransomware Such a Major Threat?

One of the most significant cyber threats faced by modern organizations is a ransomware attack. Ransomware attacks have grown in both sophistication and frequency over the past few years, forcing

data dictionary

Tools You Need to Make a Data Dictionary

Data dictionaries are crucial for organizations of all sizes that deal with large amounts of data. they are centralized repositories of all the data in organizations, including metadata such as