Exception: System resource exceeded, ODBC, MS ACCESS

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jag <Jag@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 6 May 2005 02:56:03 -0700

The problem is about exception " system resource exceeded".
Program uses VC++ and Access database.
I get the above exception while generating the database. It means writing
the data into database.
Only on some machines the above exception occurs(randomly, not
consistently). Not on all machines.
I don't have problems on many machines. The database is generated well. Even
on the machines which it gives problem, If I leave the machine for 2 min
after opening the disk file before generating database it generates very well.

So I generated a log file using ODBC tracing on ODBC driver. I am giving you
both the log file parts of line. Please use them to compare to get an idea.
Look for '=======' dividers.
Find the lines below from logfile when successfully generated the database.
=============
Visflow 610-4d0 EXIT SQLExtendedFetch with return code 100
(SQL_NO_DATA_FOUND)
HSTMT 073F3CF8
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0653F1F4
UWORD * 0x2C0CA828

Visflow 610-4d0 ENTER SQLSetConnectOption
HDBC 073F4810
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

Visflow 610-4d0 EXIT SQLSetConnectOption with return code -1
(SQL_ERROR)
HDBC 073F4810
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

DIAG [S1011] [Microsoft][ODBC Microsoft Access Driver]Attribute
cannot be set now (72)

Visflow 610-4d0 ENTER SQLSetPos
HSTMT 073F84B0
SQLSETPOSIROW SQLSETPOSIROW UWORD
4 <SQL_ADD>
BOOL 0 <SQL_LOCK_NO_CHANGE>

Visflow 610-4d0 EXIT SQLSetPos with return code 0 (SQL_SUCCESS)
HSTMT 073F84B0
SQLSETPOSIROW SQLSETPOSIROW UWORD
4 <SQL_ADD>
BOOL 0 <SQL_LOCK_NO_CHANGE>

Visflow 610-4d0 ENTER SQLTransact
HENV 073F9030
HDBC 073F4810
UWORD 0 <SQL_COMMIT>

Visflow 610-4d0 EXIT SQLTransact with return code 0
(SQL_SUCCESS)
HENV 073F9030
HDBC 073F4810
UWORD 0 <SQL_COMMIT>

Visflow 610-4d0 ENTER SQLSetConnectOption
HDBC 073F4810
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000001

Visflow 610-4d0 EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
HDBC 073F4810
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000001 (BADMEM)

Visflow 610-4d0 ENTER SQLFreeStmt
HSTMT 073F84B0
UWORD 1 <SQL_DROP>

Visflow 610-4d0 EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 073F84B0
UWORD 1 <SQL_DROP>

Visflow 610-4d0 ENTER SQLSetConnectOption
HDBC 073F4810
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

Visflow 610-4d0 EXIT SQLSetConnectOption with return code -1
(SQL_ERROR)
HDBC 073F4810
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

DIAG [S1011] [Microsoft][ODBC Microsoft Access Driver]Attribute
cannot be set now (72)

Visflow 610-4d0 ENTER SQLSetPos
HSTMT 073F3050
SQLSETPOSIROW SQLSETPOSIROW UWORD
4 <SQL_ADD>
BOOL 0 <SQL_LOCK_NO_CHANGE>

Visflow 610-4d0 EXIT SQLSetPos with return code 0 (SQL_SUCCESS)
HSTMT 073F3050
SQLSETPOSIROW SQLSETPOSIROW UWORD
4 <SQL_ADD>
BOOL 0 <SQL_LOCK_NO_CHANGE>

Visflow 610-4d0 ENTER SQLTransact
HENV 073F9030
HDBC 073F4810
UWORD 0 <SQL_COMMIT>

Visflow 610-4d0 EXIT SQLTransact with return code 0
(SQL_SUCCESS)
HENV 073F9030
HDBC 073F4810
UWORD 0 <SQL_COMMIT>
=============

Find the lines below from logfile when not sucessful, exception occured.

============
Visflow 740-6a4 EXIT SQLExtendedFetch with return code 100
(SQL_NO_DATA_FOUND)
HSTMT 073F58E8
UWORD 1 <SQL_FETCH_NEXT>
SQLLEN 1
SQLULEN * 0x0653F1F4
UWORD * 0x2C0D4EA8

Visflow 740-6a4 ENTER SQLSetConnectOption
HDBC 073F15E8
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

Visflow 740-6a4 EXIT SQLSetConnectOption with return code -1
(SQL_ERROR)
HDBC 073F15E8
SQLINTEGER 102 <SQL_AUTOCOMMIT>
SQLPOINTER 0x00000000

DIAG [S1011] [Microsoft][ODBC Microsoft Access Driver]Attribute
cannot be set now (72)

Visflow 740-6a4 ENTER SQLSetPos
HSTMT 073F32F0
SQLSETPOSIROW SQLSETPOSIROW UWORD
4 <SQL_ADD>
BOOL 0 <SQL_LOCK_NO_CHANGE>

Visflow 740-6a4 EXIT SQLSetPos with return code -1 (SQL_ERROR)
HSTMT 073F32F0
SQLSETPOSIROW SQLSETPOSIROW UWORD
4 <SQL_ADD>
BOOL 0 <SQL_LOCK_NO_CHANGE>

DIAG [S1001] [Microsoft][ODBC Microsoft Access Driver] System
resource exceeded. (-1011)

Visflow 740-6a4 ENTER SQLErrorW
HENV 073F1540
HDBC 073F15E8
HSTMT 073F32F0
WCHAR * 0x0653D03C (NYI)
SDWORD * 0x0653D2C8
WCHAR * 0x0653CC3C
SWORD 511
SWORD * 0x0653D2D2

Visflow 740-6a4 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 073F1540
HDBC 073F15E8
HSTMT 073F32F0
WCHAR * 0x0653D03C (NYI)
SDWORD * 0x0653D2C8 (-1011)
WCHAR * 0x0653CC3C [ 67] "[Microsoft][ODBC
Microsoft Access"
SWORD 511
SWORD * 0x0653D2D2 (67)

Visflow 740-6a4 ENTER SQLErrorW
HENV 073F1540
HDBC 073F15E8
HSTMT 073F32F0
WCHAR * 0x0653D03C (NYI)
SDWORD * 0x0653D2C8
WCHAR * 0x0653CC3C
SWORD 511
SWORD * 0x0653D2D2

Visflow 740-6a4 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
HENV 073F1540
HDBC 073F15E8
HSTMT 073F32F0
WCHAR * 0x0653D03C (NYI)
SDWORD * 0x0653D2C8
WCHAR * 0x0653CC3C
SWORD 511
SWORD * 0x0653D2D2

Visflow 740-6a4 ENTER SQLFreeStmt
HSTMT 073F8B88
UWORD 1 <SQL_DROP>

Visflow 740-6a4 EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 073F8B88
UWORD 1 <SQL_DROP>

Visflow 740-6a4 ENTER SQLFreeStmt
HSTMT 073F8750
UWORD 1 <SQL_DROP>

Visflow 740-6a4 EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 073F8750
UWORD 1 <SQL_DROP>

Visflow 740-6a4 ENTER SQLFreeStmt
HSTMT 073F8318
UWORD 1 <SQL_DROP>

Visflow 740-6a4 EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 073F8318
UWORD 1 <SQL_DROP>

Visflow 740-6a4 ENTER SQLFreeStmt
HSTMT 073F7EE0
UWORD 1 <SQL_DROP>

Visflow 740-6a4 EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 073F7EE0
UWORD 1 <SQL_DROP>

Visflow 740-6a4 ENTER SQLFreeStmt
HSTMT 073F7AA8
UWORD 1 <SQL_DROP>

Visflow 740-6a4 EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
HSTMT 073F7AA8
UWORD 1 <SQL_DROP>

============
.

Prev by Date: RE: ERROR [Informix]Cannot open file 'csql.iem'
Next by Date: Get list of available ODBC DSN
Previous by thread: ERROR [Informix]Cannot open file 'csql.iem'
Next by thread: Get list of available ODBC DSN
Index(es):
- Date
- Thread

Relevant Pages

Performance optimization vs satisficing (was Language Oriented Programming)
... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
(comp.object)
Re: Large Database System
... add database capabilities to the data files that are being processed. ... Because of the sheer number of machines involved in computations we ... Reliability is always an issue. ... You do know that SQLite is a single user database? ...
(comp.lang.c)
Re: Problem with Standard Functions
... Are they all sharing the same database, Mark? ... Doug Steele, Microsoft Access MVP ... > As the machines acted up I removed library references which initially ...
(microsoft.public.access.formscoding)
Re: Database Split and Linked Table
... Take a look at the Auto FE Updater Tony Toews has at ... The FE is used by several machines in different ... "Jerry Whittle" wrote: ... database not a copy in their machines. ...
(microsoft.public.access.setupconfig)
VM in 2.6 doing a worse job of caching than 2.4?
... day by a proprietary database system. ... I recently started evaluating the 2.6 kernel for these machines. ... and see's CPU idle of 30-35%. ... Theoretically, they both should receive similar traffic, though the load ...
(comp.os.linux.development.system)