?
Solved

ODBC Timeout

Posted on 2008-06-20
1
Medium Priority
?
467 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 2000 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

Configuring Remote Assistance for use with SCCM
IF you are either unfamiliar with rootkits, or want to know more about them, read on ....
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

649 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