Posted by Steve on 12/09/05 06:11

Jens wrote:

> Didn´t know that you were aware of using SQl DMO (the link you
> posted). I thought you are just able to use the TSQL options for that,
> therefore the OSQL was the most appropiate solution for me.
>
> Jens Suessmeyer.
>
I know that I had seen SQLDMO sometime past, but didn't really know anything
about it until you made your post. That started me looking. I did a Google
search and the link I posted was one of the results.

As it turns out, I was able to pull the whole thing together and now have an
nicely encapsulated form class that I can use in just about any VB/VBA
application to display a list of servers. The way it works now, it loads
the list of servers on loading, then the list is filtered using a regular
expression to show a specialized subset of server names. The reg.exp. is
set as a property of the form. When the user selects a server from the list
box, that is exposed as another property of the form. I went ahead and made
the entire list another property so that the list could be retrieved
without ever actually raising the form. It turned out nicely.

Thanks for the lead.

Best regards,
Steve

[Back to original message]