473,809 Members | 2,718 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Vb.Net Standard Edition and SQL Server

I am using the standard edition of VB.net. I am trying
to connect to a SQL database on our server using the
built in Sqlconnection object in the Data toolbox. When
set up the connection and test it, it tests OK. But then
I get the following error:

"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."

I have Enterprise Manager so I don't need to build or
modify SQL databases using VB.net, only connect to them.
Did I not install VB.net properly, or do I need to
upgrade to Visual Studio? I have no need for C or Java.
Nov 20 '05 #1
3 1733
If you have standard, you can't use the Visual Tools to connect to SQL
Server, BUT, you can still connect to it. Many shops don't use the visual
tools very often so they may not need to spend the money for the upgraded
version b/c they can still write apps that can connect to SQL Server.
"Mike" <an*******@disc ussions.microso ft.com> wrote in message
news:02******** *************** *****@phx.gbl.. .
I am using the standard edition of VB.net. I am trying
to connect to a SQL database on our server using the
built in Sqlconnection object in the Data toolbox. When
set up the connection and test it, it tests OK. But then
I get the following error:

"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."

I have Enterprise Manager so I don't need to build or
modify SQL databases using VB.net, only connect to them.
Did I not install VB.net properly, or do I need to
upgrade to Visual Studio? I have no need for C or Java.

Nov 20 '05 #2
* "Mike" <an*******@disc ussions.microso ft.com> scripsit:
I am using the standard edition of VB.net. I am trying
to connect to a SQL database on our server using the
built in Sqlconnection object in the Data toolbox. When
set up the connection and test it, it tests OK. But then
I get the following error:

"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."


You cannot connect to a SQL Server database using the IDE.
Nevertheless, you can set up connection objects in your code and
establish a connection.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #3
Cor
Hi Mike,

I checked the first database samples of the resource kit.
The connections are made by hand and not with the wizard.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbr...q/#installvdir
I hope this helps a little bit?

Cor
I am using the standard edition of VB.net. I am trying
to connect to a SQL database on our server using the
built in Sqlconnection object in the Data toolbox. When
set up the connection and test it, it tests OK. But then
I get the following error:

"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."

I have Enterprise Manager so I don't need to build or
modify SQL databases using VB.net, only connect to them.
Did I not install VB.net properly, or do I need to
upgrade to Visual Studio? I have no need for C or Java.

Nov 20 '05 #4

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

Similar topics

1
6058
by: GG | last post by:
Hi, Is there an Upgrade path from SQl server 2000 Standard edition to Enterprise edition? DO we just have to uninstall and do a reinstall? Any help is appreciated. Thanks GG
1
2205
by: Theo Linnenbank | last post by:
Hi, Can someone tell me what the best way is to migrate from a SQL Server 2000 Standard Edition to a SQL Server 2000 Enterprise Edition? Is this a migration possible from the setup program of the Enterprise Edition? What are the pitfalls? Thanks in advance Theo Linnenbank
3
1225
by: Grant Harmeyer | last post by:
Hi All: According to MSDN, C# Standard Edition is good for writing C# programs for Windows or the Web. I am an ASP.NET programmer, and I use both VB and C#. I am looking to doing some hobby programming (WebForms & a limited amount of WindowsForms) at home, and I can't justify fronting the cost for VS.NET 2003 (although I love the IDE and use it at work), can anyone describe to me what the major differences will be from VS.NET to C#...
7
1937
by: Wowbagger | last post by:
I am considering upgrading from vb 6 to .net 2003 and have a couple of questions for which I could not find answers on the MS site. What are the differences between the standard, professional and enterprise editions? In VB 6 learning edition the controls for network functionality were missing. I want to be able to use functions such as finger, HTTP post and ftp: is the .net 2003 standard edition crippled in any way, and/or would I...
2
2784
by: Brian Cryer | last post by:
Appologies if someone thinks this is slightly off topic, but I think viewers of this newsgroups are best placed to answer my question - which is what are the main differences between VB.Net Professional and VB.Net Standard Edition. (Yes I have read the page on the microsoft site about VB.Net Standard and the differences with Professional but it is rather vague.) I use VB.Net Professional at work. I have a friend who I am hoping to do...
1
1042
by: Decidion | last post by:
I received a copy of VB.NET 2003 standard from Microsoft as part of a promotion by viewing ASP.NET webcasts. Included was an ASP training CD and "ASP.NET Programming with Visual Basic.NET" by G. Andrew Duthie. From all I can tell it is a full *standard* version.... not something gimped. Yet when I try creating a data connection and point it to SQL Server a message comes back telling me that it is ".....unable to connect and that this...
3
1227
by: Decidion | last post by:
I received a copy of VB.NET 2003 standard from Microsoft as part of a promotion by viewing ASP.NET webcasts. Included was an ASP training CD and "ASP.NET Programming with Visual Basic.NET" by G. Andrew Duthie. From all I can tell it is a full *standard* version.... not something gimped. Yet when I try creating a data connection and point it to SQL Server a message comes back telling me that it is ".....unable to connect and that this...
5
3816
by: Microsoft | last post by:
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...
1
1361
by: keithb | last post by:
I developed a web site that uses sql server express for permissions and roles. Now I need to deploy it on a server that uses sql server 2005 standard edition instead of sql server express. What do I need to change so that permissions and roles for my website use sql server 2005 standard edition instead of sql server express? Thanks, Keith
23
14045
by: Nishant Saini | last post by:
Dear All, We have a database which contains many tables which have millions of records. When We attach the database with MS SQL Server 2005 Standard Edition Server and run some queries (having joins, filters etc.) then they take very long time to execute while when We execute same queries on Enterprise Edition then they run 10 times faster than on standard edition. Our database does not use any features which are present in Enterprise
0
9721
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9602
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10639
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10376
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
5550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5688
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4332
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3861
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3015
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.