• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

ODBC Timeout

I'm using an ODBC connection to connec to a data source to import data into SQL Server 2005.  I have no problems setting up the connection and the data transfer works fine on a small sample of data (doing a SELECT TOP 100 * FROM <table>).

This issue is that when I try to pull down the full table, I get a timeout on the ODBC connection.  I've turned on the 'Save long running queries to the log file' and tried to change the 'Long query time (milliseconds)'.  Problem is the maximum value I can enter in this field is 99999 which is only 99 seconds.  I've also tried entering 0 thinking that would be the unlimited setting.  Neither of these options work.

Is there anything I can do?

Note: This is a one time data transfer and I really do not care if it take 3-4 hours to run as the total table contains almost 1 million records
1 Solution
Highlight the root name of your SQL Database in SQL 2005 Manage Console and use right mouse click and select "Properties".  A Properties screen will show up.  Select "Connections" on the left side of the menu and make sure "Allow remote connections to this server" option is selected.  Now change the Remote query timeout in the dropdown list from its default value to 0.  You should be able to make your ODBC connection now.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now