Getting Error: S1008: [Microsoft][ODBC SQL Server Driver]Operation canceled

[Frank Shoemaker]

I have an Access 97 front end going to SQL Server 7 using ODBC version
3.70.06.91

Intermittenly I get this error:

S1008: [Microsoft][ODBC SQL Server Driver]Operation canceled

This is an example of the SQL that caused the error:

UPDATE viwCustomer
SET SalesFollowUpDate = '5/2/00', LastChangedDate = '5/30/00 4:18:02
PM' , LastChangedBy = 'Jeff'
WHERE CustomerID = 29593 ;

I'm submitting the SQL to SQL Server via an Access Passthrough query.

The name viwCustomer is a view like this: SELECT * FROM CUSTOMER

When submit the same SQL via SQL Server Query Analyzer, the SQL always
works. This makes me think it's an ODBC problem.

Any suggestions would be appreciated.

----------------------------------------------------------------------------
Frank Shoemaker
MindCrafted Systems, Inc.
1969 Newbury Dr.
Westlake, Ohio 44145 USA
Office: (440) 835-2983
Fax: (440) 835-2182

[Jens K Jensen]

Hi Frank

Don't know whats goin on, but S1008 is ODBC 2.0 State for ODBC 3.0 State
HY008, at least according to ODBC Manuals:

ODBC 2.x SQLSTATE ODBC 3.0 SQLSTATE Comments
----------------------------------------------------------------------------
-----
S1003 HY003
S1004 HY004
S1008 HY008
S1009 HY009 Returned for an invalid use of a null pointer.

And HY008 is used to tell that an Asynchroneus execution was canceled, below
is from ODBC 3.0 Manuals:

'While a function is executing asynchronously-that is, after it has returned
SQL_STILL_EXECUTING and before it returns a different code-the application
can cancel it by calling SQLCancel with the same statement handle. This is
not guaranteed to cancel function execution. For example, the function might
have already finished. Furthermore, the code returned by SQLCancel indicates
whether SQLCancel successfully attempted to cancel the function, not whether
it actually did cancel the function. To determine if the function was
canceled, the application calls the function again. If the function was
canceled, it returns SQL_ERROR and SQLSTATE HY008 (Operation canceled). If
the function was not canceled, it returns another code, such as SQL_SUCCESS,
SQL_STILL_EXECUTING, or SQL_ERROR with a different SQLSTATE.'

To me above info suggests that Access 97 may not be fully SQL Server 7.0
aware. Perhaps you should visit MS Knowledge Base for known issues on Access
97 and SQL Server 7.0 ?

regards
jensk

"Frank Shoemaker" <fr...@mindcrafted.com> wrote in message
news:ed3$i2ny$GA.199@cppssbbsa03...