Solved

ODBC Timeout

Posted on 2008-06-20
1
462 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

733 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