473,390 Members | 1,388 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,390 software developers and data experts.

Visual Basic .net 2003 Standard & SQL Server Problems

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
Nov 21 '05 #1
5 3764
Barry,

"Microsoft" <ba**********************@yahoo.co.uk> schrieb:
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'

I don't know exactly where this restrictions are documented, but they are
true. You can only access MSDE or Microsoft Access databases with the
Server Explorer in Visual Basic .NET Standard.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

Nov 21 '05 #2

"Microsoft" <ba**********************@yahoo.co.uk> wrote in message news:Ov**************@TK2MSFTNGP14.phx.gbl...
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

And, as you can download MSDE free,

http://www.microsoft.com/downloads/d...displaylang=en

then use the GUI tools that come with your SQL Server Developer Edition to create and manage databases on your MSDE instance, you should have no difficulties with your VB .NET database projects.

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
Nov 21 '05 #3
Thanks Peter,

I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
..net Standard Edition and tried to reinstall MSDE. The MSDE installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I then uninstalled
Developer Edition to no avail and tried again and have now reinstalled developer edition and still no joy. I am running Windows XP Pro. What am I doing wrong?

Barry Jon
"Peter van der Goes" <p_**********@toadstool.u> wrote in message news:eS**************@TK2MSFTNGP14.phx.gbl...

"Microsoft" <ba**********************@yahoo.co.uk> wrote in message news:Ov**************@TK2MSFTNGP14.phx.gbl...
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

And, as you can download MSDE free,

http://www.microsoft.com/downloads/d...displaylang=en

then use the GUI tools that come with your SQL Server Developer Edition to create and manage databases on your MSDE instance, you should have no difficulties with your VB .NET database projects.

--
Peter [MVP Visual Developer]
Jack of all trades, master of none.
Nov 21 '05 #4

"Barry Jon" <ba**********************@yahoo.co.uk> wrote in message news:ez*************@TK2MSFTNGP15.phx.gbl...
Thanks Peter,

I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
.net Standard Edition and tried to reinstall MSDE. The MSDE installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I then uninstalled
Developer Edition to no avail and tried again and have now reinstalled developer edition and still no joy. I am running Windows XP Pro. What am I doing wrong?

Barry Jon
I'm not sure you're doing anything wrong, but perhaps the instructions we use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003 will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior MSDE installation attempts hanging around. The place to check is: C:\Program Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL Server, delete it and its contents!



2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your MSDE download is). This step will extract the contents of the file to a designated folder. Make a note of the destination folder. You'll need it later. This step does not install MSDE (although the dialogs seem to hint that it does)!



4. Navigate to the folder you created in Step 2. In that folder, you will find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing SETUP.EXE will install MSDE.



5. To execute SETUP.EXE correctly, you must supply an instance name and a system administrator password as part of the command: i.e. the command must be:



SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"



where yourSAPassword is your actual system administrator password. This password is needed only to install MDSE, not to use it. Access to MSDE is controlled by normal "NT Security" which should allow users access based on network logon and password. It is very important the the INSTANCENAME parameter be NetSDK, as this name will enable you to generate the sample databases automatically instead of having to run SQL scripts from the command line.



6. Once installation is complete, you must reboot the PC before you will see MSDE. After the reboot, you should see the MSDE icon in SysTray.



7. You now must execute the file: ConfigSamples.exe to configure sample applications and MSDE system databases. This step will also create user databases in the following location: C:\Program Files\Microsoft SQL Server\MSSQL\Data.

</quote>

If you have trouble locating the ConfigSamples.exe, it's a small file (56k) and I can send it to your email if needed.

Hope this helps.
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.

Nov 21 '05 #5

"Peter van der Goes" <p_**********@toadstool.u> wrote in message news:u8**************@TK2MSFTNGP09.phx.gbl...

"Barry Jon" <ba**********************@yahoo.co.uk> wrote in message news:ez*************@TK2MSFTNGP15.phx.gbl...
Thanks Peter,

I uninstalled MSDE 2000 prior to installing SQL Server 2000 Developer
Edition. I then found I could not use Developer Edition with Visual Basic
.net Standard Edition and tried to reinstall MSDE. The MSDE installation seems
to go fine but when the Service Manager loads is tells me "Not Connected -
\\" no servers are in the Server drop-down and no services are listed in
the Services drop-down. I am very new to all of this and would very much
appreciate any help/advice you could offer. I then uninstalled
Developer Edition to no avail and tried again and have now reinstalled developer edition and still no joy. I am running Windows XP Pro. What am I doing wrong?

Barry Jon
I'm not sure you're doing anything wrong, but perhaps the instructions we use for classroom/lab installs of MSDE to work with Visual Studio .NET 2003 will be helpful:
<quote>
1. Before you begin, check the PC to ensure there are no remnants of prior MSDE installation attempts hanging around. The place to check is: C:\Program Files\Microsoft SQL Server. If you locate a folder named Microsoft SQL Server, delete it and its contents!



2. Execute the file: SQL2KDeskSP3.exe(or whatever the file name for your MSDE download is). This step will extract the contents of the file to a designated folder. Make a note of the destination folder. You'll need it later. This step does not install MSDE (although the dialogs seem to hint that it does)!



4. Navigate to the folder you created in Step 2. In that folder, you will find a subfolder named MSDE. In MSDE, you will find SETUP.EXE. Executing SETUP.EXE will install MSDE.



5. To execute SETUP.EXE correctly, you must supply an instance name and a system administrator password as part of the command: i.e. the command must be:



SETUP.EXE INSTANCENAME="NetSDK" SAPWD="yourSAPassword"



where yourSAPassword is your actual system administrator password. This password is needed only to install MDSE, not to use it. Access to MSDE is controlled by normal "NT Security" which should allow users access based on network logon and password. It is very important the the INSTANCENAME parameter be NetSDK, as this name will enable you to generate the sample databases automatically instead of having to run SQL scripts from the command line.



6. Once installation is complete, you must reboot the PC before you will see MSDE. After the reboot, you should see the MSDE icon in SysTray.



7. You now must execute the file: ConfigSamples.exe to configure sample applications and MSDE system databases. This step will also create user databases in the following location: C:\Program Files\Microsoft SQL Server\MSSQL\Data.

</quote>

If you have trouble locating the ConfigSamples.exe, it's a small file (56k) and I can send it to your email if needed.

Hope this helps.
--
Peter [MVP Visual Developer]
Jack of all trades, master of none.

Arrrgh!

Pay no attention to the skip in step numbers. The missing step was specific to our lab environment.

Nov 21 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Matt | last post by:
I have created an MDI child form that I am using as a base form in a VB.Net MDI application. The base MDI child form has a series of menu options on it. I then use this form to create other MDI...
1
by: Corrie Meyer | last post by:
Announcement: SwiftReports standard edition 1.0 for Visual Studio ..NET 2003 released by UniSwift. We are pleased to announce the first release of a fully-managed reporting tool for the...
0
by: blegs38552 | last post by:
My computer currently has Visual C++ .NET Standard 2003 installed in Windows XP Home Edition, running inside of Microsoft Visual Studio .NET 2003. I recently acquired Visual Basic.net Standard...
2
by: Ralph | last post by:
I used to have Visual Basic .net std. 2003 installed on WinXP SP1A. But I found it too hard to upgrade WinXP to SP2. Now, I do have WinXP SP2 installed, but I am having problems installing...
17
by: Andi Plotsky | last post by:
I am not a .NET developer. I want the Developer's Edition of Visual Studio for use with my Access2000 databases. Does anyone have a clue as to where to find it - my office manager says only .NET...
27
by: Ben Jacobs-Swearingen | last post by:
Hello, I just started learning C a couple weeks ago from Kernighan and Ritchie (first edition -- I can't afford the newer second edition), and have really enjoyed it so far. But I am having...
26
by: Bruno Jouhier [MVP] | last post by:
I'm currently experiencing a strange phenomenon: At my Office, Visual Studio takes a very long time to compile our solution (more than 1 minute for the first project). At home, Visual Studio...
4
by: Christian Blackburn | last post by:
Hi Gang, I saw this for sale online: Microsoft Visual Basic.NET Deluxe Learning Edition Version 2003. I'm wondering is the CD that's bundled with the learning edition just a digitized version of...
1
by: FlyingBuckner | last post by:
All right be kind, this is my first question on a forum. I need help on selecting the right software to purchase. I have a database set up using Access, 6 users. It is split into Tables and...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.