Hi,
I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;
a.. Under the "Connection" tab, under "1. Select or enter a server name:" when I either select the drop down box or click the refresh button I get an error dialog saying "Error enumerating data servers. Enumerator reports Unspecified error'". The dialog caption is "Microsoft Data Link Error". Strangely "3. Select the database on the server:" does actually list the databases on my default instance and the "Test Connection" button results in "Test connection succeeded".
b.. If I ignore the error above and click on "OK" I get the following error message "Unable to connect to database. It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio". The dialog caption is "Server Explorer". I can't actually find any details of such a restriction in the online documentation and this link 'http://msdn.microsoft.com/vbasic/productinfo/features/default.aspx' says "Unless otherwise noted, all of the features listed below are available in every member of the Visual Studio family product line which enables Visual Basic .NET development including: Visual Basic .NET 2003 Standard..." without any such exclusion noted against "Using ADO.NET, Visual Basic .NET developers can gain high-speed access to Microsoft SQL ServerT, Oracle, DB2, Microsoft Access, and more".
Has anyone else had these problems - I have searched online and can't find anything about either. Any help would be much appreciated.
Barry-Jon