Re: ODBC connection to Informix SE server

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