Tun ODBC driver

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing

Gerhard David — Tue, 12 Oct 1999 15:58:25 +0000 — source: Informix-list mailing list archive (1991-1998)

Hi! I'm trying to access an Informix 5-Database (on SCO-Unix) from an Excel97-Add In (on Window 95) via ODBC (Tun ODBC-Driver by Esker). I can connect to the DB with Set Con = WSpace.OpenConnection("odbcsrc", dbDriverComplete, _ True, "ODBC;UID=user;PWD=passwd;DSN=odbcsrc") Up to this point there seems to be no error. But when I try to open a Recordset using Set Rec = Connect.OpenRecordset("select count(*) from a_table", _ dbOpenSnapshot) an exception occurs and the following message is written into the log file: EXCEL ffcf17f3:fff21463 ENTER SQLSetStmtOption HSTMT 0x01901880 UWORD 6 UDWORD 3 EXCEL ffcf17f3:fff21463 EXIT SQLSetStmtOption with return code -1 (SQL_ERROR) HSTMT 0x01901880 UWORD 6 UDWORD 3 (...) WCHAR * 0x0062eaf0 [ 88] "[Esker][TUNODB32.DLL] Optionswerte ver'ndert" ( = "[Esker][TUNODB32.DLL] Option values changed") The question is: What is SQLSetStmtOption supposed to do? What could be a possible reason for not doing it? Did anyone ever solve this problem? My configuration is: Client: Server: ------- ------- Windows 95 SCO-Unix 5.05 Excel 97 Informix 5.03 TunPLUS 8.6 Database lab data source: - CONNECT to lab and Name - odbcrsrc SELECT on all required tables Hostname - labhst allowed for 'user' Datenbank - lab tunodbc200.ifx (part of TunPLUS 8.6) Username - user User 'user' exists Passwort - passwd Password is passwd Tun32 Driver 2.00.0500 (TUNODB32".DLL, 06.03.98, part of TunPLUS 8.6) Thanks in advance for Your help! Gerhard