Hi,
I am a scientist and new to .NET programming. On my PC, I am using Windows
2000 professional with IIS, SQL Server 2000 (standard, personal), Visual
Basic .net (2003, standard). By following the demo code, I can generate the
web form to access the Northwind data in SQL server. When I tried to use
Server Explorer to add new Data Connection to Northwind, the “test
connection” always work, but click OK always give an error message: “Unable
to connect to databases. It is only possible to connect to SQL Server Desktop
Engine and MS Access databases with this version of visual studio.”
Does anyone know how to make it work? Do I have to use Visual Basic .net
(2003, professional)? Or do I have to install the MSDE on my PC ( I try not
to use Access)?
Thank you in advance.