Problem with connect to Informix-SE through ODBC
Posted in 1999
hi again, (2nt try) my problem is to connect to Informix-SE 7.22.UC1 on HPUX 10.20 from Win-NT Workstation with Informix Connect 2.80 32 Bit. I configured the HP like the insructions from IIUG. ------- Entry in sqlhosts: seppip seipcpip hppps sqlexec seppso sesoctcp hppps se2 Entry in /etc/services: se2 1536/tcp # Zugriff auf Informix-SE --------- And then start the sqlexecd with log-option. Entry in sqlexecd-logfile: 1999-02-08 10:54:58.751726 Starting Daemon INFORMIX-SQL Version 7.22.UC1 Command Line = /usr/informix/lib/sqlexecd seppso -l /tmp/informixodbc.log INFORMIXDIR = /usr/informix dbservername = seppso nettype = sesoctcp hostname = hppps servicename = se2 options = 1999-02-08 10:56:17.146371 sqlexec niemeier niemeier -p(null) --- (created at connectiontest with ILogin-Demo program) ... 1999-02-08 11:37:34.684962 sqlexec niemeier niemeier -dentw --- ( 2. Case) ... 1999-02-08 11:55:39.476288 sqlexec niemeier niemeier -d/projects/seppentw/entw --- ( 3. Case) ---------------- The problem arise on client. The CLI creates an errormessage : 2. Case: Database not found or no system permission 3. Case: Syntax disallowed in this database. -- SQLSetConnectAttr.-- Environment (Entries to connect in CLI): Server : seppso Host : hppps Service : se2 Protocol : sesoctcp Database (2.Case) : entw (3.Case) : /projects/seppentw/entw The 3. Case provided the rwx rights for other at the directory and a .rhosts-file in the home-directory. I think there are some security or access-rights problems. But which ? And how to solve ? regards Dirk Niemeier