Solved

ODBC Timeout

Posted on 2008-06-20
1
458 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
1 Comment
 
LVL 7

Accepted Solution

by:
60MXG earned 500 total points
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
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.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

772 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now