Re: ODBC connection to Informix SE server

Allthough I never seen the color of an SE I will give it a shot (well I can only give you info about how it's on an Online). Well as far as I know you have a few ways to see what engines are available. 1)have you tried onstat - when the engine is off-line normally your severname should be stated in that line. 2)Try the onconfig file : check the DBSERVERNAME (ALIAS) onconfig file should be at :$INFORMIXDIR/etc/$ONCONFIG 3) Run dbaccess on your solaris and go to connection menu this will give you the list of engines configured in your sqlhosts Connect to your database from there 4) sqlhosts file should be at : $INFORMIXDIR/etc/sqlhosts I hope 4 U one of those methods work on an SE . Gaetan Maerten, EDS ( Bacob Account Belgium) Helmut Biesenbach <helmut@mfo.de> wrote in article <34C89EF3.3352AF29@mfo.de>... > muchan wrote: > > > We have problem making ODBC connection to Informix SE database. > > > > Client > > OS: Win95, WinNT 4.00 > > ODBC driver manager: ODBC32.dll 3.0.23.1 > > (from MS Visual C/C++ 5.00 CD) > > ODBC driver: IVINF709.dll ver 2.12.0000 > > (installed as Informix Cli 2.5 (32bit) > > from INFORMIX-Online Workgroup Server for NT CD) > > > > Server > > OS: Sun Solaris > > database: Informix SE (IFMXSE RELEASE 7.10) > > > > Connection: via TCP/IP (sesoctcp) > > Service: SQLEXEC 1525/tcp > > > > Client normally works when connected to Informix OnLine Server. > > Server normally works when connected from 16bit applications. > > (with ESQL/C 5.01 or NewEra 5.01) > > > > We made effort to troubleshoot ourselves, but could only reach to > > get Error Message No.-957, > > "Cannot create/access database on NFS mount". > > But here's nothing about NFS mount. > > > > Value for Server Name seems problematic. For Informix Online server, > > Server Name is explicitly defined, but not so for SE server. > > And where the location and content of sqlhosts file should be is > > also unclear in documentation. > > > > Any help and suggestions appreciated. > > > > muchan <muchan@promikra.si> ProMikra d.o.o. Ljubljana, Slovenia > > The only point, where I remember NFS being mentioned, says, that the SE > must not reside on an > NFS partition on the server. > The name for the SE should be something like hostname_se and must be > given identically at > startup for the sqlexecd on the server as well as in the ODBC setup. > > > -- > Helmut Biesenbach Tel.: +49/(0)7834/979-27 > Mathematisches Forschungsinstitut Oberwolfach Fax.: +49/(0)7834/979-55 > Lorenzenhof Email: helmut@mfo.de > D-77709 Oberwolfach-Walke > > > >