Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't connect to servers with SQLSMO
Message
From
02/12/2002 13:33:32
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00728512
Message ID:
00728703
Views:
20
It works in your machine? Interesting. In mine, FOR EACH fails, but if I replace it with FOR i=1 TO oServers.Count it works. From that it would seem that oServers is not a collection, which is needed for the FOR EACH, no?

For the moment I am off the hook, but am curious why it worked in your machine.

Thanks.

Alex

>Alex,
>
>This works on my PC.
CLEAR
>oSQLApp = CreateObject('SQLDMO.Application')
>oServers = oSQLApp.ListAvailableSQLServers()
>FOR EACH lcServer IN oServers
>	? lcServer
>ENDFOR
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform