ODBC System DSN Server List Is Empty

[Bluejay07]

Hello,

I'm not sure if this is the best place to post this.

My company has used ODBC DSN connections for years so creating/editing a connection is not a problem. We now have an environment in which the server list does not populate. Here are the steps: Open ODBC and click add. Select SQL Server then next. If we click the drop down box for servers, the list is completely blank. A VB6 program which has ODBC features also cannot populate a server list. We can still type in the server box and using 'local' does work however a full list does not appear.

Any suggestions on why the server list does not populate?

If at first you don't succeed, then sky diving wasn't meant for you!

 

[fredericofonseca]

looks like firewall port blocked on that server

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Alan0568]

Are the sql servers named instances? and do you have the sql server browser service running?

 

[Bluejay07]

Thanks for the responses.
I will examine items based on your comments and try to provide more information.

If at first you don't succeed, then sky diving wasn't meant for you!