Unix Technical Forum

S1T00 Timeout Expired

This is a discussion on S1T00 Timeout Expired within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> hi, I have a problem after upgrading some client PCs from MDAC 2.5sp2 to MDAC 2.7 (also tried MDAC ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:13 PM
Lerwick Harding
 
Posts: n/a
Default S1T00 Timeout Expired

hi,

I have a problem after upgrading some client PCs from MDAC
2.5sp2 to MDAC 2.7 (also tried MDAC 2.7sp1). MY JDE
application now reports back a time out expired error when
users start the application and try and connect to the
first ODBC datasource. PCs that are still running MDAC
2.5sp2 continue to run without error. I can't find any
docos about what has changed in MDAC 2.7 on technet etc.
Does anyone know what changed in MDAC 2.7 that could cause
this error?

thanks, Lerwick



activConsole 410-4e0 ENTER SQLAllocHandle
SQLSMALLINT 2
<SQL_HANDLE_DBC>
SQLHANDLE 039A12A0
SQLHANDLE * 030E0164

activConsole 410-4e0 EXIT SQLAllocHandle with return
code 0 (SQL_SUCCESS)
SQLSMALLINT 2
<SQL_HANDLE_DBC>
SQLHANDLE 039A12A0
SQLHANDLE * 0x030E0164 (
0x039a1348)

activConsole 410-4e0 ENTER SQLSetConnectOption
HDBC 039A1348
SQLINTEGER 110
<SQL_ODBC_CURSORS>
SQLPOINTER 0x00000000

activConsole 410-4e0 EXIT SQLSetConnectOption with
return code 0 (SQL_SUCCESS)
HDBC 039A1348
SQLINTEGER 110
<SQL_ODBC_CURSORS>
SQLPOINTER 0x00000000

activConsole 410-4e0 ENTER SQLDriverConnectW
HDBC 039A1348
HWND 00000000
WCHAR * 0x1F7B41C0 [ -
3] "******\ 0"
SWORD -3
WCHAR * 0x1F7B41C0
SWORD 8
SWORD * 0x00000000
UWORD 0
<SQL_DRIVER_NOPROMPT>

activConsole 410-4e0 EXIT SQLDriverConnectW with
return code -1 (SQL_ERROR)
HDBC 039A1348
HWND 00000000
WCHAR * 0x1F7B41C0 [ -
3] "******\ 0"
SWORD -3
WCHAR * 0x1F7B41C0
SWORD 8
SWORD * 0x00000000
UWORD 0
<SQL_DRIVER_NOPROMPT>

DIAG [S1T00] [Microsoft][ODBC SQL Server
Driver]Timeout expired (0)

activConsole 410-4e0 ENTER SQLErrorW
HENV 039A12A0
HDBC 039A1348
HSTMT 00000000
WCHAR * 0x0012E27C (NYI)
SDWORD * 0x0012E2B4
WCHAR * 0x0012DE7C
SWORD 325
SWORD * 0x0012E2B0

activConsole 410-4e0 EXIT SQLErrorW with return code
0 (SQL_SUCCESS)
HENV 039A12A0
HDBC 039A1348
HSTMT 00000000
WCHAR * 0x0012E27C (NYI)
SDWORD * 0x0012E2B4 (0)
WCHAR * 0x0012DE7C [
50] "[Microsoft][ODBC SQL Serv"
SWORD 325
SWORD * 0x0012E2B0 (50)

activConsole 410-4e0 ENTER SQLFreeConnect
HDBC 039A1348

activConsole 410-4e0 EXIT SQLFreeConnect with return
code 0 (SQL_SUCCESS)
HDBC 039A1348

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:45 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com