Port number for ODBC connections

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mac - 25 Oct 2006 02:38 GMT

Hi all,

I have a situation where someone external to our network needs to access one
of our Ingres databases through an ODBC connection.

We only want to make the relevant port available through our firewall, but I
don't know what it is. Can anyone tell me what port number Ingres would use
for external ODBC connections?

FYI, we are running Ingres 2006 on Linux.

regards,

Mac

Reply to this Message

Mac - 25 Oct 2006 03:06 GMT

I may have found it.

Is it the value of the II_GCNxx_PORT parameter for the relevant Ingres
installation?

>Hi all,
>
[quoted text clipped - 10 lines]
>
>Mac

Reply to this Message

Mac - 25 Oct 2006 03:25 GMT

Or is it the ii.xxxxxx.registry.tcp_ip.port parameter in the config.dat file?

>I may have found it.
>
[quoted text clipped - 6 lines]
>>
>>Mac

Reply to this Message

John Dennis - 25 Oct 2006 07:19 GMT

The port you need to open is the server's GCC port number, which is
derived from the 2-character installation code. You can find it in the
errlog.log where the GCC starts up - look for a message like this:
E_GC2815_NTWK_OPEN Network open complete for protocol WINTCP, port II
(21064).
and there's the port number.

John

> Or is it the ii.xxxxxx.registry.tcp_ip.port parameter in the config.dat file?
>
> >I may have found it.
>
> >Is it the value of the II_GCNxx_PORT parameter for the relevant Ingres
> >installation?

Reply to this Message

Gerhard Hofmann - 25 Oct 2006 07:51 GMT

> Hi all,
>
[quoted text clipped - 6 lines]
>
> FYI, we are running Ingres 2006 on Linux.

From a Windows client, run
isql your_linux_server::your_db
to connect to the database.

Open another command window and run netstat to see the open connections.
If your Ingres 2006 installation was done with default values, the
IngresNet port will be 21064. I think this port number also is shown in
$II_SYSTEM/ingres/files/errlog.log when Ingres is started on the server.

HTH
Gerhard

Reply to this Message