Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find SQLServer from station with SQL-DMO
Message
From
25/02/2003 14:33:46
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Find SQLServer from station with SQL-DMO
Miscellaneous
Thread ID:
00757748
Message ID:
00757748
Views:
28
Hi,
I want to get all available SQLServers using SQL-DMO
What don't get is a MSDE in another station.
The driver is mapped and MSDE is started.

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

I want to buid a VFP interface for a MSDE Database,
so the user can from his/her station start backups
and/or schedule some jobs.(If he/she has permission for that)

I havent found a way to do it from a station .

Question: Is it possible ?
If yes: what I'm missing ?
Please: some code if possible.

TIA

Peter
Reply
Map
View

Click here to load this message in the networking platform