We help IT Professionals succeed at work.

ODBC--call failed

msdba
msdba asked
on
463 Views
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?
Comment
Watch Question

Hi..

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

Commented:
Hi Veerabhadraiahhv, Thanks for comments.
Where should I increase query's ODBC timeout property?
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.