Re: Problems with connect INFORMIX Online / INFORMIX CLI
Try setting on your client side instead of service name
the service number, i.e. instead of online_cli - 7600.
Hope this helps,
Octav
On Fri, Aug 13, 1999 at 11:57:09AM +0100, Heike Beck wrote:
> Hello,
>
> Our university works with the INFORMIX Dynamic server 7.30 (UNIX). We
> want to try a WIN NT/95-Client to the ODBC interface. The product used
> for this is INFORMIX-CLI 2.8 (from your webside). Client and server are
> at the same network. The error code seems general -908 (no connection to
>
> the data base server producing). What we make wrong or what is our
> problem? About help we would be very grateful.
>
> Yours sincerely
> H. Beck
>
> ----------------------------------------------------------------------------------------
>
> propetys on client and server side:
>
> Server:
> -------
> Host: Siemens RM 300/E20
> OS: Reliant UNIX-N 5.44 B0033 RM400 1/256 R4000 (Sinix)
>
> NAME: INFORMIX Dynamic Server
> CATEGORY: application.database
> ARCH: R4400
> VERSION: V7.30.UC3
>
> NAME: INFORMIX-Connect
> CATEGORY: application.database
> ARCH: R4400
> VERSION: V2.01.UC1
>
> Client:
> -------
>
> OS: Windows NT 4.0, Service Pack 4
> Microsoft ODBC Driver Manager 3.0.2822
> Informix Client SDK 2.01 through 2.1 for Microsoft Windows
> Environments and UNIX
> CLI: INFORMIX 2.80 32 BIT
> Setnet: Informix-ESQL 9.20 2.20 TC1
>
> ----------------------------------------------------------
> propertys:
>
> Server side:
> ------------
>
> Database: sospos
>
> </home/informix/etc> sqlhosts
> SNI_SV onipcshm SNI_SV online_on
> SNI_CLI onsoctcp SNI_SV online_cli>
>
> </home/informix/etc>onconfig
> DBSERVERNAME SNI_SV # Name of default database server
> DBSERVERALIASES SNI_CLI # List of alternate
> NETTYPE ipcshm,1,15,NET
> NETTYPE soctcp,1,15,CPU>
> </etc>services
> #for informix
> online_on 7500/tcp
> online_cli 7600/tcp
>
> </etc>hosts
> 141.46.29.70 SNI_SV
>
> -------------------------------------------------------------------
>
>
> Client side:
> ------------
>
> [Setnet32]
> Format= 9.20 2.20.TC1
> [ENVIRONMENT]
> CLIENT_LOCALE=de_de.8859-1
> DB_LOCALE=de_de.8859-1> DBANSIWARN=n
> DBLANG=de_de.8859-1
> DBMONEY=.
> DELIMIDENT=n
> INFORMIXDIR=C:\\INFORMIX
> INFORMIXSERVER=SNI_CLI> INFORMIXSQLHOSTS=
> LANG=de_de.8859-1
> [Size]
> CLIENT_LOCALE=12
> DB_LOCALE=12> NumOfHosts=2
> NumOfServers=2
> NumOfProtocols=9
> ServerSize=16
> HostSize=21
> ProtoSize=80
> [Lists]
> INFORMIXSERVERLIST=SNI_CLI> HostList=SNI_SV;
> PROTOCOLLIST=olsoctcp
> [__infx_sqlhost_SNI_CLI]
> HOST=SNI_SV
> SERVICE=online_cli
> PROTOCOL=onsoctcp
> OPTIONS=
> [__infx_sqlhost_SNI_SV]
> HOST=SNI_SV
> SERVICE=online_cli
> PROTOCOL=onsoctcp
> OPTIONS=
> [__infx_host_141.46.29.70]
> USER=sospos
> [__infx_host_SNI_SV]
> USER=sospos
>
> Informix-CLI DSN Setup:
> -----------------------
>
> Requiered Values:
> Data Source Name: pos
> Database: sospos
> Server: SNI_CLI
> Host: SNI_SV
> Service: online_cli
> Protocol: onsoctcp
>
> Optional Values:
> User ID: sospos
> Cursor Behavior: 1-Preserve
> Client Locale: de_de.8859-1
> Database Locale: de_de.8859-1
> VBM Character: Estimate
>
> Test with ILogin for Informix-Connect:
> -------------------------------------
>
> Server: SNI_CLI
> Host: SNI_SV
> Servicename: online_cli
> Protocolname: onsoctcp
> Username: sospos
> Stores Database: pos
>
> Error message: Database Sqlcode = -908
>
>
>
--
Octav Chiriac Phone: (373) 2 22 99 67
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 22 84 88
Moldova, Republic of mailto:com@netinfo-moldova.com