Re: ODBC connection to Informix SE server

Hi muchan Have you tried using Openlink ODBC drivers to connect to your Database. With these drivers, installation cannot be easier. You configure your informix- connect to show where your INFORMIXDIR and Server are installed, through a browser you can tell our broker where you have installed informix or any other database you want to use, start the broker, create a datasource or by whatever means you want to achieve connectivity and within minutes, you will have made a connection. You should give it a try. You can download a free evaluation free evaluation form www.openlink.co.uk or www.openlinksw.com and try our drivers for free. They are fast, have good security and easy to configure with good JDBC drivers and ODBC drivers as standard. Hope that solves your problem muchan <muchan@promikra.si> wrote in article <34C35439.5A37@promikra.si>... > 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 >