IDS Forum

Re: Remote connect to IDS fails

Posted By: Jack Parker
Date: Thursday, 7 July 2011, at 6:52 a.m.

In Response To: Remote connect to IDS fails (NEIL HAUGHTON)

Neil,

You have a port number in your connect statement, so this is probably =
not it, but your instance name looks like a default SHM connection, so =
I'll give it a whirl.

When local, you can connect via shared memory. When remote, you must =
connect over a net connection.

That net connection has three components which must align. %ONCONFIG%, =
sqlhosts file and /etc/services.

%ONCONFIG% is %INFORMIXDIR%\etc\%ONCONFIG%. Look for SERVERNAME or =
SERVERALIAS in there. the ol_mat is the one you have told your app to =
connect to.

sqlhosts (and this may have just changed in 11.7, I'd have to check). =
In the Registry under LOCALMACHINE/Software/Informix/... I forget ... / =
sqlhosts, there should be an entry for ol_mat which should call out a =
service.
If it is not in the registry, check %INFORMIXDIR%\etc\sqlhosts.

Finally /etc/services is hidden under =
%WINPATH%\System32\drivers\etc\services. In that you want the service =
name from the sqlhosts entry to line up with the port number you called =
out (9091) (for that matter, should you be calling out the service name =
rather than the port number?) Not a .Net guy.

You should be able to telnet to the port in question and get something =
unintelligible, but recognizable.

What we typically do is try to connect with the native Informix =
connection components to validate that the connectivity is allright. =
Download the CSDK to your WIndows 7 box.

Sorry to be so vague, it's been a while since I played in this =
particular sandbox.

j.

On Jul 7, 2011, at 5:37 AM, NEIL HAUGHTON wrote:

> Hello - IFX newbie here! I'm hoping someone can show me the way....=20
>=20
> I am porting a .Net application to work with Informix (IDS 11.7). I =
have an=20
> IDS server instance running on a WinXP machine, and on that machine I =
can=20
> connect from my application (ie application and server are on same =
machine). I=20
> also have a very simple .Net test app that makes, opens and then =
closes a=20
> connection, so there are no extraneous details that might confuse the =
issue.=20
>=20
> However when I try to run the test app on a remote Windows 7 64 bit =
machine, I=20
> cannot connect to the IDS server. By 'remote' I mean on the same =
subnet, in=20
> the same room in fact. I have the 32 bit Informix client tools =
installed on=20
> both machines, and I can compile the test app on the remote client so =
I know=20
> the Informix .Net provider is there and available.=20
>=20
> I have checked that the Windows Firewall is disabled on the server =
host. On=20
> the remote client machine the Windows 7 Firewall allows all outgoing =
traffic.=20
> I can ping both ways. I can also connect to a Sql Server database =
across the=20
> same route, so I know it is not a network issue per se.=20
>=20
> The connection string is the same in both cases, and in the connection =
string=20
> the host is explicit (host=3DDEVDW). In fact here is the test code =
itself:=20
>=20
> using (IDbConnection conn =3D new=20
> =
IfxConnection("Host=3DDEVDW;Password=3DmyPassWord;Server=3Dol_mat;Service=3D=
9091;User=20
> ID=3DmyUserName; Database=3DMATIFMXSYS"))=20
>=20
> {=20
>=20
> conn.Open();=20
>=20
> using (IDbCommand com =3D conn.CreateCommand())=20
>=20
> {=20
>=20
> com.CommandType =3D CommandType.Text;=20
>=20
> com.CommandText =3D "select usercode from users where usercode =3D =
'test'";=20
>=20
> string temp =3D (string)com.ExecuteScalar();=20
>=20
> }=20
>=20
> }=20
>=20
> What else should I be looking for?=20
>=20
> TIA=20
>=20
> Neil.=20
>=20
>=20
> =
**************************************************************************=
*****=20
> Forum Note: Use "Reply" to post a response in the discussion forum.=20=

>=20

Messages In This Thread

• Remote connect to IDS fails
  NEIL HAUGHTON -- Thursday, 7 July 2011, at 5:37 a.m.
  • Re: Remote connect to IDS fails
    Jack Parker -- Thursday, 7 July 2011, at 6:52 a.m.
    • Re: Remote connect to IDS fails
      NEIL HAUGHTON -- Thursday, 7 July 2011, at 8:00 a.m.
      • Re: Remote connect to IDS fails
        Jack Parker -- Thursday, 7 July 2011, at 8:06 a.m.
        • Re: Remote connect to IDS fails
          NEIL HAUGHTON -- Thursday, 7 July 2011, at 8:30 a.m.
          • Re: Remote connect to IDS fails
            Jack Parker -- Thursday, 7 July 2011, at 8:42 a.m.
          • Re: Remote connect to IDS fails
            Art Kagel -- Thursday, 7 July 2011, at 9:07 a.m.
            • Re: Remote connect to IDS fails
              NEIL HAUGHTON -- Thursday, 7 July 2011, at 9:22 a.m.
              • Re: Remote connect to IDS fails
                NEIL HAUGHTON -- Thursday, 7 July 2011, at 9:24 a.m.
              • Re: Remote connect to IDS fails
                Art Kagel -- Thursday, 7 July 2011, at 10:24 a.m.
                • Re: Remote connect to IDS fails
                  Alexandre Marini -- Thursday, 7 July 2011, at 10:34 a.m.
                  • RE: Remote connect to IDS fails
                    LARRY SORENSEN -- Thursday, 7 July 2011, at 10:52 a.m.
                    • Re: RE: Remote connect to IDS fails
                      NEIL HAUGHTON -- Friday, 8 July 2011, at 6:43 a.m.
                • Re: Remote connect to IDS fails
                  NEIL HAUGHTON -- Friday, 8 July 2011, at 6:44 a.m.
                  • Re: Remote connect to IDS fails
                    KEN KWAN -- Friday, 8 July 2011, at 1:33 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.