Server exploI have recently installed Visual Studio .Net 2002 on my
workstation running XP Professional. I can connect to local Access and MSDE
databases successfully using ADO .Net. I can also setup ODBC dsn's that I
can use from Access to browse my MSDE databases.
When I try to add a new MSDE data connection from within Visual Studio's
server exployer, I get as far as successfully executing the connection test.
However, when I close the dialog box in which I created the new connection, I
always receive the following error: "Unable to ad data connection. The
connection failed. Check your username and password, and try again."
In addition, from the server explorer Servers list, I can add the server on
which my MSDE database instance is located. When I drill down to the Sql
Servers section, I can see list mye MSDE database instance, but it has a red
cross through its icon.
As I mentioned, I can access tables in my MSDE database successfully through
VB.Net code, through Access, through the osql tool, but not through Visual
Studio. I have run the Visual Studio repair installation process, but this
did not help.
Has anyone reading this encountered similar problems? I would appreciate
any help or feedback.
Thanks in advance,