Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013

    Unanswered: QUERY TIME OUT Error

    Hi All,

    I am facing some problem with running MS SQL Queries through MS Access 2003.

    Actually the process is like this.

    Step 1. Insert to a table using Access vba coding.
    Step 2. Table has a trigger which execute the stored procedure based on the data inserted.
    Step 3. Stored procedure is working fine when i am executing the stored procedure in SQL Server.

    but when i am running the same process through ms access i am getting "Run-time error 3155 ODBC SQL Server Driver Timeout expired (#0)"

    Thanks in advance.

  2. #2
    Join Date
    Sep 2013
    Issue resolved, using ADODB connection and increased the Time out refresh time.
    Which solved my issue.

Posting Permissions

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