Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't connect to servers with SQLSMO
Message
 
 
À
01/12/2002 23:00:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00728512
Message ID:
00728513
Vues:
19
Hi Alex,

Try
CLEAR 
oSQLApp = CreateObject('SQLDMO.Application')
oServers = oSQLApp.ListAvailableSQLServers()
For i = 1 TO oServers.Count
	? i, oServers.Item(i)
EndFor
Does it work?

>Andrew,
>
>Back from GLGDW I am trying to run your MSDEMaint project. Problem is, when loServers = this.oSQLDMO.ListAvailableSQLServers() is executed, no servers are found.
>
>I am running MSDE 7 on this machine, and was able to see the method in object browser, meaning I think that is is properly installed. Also, the local server is active.
>
>Suggestions?
>
>Thanks for the help and for a fine project. It will be extremely useful as soon as I get it running.
>
>Alex
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform