Solved

ODBC slow over different networks

Posted on 2013-06-13
1
306 Views
Last Modified: 2013-06-13
Hi,

I moved one of my servers to a different network and since then any ODBC connection processes runs very slow on my PC.

Is there anything I can do to fix the issue besides moving my actual PC to the same network as where the server is located.  Is there a config file or something?
0
Comment
Question by:FundFire
1 Comment
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
Comment Utility
In short, no.  It is what it is.   Speed depends on so many factors.  Without an in-depth look at what's going on, it would be very hard to offer anything specific.

 In general though, there is nothing really that you can configure performance wise with ODBC.

  Some RDBMS's will allow for some config settings, but many do not and speed is more a function of what's being requested, how often, and what network is in place.

Jim.
0

Featured Post

What Security Threats Are You Missing?

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 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