Server list from MS SQL

oz8hp · Post by **oz8hp** » Mon 12 Apr 2010 05:35

I have made a setup for my DBs where I can list all available MySQL servers. This is working 100%. But when using MS SQL it only works if 'Named pipes' is enabled under 'Protocols for MSSQLSERVER'

How can this be and is there any way to avoid this so I can see all MS SQL servers with TCP enabled as I would like to?

Dimon · Post by **Dimon** » Mon 12 Apr 2010 07:39

UniDAC should return server list for MS SQL Server the same way as for MySQL.
Please give a more detailed description of the problem.

oz8hp · Post by **oz8hp** » Mon 12 Apr 2010 08:14

When I try the same code as used to see MySQL servers I get only the servers where Named Pipes is enabled.

You might get some info from:
www.hugopedersen.dk/content/files/temp.zip

Dimon · Post by **Dimon** » Mon 12 Apr 2010 12:09

To solve the problem set the TUniConnectDialog.UseServerHistory property to False.

oz8hp · Post by **oz8hp** » Mon 12 Apr 2010 16:49

OK - will try that tomorrow when I get to work.

Will notify of result

oz8hp · Post by **oz8hp** » Tue 13 Apr 2010 05:24

Looks like it is working - but it takes forever and ever to get the info.

(2 MySQL servers and 3 MS SQL servers on Gigabit LAN)

Dimon · Post by **Dimon** » Tue 13 Apr 2010 07:12

This occurs because all computers in local network are polled to get a list of all available servers. For SQL Server we are using OLEDB methods for this and we can't change this behaviour.