VB.Net 2003 standard connecting to SQL Server

Decidion

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 ".....unabl e to connect and that
this version of Visual Studio can only use the SQL Server Desktop Edition and
MS Access as data sources....".

What?!?!?!!?

They sent me this copy with training materials that are using full SQL
Server databases, not desktop editions. So I cant use the software they
provide to actually *do* the exercises?

Perhaps this is a bug? Perhaps I am doing something wrong? Can anyone help
me out?

As a side note, I reveiwed the VB.Net 2003 product page and looked at their
comparison between the standard and professional versions and nowhere can I
find it saying that you can only connect to SQL Server DE and MS Access with
the standard edition. In fact it is even misleading because it says you can
upgrade old vb apps with the standard edition.... what they should have said
is that you can upgrade old database apps as long as they use SQL Server DE
or MS Access as a datasource!

Any help, advice, clarification and direction would be greatly appreciated!!

Dec

Nov 21 '05 #1

Subscribe Reply

1220

Joseph MCAD

Jan. 6, 2005

I had that happen to me once with the Professional Edition. I had to
uninstall and then reinstall it. If that doesn't work then you will want to
uninstall and reinstall the SQL Server too. It was rather frustrating, but
fortunately I was going to reformat my hard drives so I was going to have to
do it anyway. I found that it might have also been caused by specifying an
instance name for the server when I installed SQL Server (it isn't supposed
to matter either way though). If you stay with the default name when you
install it, you might prevent it from happening again. You should be able to
connect to it just fine (and I have), so this is just a bug. It is a rather
time-consuming one too! If this reply helps you, then please click the "Yes"
just above this message where the question asks "Was this post helpful to
you?". Thanks and happy waiting for it to install again! :)
Joseph MCAD

"Decidion" wrote:

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 ".....unabl e to connect and that
this version of Visual Studio can only use the SQL Server Desktop Edition and
MS Access as data sources....".

What?!?!?!!?

They sent me this copy with training materials that are using full SQL
Server databases, not desktop editions. So I cant use the software they
provide to actually *do* the exercises?

Perhaps this is a bug? Perhaps I am doing something wrong? Can anyone help
me out?

As a side note, I reveiwed the VB.Net 2003 product page and looked at their
comparison between the standard and professional versions and nowhere can I
find it saying that you can only connect to SQL Server DE and MS Access with
the standard edition. In fact it is even misleading because it says you can
upgrade old vb apps with the standard edition.... what they should have said
is that you can upgrade old database apps as long as they use SQL Server DE
or MS Access as a datasource!

Any help, advice, clarification and direction would be greatly appreciated!!

Dec

Nov 21 '05 #2

Chris

The standard edition does not include all the data wizards that the
more advanced versions do.

You can connect to SQL server but you must code it yourself.

I recommend checking out the Microsoft Data Application Block. It
makes it easy to write code to connect to SQL server and it's free

http://msdn.microsoft.com/library/de...ml/daab-rm.asp

Nov 21 '05 #3

Herfried K. Wagner [MVP]

"Decidion" <De******@discu ssions.microsof t.com> schrieb:

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 ".....unabl e to connect and
that
this version of Visual Studio can only use the SQL Server Desktop Edition
and
MS Access as data sources....".

Standard edition is lacking designers and wizards for SQL Server databases
and other databases except MSDE and Microsoft Access. Nevertheless, you
still /can/ build applications that work together with SQL Server, but you
will have to establish connections etc. by code. Connection strings for SQL
Server can be found at <URL:http://www.connections trings.com/>.

--
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 #4

Similar topics

1188

Problem with dymanic help in VS C# .Net 2003

by: John Wardlaw | last post by:

Hi, I've just installed Visual C# .Net 2003 Standard onto my PC. The operating system is XP professional. I've also loaded the MSDN libraries and downloaded the latest from Microsoft: Oct. 2003 (at least I think that's the latest) However, whenever I start visual Studio the dynamic help can not find the server for any of the help entries.

.NET Framework

3202

ASP.Net Application - SQL Server 2000 Access Problem on Windows 2003 server from XP

by: Vaap | last post by:

I did lot of googling to see if I can solve the SQL server not found problem while trying to run ASP.Net community starter kit from an XP machine to Windows 2003 server hosting SQL server 2000 database. Tried all possible combinations but it still fails. I have Windows 2003 server having SQL Server 2000 installed with SP2. The installation went Ok on a XP professional machine and I was able to create database and user logins etc on...

ASP.NET

1033

Connecting VB.net 2003 standard and SQL Server

by: Decidion | last post by:

Visual Basic .NET

2009

Connecting to sqlserver2003 on windows server 2003 from asp.net on windows server2003

by: Vinod R.Shenoy | last post by:

Hi All, Came across a post wherin you had helped somebody with a similar problem and was wondering if you could help us out with it. Our problem is , We have a development SQL Server 2000 (running on Win2K SP4) machine that we want to run on a Windows 2003 server machine and access it via our internal LAN. We have opened the firewall to allow our applications

ASP.NET

8407

What is ONU?

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

General

8512

The easy way to turn off automatic updates for Windows 10/11

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8612

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7347

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6175

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4171

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

2739

transfer the data from one system to another through ip address

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

C# / C Sharp

1969

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1732

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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

General