Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When I try to create a new database connection, the Data Sources (ODBC) programs hangs or takes a very long time to find the list of available SQL Servers.

This only happens when there are other computers on the network, when my machine (a standard Windows 7 laptop) is alone, it works just fine.

ODBC Window - hangs when I try to select SQL Server

My question is: What should I look for in terms of SQL server or ODBC configurations that will take away this random behaviour?

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

It's not direct answer to your question, but in Server field you can write in ServerAddress or ServerAddress\InstanceName:

write address

So when you know this value don't do server discovery (expand the list). List all Sql Servers in (large) network usually takes long time.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.