General information
Forum:
Microsoft SQL Server
Title:
Find SQLServer from station with SQL-DMO
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only