Oninit cdi / Archive
Talk to an expert →

Problems with connect INFORMIX Online / INFORMIX CLI

Posted in 1999

Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration, Networking & sqlhosts Configuration, Internationalization & Character Sets

Heike Beck — — source: Informix-list mailing list archive (1991-1998)

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-1DBANSIWARN=n DBLANG=de_de.8859-1 DBMONEY=. DELIMIDENT=n INFORMIXDIR=C:\\INFORMIX INFORMIXSERVER=SNI_CLIINFORMIXSQLHOSTS= LANG=de_de.8859-1 [Size] CLIENT_LOCALE=12 DB_LOCALE=12NumOfHosts=2 NumOfServers=2 NumOfProtocols=9 ServerSize=16 HostSize=21 ProtoSize=80 [Lists] INFORMIXSERVERLIST=SNI_CLIHostList=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

↪ replying to Heike Beck
rshah_98@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Error -908 means -908 __________________________________________________________ Attempt to connect to database server (servername, conerr=connection- error-number, oserr=system-error-number) failed. The program or application is trying to access another database server but has failed. Note the server name in the current statement. Note also the connection error number and/or system error number that is shown in the message. The desired database server is unavailable, or the network is down or is congested. Ask your DBA and system administrator to verify that the server and network are operational. If the network is congested, use the environment variables INFORMIXCONTIME and INFORMIXCONRETRY to tune connection timing. See Chapter 4 in the Informix Guide to SQL: Reference for information on setting these environment variables. This message appears in Version 6.0 and later. -908 Attempt to connect to remote system failed. INFORMIX-STAR or INFORMIX-NET is trying to access another computer system but has failed. Note the site name in the current statement. Start your daemon with a log file, and check for operating-system errors in the log file. If this action is inconclusive, contact your system administrator, and ask for a check that the network is operational and that the particular site is active. This message appears in database servers prior to Version 6.0. let me know if it work for you Thanks Raj In article <37B3FA05.30FED445@htw-zittau.de>, Heike Beck <H.Beck@htw-zittau.de> 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 > > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

Glossary