Page 1 of 1
Server list from MS SQL
Posted: Mon 12 Apr 2010 05:35
by oz8hp
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?
Posted: Mon 12 Apr 2010 07:39
by Dimon
UniDAC should return server list for MS SQL Server the same way as for MySQL.
Please give a more detailed description of the problem.
Posted: Mon 12 Apr 2010 08:14
by oz8hp
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
Posted: Mon 12 Apr 2010 12:09
by Dimon
To solve the problem set the TUniConnectDialog.UseServerHistory property to False.
Posted: Mon 12 Apr 2010 16:49
by oz8hp
OK - will try that tomorrow when I get to work.
Will notify of result
Posted: Tue 13 Apr 2010 05:24
by oz8hp
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)
Posted: Tue 13 Apr 2010 07:12
by Dimon
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.