ODBC connection to Informix SE server
Posted in 1998
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