Information générale
Catégorie:
Codage, syntaxe et commandes
Certainly....nothing that grand about it. I found some examples that were using SQL-DMO to obtain all sorts of information regarding sql servers.
Anyway...I just put the following in the Click method of a command button:
* create the objects...
oSQLApp = CreateObject('SQLDMO.Application')
oSQLSrv = CreateObject('SQLDMO.sqlserver')
oServers = oSQLApp.ListAvailableSQLServers()
* code that will enumerate through the list of servers
* and add them to the combo box
ThisForm.lstServers.Clear
For i = 1 TO oServers.Count
ThisForm.lstServers.AddItem(oServers.Item(i))
EndFor
If you scan online or in the sql server documentation you'll find all sorts of properties that SQL-DMO exposes.
Hope this helps!
...Douglas
>Could you post the code?
>
>>>I would like to add a combo-box to a form that would display all of the sql servers on the network. Right now, I have some code that I can use to populate the control from the defined data sources (odbc, dsn, etc.) but I would like to also allow the user to select a specific Sql server.
>>>
>>>Thanks...Douglas
>>
>>Replying to myself and anyone else interested....but I figured out how to do this. I found some VB code that I translated for VFP. Now, my only problem is how to figure out why one of the sql servers is not advertising itself on our network.
>>....douglas
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement