Syndicate

ODBC Connectivity Error from Informix DB to Dotnet

Submitted by karthik04 on Fri, 2009-12-18 16:04

Ask Spokey

Hi Spokey,

We have an issue while making an ODBC from IDS to Dotnet

IDS11.5 Installed in SLES10.2 BOX and Dotnet 2005 in windows

We are using the Client CSDK3.5

we are getting the error when connecting to Dotnet from windows machine

ERROR [HY000] [Informix .NET provider][Informix]System error occurred in network function.

When we try the ODBC the same error

[Informix][Informix ODBC Driver][Informix]System error occurred in network function

some of the connection setting we are using in windows

Servename - live
hostname - 192.168.1.196
service - live_tcp_services
protocol - onsoctcp

The below details belongs to the Linux Box

Onconig file
------------
DBSERVERNAME live
DBSERVERALIASES live_tc

NETTYPE ipcshm,1,50,CPU
NETTYPE soctcp,1,200,NET

SQLHOST FILE
------------
demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
live onipcshm linux-qat live_services
live_tcp onsoctcp linux-qat live_tcp_services

Linux host file
---------------
192.168.1.196 linux-qat.site linux-qat

Linux Service file
------------------
live_services 48623/tcp # Port IDS 11.5
live_tcp_services 48624/tcp # Port IDS 11.5

We also added the host & service entry in the windows/system32/drivers/etc

Could you please help on this issue.

Thanks
karthik

Ping?

Submitted by Spokey on Fri, 2009-12-18 17:06.

Hi,

First question is: can you ping from the PC to the SLES box? And back again? Any firewalls in place?

And do you have any error numbers?

Thanks now it is working issues is with the firewall

Submitted by karthik04 on Mon, 2009-12-21 14:35.

Thanks Spokey ,

Now iam able to make an connection From linux to windows (both ODBC & .net connectivty)

The problem is firewall is enabled in the Linux machine, i have turned off the firewall now it is working fine

But one more thing Even though my firewall is enabled my ping is working fine from both the ends,but i didnt get any error numbers

Any how now it is working

Thanks
Karthik

Ping is working because the

Submitted by Spokey on Thu, 2009-12-31 01:27.

Ping is working because the firewall lets it through. The firewall won't let SQLI through by default, though, you need to open the ports for that to happen.