sql server msde: connect MSDE 2000 with VB.net front end -- sql server msde

connect MSDE 2000 with VB.net front end

jtart2
11/9/2004 4:10:38 PM

sql server msde:

I am familiar with MS Access and SQL Server 2000 because
I have set them up myself,and used them in my offices.
(Access front end, SQL Server back end)

I recently purchased Visual Studio .Net so that I may
learn how to program. My goal is to build an application
for my profession that I may sell to others like myself.
To keep the price down I need to use MSDE 2000 as the
database engine.

I am new to programming (VB.Net), but I would like to use
MSDE 2000 as a back end database to a VB.Net front end
(like MS Access). This will keep those who purchase my
application from having to install MS Access or SQL
Server 2000.

I've skimmed through Books On Line for SQL 2000, but they
don't go into specifics or give good examples about how
to use MSDE 2000 with a VB.Net front end. Each article
that I read says "for more information, visit...."

I just keep going in circles with BOL!!!

I am used to working with Enterprise Manager and MS
Access's Design wizards and Design Forms to configure
everything. MSDE 2000 has no interface,and with VB.Net
you have to write programs to "connect" everything.
What is the easiest way to accomplish my goal?

Thanks for any advice, pointers, or comments!

Newbie,

Re: connect MSDE 2000 with VB.net front end

Mary Chipman
11/10/2004 9:30:05 AM

MSDE *is* SQL Server, with limitations. Whatever you read in BOL
applies to MSDE. That being said, to create your app, don't use MSDE.
Get the Developer edition and use the Enterprise Manager, QA, and
other client tools. Use MSDE for deployment only. Neither VS.NET nor
Access has a complete set of tools for creating robust SQL Server
database applications.

Note that the license agreement prohibits you from using the Developer
edition in a production environment or to manage your deployed MSDE
app, but it's indispensable for creating, securing, debugging and
optimizing your database. For more info, see
http://www.microsoft.com/sql/howtobuy/development.asp.

--Mary

On Tue, 9 Nov 2004 16:10:38 -0800, "jtart2"
[quoted text, click to view]

connect MSDE 2000 with VB.net front end

anonymous NO[at]SPAM discussions.microsoft.com
11/18/2004 1:39:33 PM

I am not sure if this will help you but have you install
Microsoft's Web Data Administrator?

It's a Web Based adminitrator for MSDE
copy and paste this
----
http://www.microsoft.com/downloads/details.aspx?
familyid=f0d03472-5e6c-459e-a6d8-
6745a729c3c9&languageid=f49e8428-7071-4979-8a67-
3cffcb0c2524&displaylang=en
---
or go to the
http://msdn.microsoft.com/downloads/Default.aspx

and search for the 'Web Data Administrator"

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.