Pass through query - ODBC Timeout

[stephenmbell]

I have an access database with a pass through query that essentially calls a Stored Procedure on a SQL Server database.

This stored procedure takes 5+ minutes to complete - it imports 100K+ records from a file, and does some number crunching as well.

I have a button on a form that I want the user to click, once clicked it prepares the text file to import (strips the header row, and quotation marks..etc.. Then runs this stored procedure.

The problem I am having is - the file is getting prepared but when I try to run pass through query I am getting an ODBC Timeout.

The code I am using is simple to run the query:

    
    With DoCmd
        .SetWarnings False
        .OpenQuery "ImportLynkData"
        .SetWarnings True
    End With

I have also tried using ADO to run this by creating a connection object, and a command object and running the command - but I still get an ODBC timeout.

Am I missing something? Any help or suggestions are greatly appreciated. Thanks in advance



sb

[stmoong]

Have you tried setting the ODBC Timeout property for your query? Either set to a specific number of seconds before timeout or 0 for no timeout.