Hi,
I tried to use "SQLBrowseConnect" API function to get the instances of the sql server in the network. It works fine as long as the network is enabled. But as sson as I disable the network it doesn't return anything, not even the local instance of the SQL Server. Why is that so. Is there any way out? I have ben using VB.Net 2003 and SQL express, so I can't Use SQL DMO(It comes with 2000 only) or SMO(Not available for 2003).
Hello, I'm trying to list the default and named instances on our domain. When I run SqlBrowseConnect all I get back is a list of our servers, for example:
COMP01
COMP50
I'd like to get all the named instances as well, a list with:
COMP01
COMP01DD
COMP50
When I run "osql -L" I get the full list, but not with SqlBrowseConnect. I have tried to set SQL_COPT_SS_BROWSE_SERVER to (SQLPOINTER)NULL which, according to the docs, "[...] returns information for all servers in the domain." I have also set the SQL_COPT_SS_BROWSE_CONNECT to SQL_MORE_INFO_YES without any luck.
Any ideas on any property I might be missing?
Cheers,
Chris