ODBC error S1000

From: Steve W (lsl_at_btconnect.com.no_spam)
Date: 02/20/04

Next message: Richard Abraham: "Dynamic SQL execute fails when called from C++"
Previous message: Dennis Gray: "Date conversions using ODBC for Access"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 20 Feb 2004 09:09:14 -0000

We have a global Word template that calls a VB6 COM dll. It uses an Access
97 database with some tables that are linked to SQL Server 2000.

Our client has upgraded some users to Office XP (some users on Win XP, some
on Win 2000). These users then intermittently get an ODBC error ('failed to
connect to SQL_DB' - where SQL_DB is the name of the Sql database). The
ODBC trace shows :
DIAG [S1000] [Microsoft][ODBC Driver Manager] General error: invalid
window handle (0)

For all users, this data access works the first time (the first time they
try it after opening Word). Then it varies - some users get the error the
second time they try, other users can do it 10 times before getting the
error.

The ODBC trace I get when I switch trace on is shown below.

Anyone got any ideas ?

TIA

Steve

WINWORD 924-a14 ENTER SQLAllocEnv
HENV * 0012C69C

WINWORD 924-a14 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x0012C69C ( 0x09d91540)

WINWORD 924-a14 ENTER SQLAllocConnect
HENV 09D91540
HDBC * 0012C6A0

WINWORD 924-a14 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 09D91540
HDBC * 0x0012C6A0 ( 0x09d915e8)

WINWORD 924-a14 ENTER SQLSetConnectOption
  HDBC 09D915E8
  SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
  SQLPOINTER 0x00000014

WINWORD 924-a14 EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
  HDBC 09D915E8
  SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
  SQLPOINTER 0x00000014 (BADMEM)

WINWORD 924-a14 ENTER SQLDriverConnectW
  HDBC 09D915E8
  HWND 00040120
  WCHAR * 0x09D57310 [ -3] "******\ 0"
  SWORD -3
  WCHAR * 0x09D57310
  SWORD 8
  SWORD * 0x00000000
  UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>

WINWORD 924-a14 EXIT SQLDriverConnectW with return code 1
(SQL_SUCCESS_WITH_INFO)
  HDBC 09D915E8
  HWND 00040120
  WCHAR * 0x09D57310 [ -3] "******\ 0"
  SWORD -3
  WCHAR * 0x09D57310
  SWORD 8
  SWORD * 0x00000000
  UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>

DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
database context to 'Engine_HA'. (5701)

DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
language setting to British. (5703)

WINWORD 924-a14 ENTER SQLGetInfoW
  HDBC 09D915E8
  UWORD 9 <SQL_ODBC_API_CONFORMANCE>
  PTR 0x0012C6A6
  SWORD 2
  SWORD * 0x0012C69E

WINWORD 924-a14 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
  HDBC 09D915E8
  UWORD 9 <SQL_ODBC_API_CONFORMANCE>
  PTR 0x0012C6A6 (2)
  SWORD 2
  SWORD * 0x0012C69E (2)

WINWORD 924-a14 ENTER SQLGetInfoW
  HDBC 09D915E8
  UWORD 6 <SQL_DRIVER_NAME>
  PTR 0x09D92498
  SWORD 200
  SWORD * 0x0012C6A6

WINWORD 924-a14 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
  HDBC 09D915E8
  UWORD 6 <SQL_DRIVER_NAME>
  PTR 0x09D92498 [ 24] "SQLSRV32.DLL"
  SWORD 200
  SWORD * 0x0012C6A6 (24)

WINWORD 924-a14 ENTER SQLGetInfoW
  HDBC 09D915E8
  UWORD 46 <SQL_TXN_CAPABLE>
  PTR 0x0012C610
  SWORD 2
  SWORD * 0x0012C4D2

WINWORD 924-a14 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
  HDBC 09D915E8
  UWORD 46 <SQL_TXN_CAPABLE>
  PTR 0x0012C610 (2)
  SWORD 2
  SWORD * 0x0012C4D2 (2)

WINWORD 924-a14 ENTER SQLGetInfoW
  HDBC 09D915E8
  UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
  PTR 0x04C2C040
  SWORD 2
  SWORD * 0x0012C4D2

WINWORD 924-a14 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
  HDBC 09D915E8
  UWORD 23 <SQL_CURSOR_COMMIT_BEHAVIOR>
  PTR 0x04C2C040 (1)
  SWORD 2
  SWORD * 0x0012C4D2 (2)

WINWORD 924-a14 ENTER SQLGetInfoW
  HDBC 09D915E8
  UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
  PTR 0x04C2C042
  SWORD 2
  SWORD * 0x0012C4D2

WINWORD 924-a14 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
  HDBC 09D915E8
  UWORD 24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
  PTR 0x04C2C042 (1)
  SWORD 2
  SWORD * 0x0012C4D2 (2)

WINWORD 924-a14 ENTER SQLGetInfoW
  HDBC 09D915E8
  UWORD 1 <SQL_ACTIVE_STATEMENTS>
  PTR 0x0012C614
  SWORD 2
  SWORD * 0x0012C60E

WINWORD 924-a14 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
  HDBC 09D915E8
  UWORD 1 <SQL_ACTIVE_STATEMENTS>
  PTR 0x0012C614 (1)
  SWORD 2
  SWORD * 0x0012C60E (2)

WINWORD 924-a14 ENTER SQLSetConnectOption
  HDBC 09D915E8
  SQLINTEGER 101 <SQL_ACCESS_MODE>
  SQLPOINTER 0x00000001

WINWORD 924-a14 EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
  HDBC 09D915E8
  SQLINTEGER 101 <SQL_ACCESS_MODE>
  SQLPOINTER 0x00000001 (BADMEM)

WINWORD 924-a14 ENTER SQLAllocStmt
HDBC 09D915E8
HSTMT * 0012C4D4

WINWORD 924-a14 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 09D915E8
HSTMT * 0x0012C4D4 ( 0x09d91c18)

WINWORD 924-a14 ENTER SQLGetStmtOption
  HSTMT 09D91C18
  UWORD 0
  PTR 0x0012C478

WINWORD 924-a14 EXIT SQLGetStmtOption with return code 0
(SQL_SUCCESS)
  HSTMT 09D91C18
  UWORD 0
  PTR 0x0012C478

WINWORD 924-a14 ENTER SQLSetStmtOption
  HSTMT 09D91C18
  UWORD 0 <SQL_QUERY_TIMEOUT>
  SQLPOINTER 0x0000003C

WINWORD 924-a14 EXIT SQLSetStmtOption with return code 0
(SQL_SUCCESS)
  HSTMT 09D91C18
  UWORD 0 <SQL_QUERY_TIMEOUT>
  SQLPOINTER 0x0000003C (BADMEM)

WINWORD 924-a14 ENTER SQLExecDirect
  HSTMT 09D91C18
  UCHAR * 0x04BA10F0 [ -3] "SELECT Config, nValue FROM
MSysConf\ 0"
  SDWORD -3

WINWORD 924-a14 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
  HSTMT 09D91C18
  UCHAR * 0x04BA10F0 [ -3] "SELECT Config, nValue FROM
MSysConf\ 0"
  SDWORD -3

DIAG [S0002] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name 'MSysConf'. (208)

WINWORD 924-a14 ENTER SQLErrorW
  HENV 09D91540
  HDBC 09D915E8
  HSTMT 09D91C18
  WCHAR * 0x0012C3E4 (NYI)
   SDWORD * 0x0012C454
  WCHAR * 0x0012BFE4
  SWORD 512
  SWORD * 0x0012C46A

WINWORD 924-a14 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
  HENV 09D91540
  HDBC 09D915E8
  HSTMT 09D91C18
  WCHAR * 0x0012C3E4 (NYI)
   SDWORD * 0x0012C454 (208)
  WCHAR * 0x0012BFE4 [ 78] "[Microsoft][ODBC SQL Server
Driver][SQL"
  SWORD 512
  SWORD * 0x0012C46A (78)

WINWORD 924-a14 ENTER SQLErrorW
  HENV 09D91540
  HDBC 09D915E8
  HSTMT 09D91C18
  WCHAR * 0x0012C3E4 (NYI)
   SDWORD * 0x0012C454
  WCHAR * 0x0012BFE4
  SWORD 512
  SWORD * 0x0012C46A

WINWORD 924-a14 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
  HENV 09D91540
  HDBC 09D915E8
  HSTMT 09D91C18
  WCHAR * 0x0012C3E4 (NYI)
   SDWORD * 0x0012C454
  WCHAR * 0x0012BFE4
  SWORD 512
  SWORD * 0x0012C46A

WINWORD 924-a14 ENTER SQLFreeStmt
HSTMT 09D91C18
UWORD 1 <SQL_DROP>

WINWORD 924-a14 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 09D91C18
UWORD 1 <SQL_DROP>

WINWORD 924-a14 ENTER SQLAllocStmt
HDBC 09D915E8
HSTMT * 38000C24

WINWORD 924-a14 EXIT SQLAllocStmt with return code 0 (SQL_SUCCESS)
HDBC 09D915E8
HSTMT * 0x38000C24 ( 0x09d91c18)

WINWORD 924-a14 ENTER SQLGetStmtOption
  HSTMT 09D91C18
  UWORD 0
  PTR 0x0012C880

WINWORD 924-a14 EXIT SQLGetStmtOption with return code 0
(SQL_SUCCESS)
  HSTMT 09D91C18
  UWORD 0
  PTR 0x0012C880

WINWORD 924-a14 ENTER SQLSetStmtOption
  HSTMT 09D91C18
  UWORD 0 <SQL_QUERY_TIMEOUT>
  SQLPOINTER 0x0000003C

WINWORD 924-a14 EXIT SQLSetStmtOption with return code 0
(SQL_SUCCESS)
  HSTMT 09D91C18
  UWORD 0 <SQL_QUERY_TIMEOUT>
  SQLPOINTER 0x0000003C (BADMEM)

WINWORD 924-a14 ENTER SQLExecDirect
  HSTMT 09D91C18
  UCHAR * 0x38000D08 [ -3] "SELECT "ClientCode"
,"ClientName" FROM "dbo"."ptpClientView" WHERE ("ClientName" LIKE '%st
nic%' ) ORDER BY "ClientName" \ 0"
  SDWORD -3

WINWORD 924-a14 EXIT SQLExecDirect with return code 0
(SQL_SUCCESS)
  HSTMT 09D91C18
  UCHAR * 0x38000D08 [ -3] "SELECT "ClientCode"
,"ClientName" FROM "dbo"."ptpClientView" WHERE ("ClientName" LIKE '%st
nic%' ) ORDER BY "ClientName" \ 0"
  SDWORD -3

WINWORD 924-a14 ENTER SQLFetch
HSTMT 09D91C18

WINWORD 924-a14 EXIT SQLFetch with return code 0 (SQL_SUCCESS)
HSTMT 09D91C18

WINWORD 924-a14 ENTER SQLGetData
  HSTMT 09D91C18
  UWORD 1
  SWORD 1 <SQL_C_CHAR>
  PTR 0x0012C748
  SQLLEN 256
  SQLLEN * 0x0012C88C

WINWORD 924-a14 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
  HSTMT 09D91C18
  UWORD 1
  SWORD 1 <SQL_C_CHAR>
  PTR 0x0012C748 [ 6] "S71266"
  SQLLEN 256
  SQLLEN * 0x0012C88C (6)

WINWORD 924-a14 ENTER SQLGetData
  HSTMT 09D91C18
  UWORD 2
  SWORD 1 <SQL_C_CHAR>
  PTR 0x0012C748
  SQLLEN 256
  SQLLEN * 0x0012C88C

WINWORD 924-a14 EXIT SQLGetData with return code 0 (SQL_SUCCESS)
  HSTMT 09D91C18
  UWORD 2
  SWORD 1 <SQL_C_CHAR>
  PTR 0x0012C748 [ 18] "St Nicholas School"
  SQLLEN 256
  SQLLEN * 0x0012C88C (18)

WINWORD 924-a14 ENTER SQLFetch
HSTMT 09D91C18

WINWORD 924-a14 EXIT SQLFetch with return code 100
(SQL_NO_DATA_FOUND)
HSTMT 09D91C18

WINWORD 924-a14 ENTER SQLFreeStmt
HSTMT 09D91C18
UWORD 0 <SQL_CLOSE>

WINWORD 924-a14 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 09D91C18
UWORD 0 <SQL_CLOSE>

WINWORD 924-a14 ENTER SQLFreeStmt
HSTMT 09D91C18
UWORD 1 <SQL_DROP>

WINWORD 924-a14 EXIT SQLFreeStmt with return code 0 (SQL_SUCCESS)
HSTMT 09D91C18
UWORD 1 <SQL_DROP>

WINWORD 924-a14 ENTER SQLAllocConnect
HENV 09D91540
HDBC * 0012C6A0

WINWORD 924-a14 EXIT SQLAllocConnect with return code 0
(SQL_SUCCESS)
HENV 09D91540
HDBC * 0x0012C6A0 ( 0x09d925d8)

WINWORD 924-a14 ENTER SQLSetConnectOption
  HDBC 09D925D8
  SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
  SQLPOINTER 0x00000014

WINWORD 924-a14 EXIT SQLSetConnectOption with return code 0
(SQL_SUCCESS)
  HDBC 09D925D8
  SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
  SQLPOINTER 0x00000014 (BADMEM)

WINWORD 924-a14 ENTER SQLDriverConnectW
  HDBC 09D925D8
  HWND 00040120
  WCHAR * 0x09D57310 [ -3] "******\ 0"
  SWORD -3
  WCHAR * 0x09D57310
  SWORD 8
  SWORD * 0x00000000
  UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>

WINWORD 924-a14 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
  HDBC 09D925D8
  HWND 00040120
  WCHAR * 0x09D57310 [ -3] "******\ 0"
  SWORD -3
  WCHAR * 0x09D57310
  SWORD 8
  SWORD * 0x00000000
  UWORD 3 <SQL_DRIVER_COMPLETE_REQUIRED>

DIAG [S1000] [Microsoft][ODBC Driver Manager] General error: invalid
window handle (0)

WINWORD 924-a14 ENTER SQLErrorW
  HENV 09D91540
  HDBC 09D925D8
  HSTMT 00000000
  WCHAR * 0x0012C590 (NYI)
   SDWORD * 0x0012C600
  WCHAR * 0x0012C190
  SWORD 512
  SWORD * 0x0012C616

WINWORD 924-a14 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
  HENV 09D91540
  HDBC 09D925D8
  HSTMT 00000000
  WCHAR * 0x0012C590 (NYI)
   SDWORD * 0x0012C600 (0)
  WCHAR * 0x0012C190 [ 69] "[Microsoft][ODBC Driver
Manager] G"
  SWORD 512
  SWORD * 0x0012C616 (69)

WINWORD 924-a14 ENTER SQLErrorW
  HENV 09D91540
  HDBC 09D925D8
  HSTMT 00000000
  WCHAR * 0x0012C590 (NYI)
   SDWORD * 0x0012C600
  WCHAR * 0x0012C190
  SWORD 512
  SWORD * 0x0012C616

WINWORD 924-a14 EXIT SQLErrorW with return code 100
(SQL_NO_DATA_FOUND)
  HENV 09D91540
  HDBC 09D925D8
  HSTMT 00000000
  WCHAR * 0x0012C590 (NYI)
   SDWORD * 0x0012C600
  WCHAR * 0x0012C190
  SWORD 512
  SWORD * 0x0012C616

WINWORD 924-a14 ENTER SQLFreeConnect
HDBC 09D925D8

WINWORD 924-a14 EXIT SQLFreeConnect with return code 0
(SQL_SUCCESS)
HDBC 09D925D8

Next message: Richard Abraham: "Dynamic SQL execute fails when called from C++"
Previous message: Dennis Gray: "Date conversions using ODBC for Access"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Office XP / Access 97 / Sql Server 2000
... We have a global Word template that calls a VB6 COM dll. ... 97 database with some tables that are linked to SQL Server 2000. ... connect to SQL_DB' - where SQL_DB is the name of the Sql database). ... this data access works the first time (the first time they ...
(microsoft.public.office.developer.vba)
SQL Server Msg 1105, Level 17, State 2, Line 1
... I backed up a database (SQL server 7.0) and tried to restore it on ... This is not the first time I'm doing ... Could not allocate space for object '' in database ... RESTORE DATABASE is terminating abnormally. ...
(comp.databases.ms-sqlserver)
Re: Why running the same query after the first time is faster ?
... Most likely it is cache, ... Pro SQL Server 2000 Database Design - ... >I have SQL Server 2000 database that has about 8.5 million records. ... > slower to run the SP the first time around? ...
(microsoft.public.sqlserver.programming)
sql database security
... This is the first time I use SQL server for my application. ... The first database need to be "hidden" hence no one else even SA should ... Prev by Date: ...
(microsoft.public.sqlserver.connect)
Re: MS Access DAO -> ADO.NET Migration
... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
(microsoft.public.dotnet.framework.adonet)