?
Solved

ODBC--call failed

Posted on 2011-04-27
4
Medium Priority
?
445 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?
0
Comment
Question by:msdba
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:Veerabhadraiahhv
ID: 35481520
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.
0
 

Author Comment

by:msdba
ID: 35483025
Hi Veerabhadraiahhv, Thanks for comments.
Where should I increase query's ODBC timeout property?
0
 
LVL 4

Accepted Solution

by:
Veerabhadraiahhv earned 2000 total points
ID: 35483482
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:
http://www.sqlservercentral.com/Forums/Topic691012-131-1.aspx#bm698320
http://blogs.msdn.com/b/sql_protocols/archive/2006/03/09/546852.aspx
0
 

Author Closing Comment

by:msdba
ID: 35753868
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

621 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