ODBC--call failed

Posted on 2011-04-27
Last Modified: 2012-08-13
I’m running into  problem with table dbo.Contacttable
When I run an append query to append records to this table, I get this message

ODBC--call failed
[Microsoft][ODBC SQL Server Driver] Timeout expired (#0)

I don’t get the error if I run an append query to a different table, only this one
I can also run a select query against the data with error.

What should I do to resolve this?
can somebody plz help me with this?
Question by:msdba
    LVL 4

    Expert Comment


    Difficult to say without understanding the query you are running. Please give me the query.

    Try increasing your query's ODBC timeout property from the default 60 seconds to a larger value. Try for zero it means infinity.

    Author Comment

    Hi Veerabhadraiahhv, Thanks for comments.
    Where should I increase query's ODBC timeout property?
    LVL 4

    Accepted Solution

    In order to configure timeouts for SQL Server Driver using ODBC connection
    using DSN, click

    Contol Panel --> Administrative Tools --> Data Sources (ODBC)
    Choose your connection (User DSN/System DSN)
    Choose the Data Sources --> Configure
    At the fourth page of the configuration window
    Tick the option for "Save long running queries to the log file:"
    Once tick, there's a field called "Long queries time (miliseconds):"
    The default value is 30000 miliseconds.

    For more info See below link:

    Author Closing Comment


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now