Problems with WATCOM SQL 4.0

Problems with WATCOM SQL 4.0

Post by Phil Wils » Mon, 03 Apr 1995 05:00:00

Has anyone successfully used Watcom SQL 4.0 with Microsoft VC++ 1.5?
When using the AppWizard to enable database options, it never finds
any tables! The sql.log file shows a call to SqlError() so I assume an
error was returned from the ODBC driver, but have no clue what it is.
Watcom support has not been able to find the problem either. Here is
the sql.log file:

SQLAllocConnect(henv0B6F0000, phdbc4F6F0000);
SQLSetConnectOption(hdbc4F6F0000, 103, 0000001E);
SQLSetConnectOption(hdbc4F6F0000, 110, 00000001);
SQLDriverConnect(hdbc4F6F0000, hwnd83E0, "(null)", -3, szConnStrOut,
512, pcbCon
SQLGetInfo(hdbc4F6F0000, 9, rgbInfoValue, 2, pcbInfoValue);
SQLGetInfo(hdbc4F6F0000, 15, rgbInfoValue, 2, pcbInfoValue);
SQLGetInfo(hdbc4F6F0000, 23, rgbInfoValue, 2, pcbInfoValue);
SQLGetInfo(hdbc4F6F0000, 24, rgbInfoValue, 2, pcbInfoValue);
SQLGetInfo(hdbc4F6F0000, 25, rgbInfoValue, 10, pcbInfoValue);
SQLGetInfo(hdbc4F6F0000, 29, rgbInfoValue, 2, pcbInfoValue);
SQLGetInfo(hdbc4F6F0000, 6, rgbInfoValue, 32, pcbInfoValue);
SQLGetInfo(hdbc4F6F0000, 2, rgbInfoValue, 256, pcbInfoValue);
SQLAllocStmt(hdbc4F6F0000, phstmt4F570000);
SQLSetStmtOption(hstmt4F570000, 0, 0000000F);
SQLSetStmtOption(hstmt4F570000, 4, 00000001);
SQLGetFunctions(hdbc4F6F0000, 59, pfExists);
SQLGetInfo(hdbc4F6F0000, 44, rgbInfoValue, 4, pcbInfoValue);
SQLError(henv0B6F0000, hdbc4F6F0000, hstmt4F570000, szSqlState,
pfNativeError, s
SQLError(henv0B6F0000, hdbc4F6F0000, hstmt4F570000, szSqlState,
pfNativeError, s
SQLFreeStmt(hstmt4F570000, 1);


1. Update problem using Watcom 4.0/SQL Anywhere

I have a problem in my database application.

The program makes a selection out of some criteria and assign this to
a cursor. This cursor is used to browse forward and backward in the
selection. The problem is when I perform an insert/update/delete on
one of the records in the current selection. Then I have to reopen the
cursor to se the hanges.

I have tried using unique indexes in "ORDER BY", but this wont help if
the optimizer uses a temporary table. I have also tried to use positioned
updates "UPDATE CURRENT OF" but that doesn't do it either.

Does anyone have an answer for me?

I use ODBC to interface with the SQL Anywhere database.

Anders Omdal.

2. Duplicate Sequence Values ?

3. 1 * jECuQNqtx-Migration of Watcom 4.0 to SQL 6.5

4. help w/ VB5 & sql 6.5 app

5. Migration of Watcom 4.0 to SQL 6.5

6. help:svrmgrl/internal won't start db

7. HELP: Dynamic Memory Exhausted using Watcom SQL 4.0

8. 19297-NY-SYRACUSE-ORACLE-Designer 2000-Developer 2000-DBA Skills-Oracle Developer/DBA

9. Watcom SQL 4.0

10. VB & Watcom SQL 4.0

11. Watcom SQL 4.0 and Delphi 2.0 & ODBC

12. HELP.....Attaching to Watcom SQL 4.0

13. Watcom SQL 4.0 - Preprocessing for 32 bit.