Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't connect to servers with SQLSMO
Message
 
 
To
01/12/2002 23:00:03
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00728512
Message ID:
00728513
Views:
18
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform