Solved

ODBC Timeout

Posted on 2008-06-20
1
465 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:tfewster500
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 7

Accepted Solution

by:
60MXG earned 500 total points
ID: 21833270
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.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Determining the an SCCM package name from the Package ID
Configuring Remote Assistance for use with SCCM
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

696 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