Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Unanswered: ODBC Native State S1T00: timeout expired

    Hello :
    I am very new to ODBC connectivity, but i know sql fairly
    well:

    What can generate a Native State Error: Native State
    S1T00: timeout expired on a SQL 2000 database; NT4 OS
    Server??

    I am running sql database dependent applications on this
    server: 3 to be exact.

    e.g. I have an application which transports data that was
    entered to the SQL database located on this Server via a
    LAN user. This application then dynamically takes this
    data and transports it to another device located on the
    same sub-net as the Server for data recognition and other
    functionalities. This is performed in milliseconds hence
    it may be utilizing the (winmm.dll) file to accomplish
    this. But the error message:

    "Warning State: S1T00,Native:0, Origin: [Microsoft][ODBC
    SQL Server Driver] timeout expired"

    causes this process to fail along with other ODBC and SQL
    dependent applictions. also my maintenance plans failed as aresult of this message..

    Can someone please help/ inform me what can cause this and
    how to prevent this??

    Can a modem dial-in access cause this?? though it was
    running fine with modem access in the past, and no change
    in its configs.??

    Thank you in advance

    Adigga

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May check this KBA .
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •