Oninit cdi / Archive
Talk to an expert →

Error:32-bit CLI ODBC and SE7.2 - connection error

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration, Internationalization & Character Sets

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

Hello, I get the folowing error when trying to connect to an informix database using the INFORMIX-CLI ODBC driver: Alias is not currently opened. [Informix][odbc Informix Driver][Informix]Attempt to connect to database server[inf] failed. Alias:kwgis What we make wrong or what is our problem? ------------------------------------------ propetys on client and server side: Server : os : redhat Rinux 5.2 name : Informxi SE 7.2 hostname : kwgis1 Client: os : Windows 95 CLI : Informix 2.80 32 BIT propertys: Server side: ----------- </home/informix/etc/sqlhosts> inf sesoctcp kwgis1 sqlexecd </etc/services> #for informix linuxconf 98/tcp sqlexecd 1536/tcp </etc/hosts> 210.183.31.181 kwgis1 Client side: <INFORMIX-CLI DSN Setup> Data Source Name : kangtest Database : stores7 Server : inf Host : kwgis1 Services : sqlexec Protocel : onsoctcp User ID : informix Passwd : ********** Cursor Behavior : 0 - Close Client Locale : ko_kr.ksc Database Locale : ko_kr.ksc VMB Character : Estimate

↪ replying to kbs
LJT — — source: Informix-list mailing list archive (1991-1998)

Va voir la nouvelle version sur le site d'informix Go to see the new version on the informix's site. kbs a 'crit dans le message ... >Hello, > I get the folowing error when trying to connect to an informix > database using the INFORMIX-CLI ODBC driver: >Alias is not currently opened. >[Informix][odbc Informix Driver][Informix]Attempt to >connect to database server[inf] failed. >Alias:kwgis > >What we make wrong or what is our problem? > > >------------------------------------------ >propetys on client and server side: >Server : >os : redhat Rinux 5.2 >name : Informxi SE 7.2 >hostname : kwgis1 > >Client: >os : Windows 95 >CLI : Informix 2.80 32 BIT > >propertys: > >Server side: >----------- ></home/informix/etc/sqlhosts> > inf sesoctcp kwgis1 sqlexecd ></etc/services> > #for informix > linuxconf 98/tcp > sqlexecd 1536/tcp > </etc/hosts> > 210.183.31.181 kwgis1 > >Client side: ><INFORMIX-CLI DSN Setup> >Data Source Name : kangtest >Database : stores7 >Server : inf >Host : kwgis1 >Services : sqlexec >Protocel : onsoctcp > >User ID : informix >Passwd : ********** >Cursor Behavior : 0 - Close >Client Locale : ko_kr.ksc >Database Locale : ko_kr.ksc >VMB Character : Estimate > > > > > >

↪ replying to kbs
Total Software Solutions, Inc — — source: Informix-list mailing list archive (1991-1998)

Try changing the client side server from sqlexec to sqlexecd --Wayne kbs <kbsss@sbsmail.net> wrote in article <qUcw3.1082$T9.59067@news.bora.net>... > Hello, > I get the folowing error when trying to connect to an informix > database using the INFORMIX-CLI ODBC driver: > Alias is not currently opened. > [Informix][odbc Informix Driver][Informix]Attempt to > connect to database server[inf] failed. > Alias:kwgis > > What we make wrong or what is our problem? > > > ------------------------------------------ > propetys on client and server side: > Server : > os : redhat Rinux 5.2 > name : Informxi SE 7.2 > hostname : kwgis1 > > Client: > os : Windows 95 > CLI : Informix 2.80 32 BIT > > propertys: > > Server side: > ----------- > </home/informix/etc/sqlhosts> > inf sesoctcp kwgis1 sqlexecd > </etc/services> > #for informix > linuxconf 98/tcp > sqlexecd 1536/tcp > </etc/hosts> > 210.183.31.181 kwgis1 > > Client side: > <INFORMIX-CLI DSN Setup> > Data Source Name : kangtest > Database : stores7 > Server : inf > Host : kwgis1 > Services : sqlexec > Protocel : onsoctcp > > User ID : informix > Passwd : ********** > Cursor Behavior : 0 - Close > Client Locale : ko_kr.ksc > Database Locale : ko_kr.ksc > VMB Character : Estimate > > > > > > >

Glossary