Thread: Enumerate servers in network
 |
This question is answered.
|
|
Replies:
3
-
Last Post:
Jun 24, 2017 6:49 PM
Last Post By: Dmitry Arefiev
|
|
|
Posts:
26
Registered:
9/26/99
|
|
Is there any way FireDAC can help me enumerate available mssql servers AND server instances (e.g. SERVERNAME\SQLEXPRESS) on the local network?
/Anders
|
|
|
Posts:
1,406
Registered:
12/7/03
|
|
See method TFDPhysMSSQLDriverLink.GetServers(AList: TStrings; ARefresh: Boolean)
--
With best regards,
Dmitry
|
|
|
|
Posts:
26
Registered:
9/26/99
|
|
Thanks, but there are two problems here:
1. I only get ">discovering ...>" as the only item. I can see how that is used in the connection editor UI, but I can't find out how you do it. Could you please elaborate? (The help just says there is no information on GetServers)
2. Even in the Connection Editor there is no mentioning of an instance. I have SQLEXPRESS and my server is reported as COMPUTERNAME, but it should be COMPUTERNAME\SQLEXPRESS. Is there a way to go around this?
/Anders
See method TFDPhysMSSQLDriverLink.GetServers(AList: TStrings; ARefresh: Boolean)
--
With best regards,
Dmitry
|
|
|
|
Posts:
1,406
Registered:
12/7/03
|
|
1. I only get ">discovering ...>" as the only item. I can see how that is used in the connection editor UI, but I can't find out how you do it. Could you please elaborate? (The help just says there is no information on GetServers)
You should wait for some time. While FireDAC discovers servers, it will return "<discovering ...>".
2. Even in the Connection Editor there is no mentioning of an instance. I have SQLEXPRESS and my server is reported as COMPUTERNAME, but it should be COMPUTERNAME\SQLEXPRESS. Is there a way to go around this?
Probably your computer does not run SQL Server Browser service ...
--
With best regards,
Dmitry
|
|
|
|
Legend
|
|
Helpful Answer
(5 pts)
|
|
Correct Answer
(10 pts)
|
|
Connect with Us