When I try to connect to a SQL Server 2000 database running locally, I get the error message:
"Unable to connect to database.
It is only possible to connect to SQL Server Desktop Edition databases with this version of Visual Studio."
What in the world does this mean I have a Developer Version of SQL 2000 running and a Developer Version of VB.NET.
Can't connect to SQL Server 2000
EHamel
Are you using a DSNless connection or an ODBC driver connection If you're using DSNless, make sure the syntax is correct. In .NET, even a capital letter throws off the name of your database. Also, make sure the user you're trying to connect with has permissions to that database. Last, make sure you're using pipes and TCP/IP to connect. If your database is behind a firewall, make sure to use an ODBC driver from the non-fireside of the network. A DSNless connection will give you that error if your database is behind a firewall.
******
Get a handle on your web servers' peformance/health from anywhere and anytime by sampling important peformance counters over the web. Find out what's wrong before the phone starts ringing off the hook. Make sure your mission-critical web servers stay responsive and discover any bottlenecks. View stats on Palm or cellphone (script has dynamic screen rendering). Check it out at http://www.ifusionsoft.com. (WSP Snapshot 1.0).
VBalaji
madfan
Tom,
What are you using to connect Query Analyzer, Management Studio, ADO, ADO.Net
If it's through code, please post the connectionstring.
Adamus