Re: Informix - Powerbuilder connectivity
Jasper Rajesh wrote:
> Hi everyone
>
> I'm trying to connect PB to informix 5.x server using
> INET 7.x. I got the ILOGIN demo working properly but 'm
> getting an error when I set up the database profile in PB.
> My connection Parameters:
> DBMS: IN7 I-Net v7.x
> UserId: XXXXX
> Database Name: DBNAME
> ServerName: hostname@omp
> where omp is the informix server name.
> I get this error saying "SQL Error -931: Cannot locate omp
> service/tcp service in /etc/services. has occurred. ISAM error
> 11004: Unknown error message 11004.">
Sometimes, an error message is so clear, it's not apparent (chew on that
one). AnywayGo to your system32 directory (or just system directory, if
windows 95) in the windows directory. Go to directory called drivers,
then directory called etc. Look for a file called services. The file has
lines like these
-------
# Copyright (c) 1993-1995 Microsoft Corp.
#
# This file contains port numbers for well-known services as defined by
# RFC 1060 (Assigned Numbers).
#
# Format:
#
# <service name> <port number>/<protocol> [aliases...] [#<comment>]
#
# this is not the entire services file.. I truncated it somewhat for
this posting...
poker 10002/tcp
rscs2 10002/udp
gateway 10003/tcp
rscs3 10003/udp
remp 10004/tcp
rscs4 10004/udp
rscs5 10005/udp
rscs6 10006/udp
rscs7 10007/udp
rscs8 10008/udp
rscs9 10009/udp
rscsa 10010/udp
rscsb 10011/udp
qmaster 10012/tcp
qmaster 10012/udp
sqlexec 1525/tcp # something to do with
informix.. added manually
turbo 1526/tcp # INFORMIX-OnLine Workgroup
Server
srv_agent 1530/tcp # INFORMIX-OnLine Server
Agent
Notice that turbo (which is defined in setnet32, or setnet) under the
"Server Information" tab as the service name has port number 1526,
protocol tcp.Your service name may be srv_agent or whatever the DBA
chooses it to be. Whatever, usually the service name is given port 1526.
You also need sqlexec as 1525, protocol tcp. (this is whatever the
protocol you set up in either setnet32 or setnet). To find out, see what
the protocolname is under the "Server information" tab. Have fun guy!!.
Please send any queries or questions to wesley_nurse@mail.amsinc.com.
> --
> ,,,
> (o o)
> -----------------------------------------------------------ooO-(_)-
> oo--
> Jasper Rajesh
> (910) 279-3646
> jrajesh@lucent.com
> ------------------
> -----------------------------------------------------