Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Names and Instants
Message
From
08/06/2006 08:58:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Windows API functions
Title:
SQL Server Names and Instants
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01127811
Message ID:
01127811
Views:
71
I am looking for some way in foxpro to list off the sql servers and any instances of sql servers. For example, we have a server that has both Sql 2000 and Sql 2005. The server is not attached to the domain. Right now, I am using "NetServerEnum" to return all SQL SERVERS. However, that server does not show up. I also have SQL 2000 & 2005 running on my local computer. When I run the same code, only my SQL 2000 name shows up. my SQL 2005 instance does not.

SQL 2000 server name "MySqlServer"
SQL 2005 server name "MySqlServer\SQL2005"


TIA
Next
Reply
Map
View

Click here to load this message in the networking platform