October 29, 2003 at 7:06 am
I am fairly new to DMO so maybe I am overlooking something but... I have an app the gets uses dmoApp.ListAvailableSQLServers, needing to see if a local instance (MSDE most likely) exists. Each of the 7 PCs that I tested had MSDE installed. On some PCs, this returns the local name; on other PCs, this returns an empty list. I used SVRNETCN to enable tcp/ip. The server has been stopped and started. The OS is 2000 pro. Any ideas? TIA!
Steven E Broomhead, Sr
Steven E Broomhead, Sr
October 31, 2003 at 2:16 pm
Do you get the same results every time? Not much you can do wrong with the method call. Using the SQL2K version of DMO using the '2' objects?
Andy
October 31, 2003 at 2:25 pm
After I posted, I got to thinking about the differences. 2 of the 3 that produced no list were laptops not connected to network even tho' they usually are. In all 7, I was local Administrator and not logged into the domain. And I thought that this is too simple to screw up!?!
Steven E Broomhead, Sr
Steven E Broomhead, Sr
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply