Dbaccess Error : 25572: Network driver cannot bind a name to the port.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sudhir Sambrani - 28 Jun 2004 16:30 GMT

Hi All

I am using IDS 9.2 on a solaris box

I get this error when i use dbaccess

25572: Network driver cannot bind a name to the port.

anybody know why i am getting this error

the entries in my sqlhosts file seem ok

sqlhosts file
#####################################
test_3 ontlitcp test_3 on_test_3

services file
######################################
on_test_3 1545/tcp

hosts file
######################################
ip_address hostname test_3 loghost

is there any other utility other than dbaccess
where we cud run queries

Thanks
Sudhir
sending to informix-list

Reply to this Message

Fernando Nunes - 28 Jun 2004 18:09 GMT

> Hi All
>
[quoted text clipped - 26 lines]
> Sudhir
> sending to informix-list

Is it a new system?
Are you on Solaris 2.8?

If you migrated the OS to 2.8 please contact IBM technical support.
There was an issue with some versions of IBM Informix products on
Solaris 2.8 due to some changes in the TCP stack.

I don't recall the exact details, but I think it gave an error similar
to this. If possible try other connections like shared memory.

Regards.

Reply to this Message

TBP - 28 Jun 2004 19:17 GMT

>> Hi All
>>
[quoted text clipped - 36 lines]
>
> Regards.

I would check your /etc/hosts file format, it usually looks something like :

127.0.0.1 localhost
192.168.0.5 ahost ahostalias

Reply to this Message

Tsutomu Ogiwara - 29 Jun 2004 08:40 GMT

Hi Sudhir.

If you use < 7.31.UD1, you encountered as bellow.
124759 ON SOLARIS 8, SERVER FAILS TO BUILD SYSMASTER BECAUSE BUILDSMI
CONNECT TO DATABASE FAILS WITH ERROR 25572 WITH "EXEC FORMAT ERROR" USING
TLITCP

To solve this, upgrade > 7.31.UD1.

7.31.UD7 is current version.

HTH.

--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592

>From: Sudhir Sambrani <sudhirsambrani@gmail.com>
>To: informix-list@iiug.org
[quoted text clipped - 32 lines]
>Sudhir
>sending to informix-list

_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

sending to informix-list

Reply to this Message

Brice Avila - 29 Jun 2004 14:44 GMT

Sudhir,

Try using a different port in the /etc/services file:

services file
######################################
# on_test_3 1545/tcp
on_test_3 1546/tcp

If this works, then port 1545 is probably unusable until the next
reboot. A reboot frees all bound ports; There is probably another way
of doing this without a reboot, but I'm not that good of a systems
administrator.

You can use isql, i4gl, and esqlc to run sql queries instead of
dbaccess. I believe that some other 3rd-party products also allow sql
queries to run against the instance.

Hope this information helps.

Brice Avila
Minneapolis, Minnesota

> Hi All
>
[quoted text clipped - 26 lines]
> Sudhir
> sending to informix-list

Reply to this Message