When and How Do I Use Desktop Engine -- sql server odbc

Mark Mokris
10/27/2003 10:34:38 AM

We have a SQL Server 2000 database. I naively purchased
VB .net standard thinking that I can write a couple
Windows Forms applications, connecting to the database
through ODBC. When I try to set up a data connection
object to our SQL Server database in the visual
environment I get a message saying "It is only possible to
connect to MS Desktop Engine databases and MS Accesses
databases using this version of MS Visual Studio."

Is the MS Desktop Engine (MSDE) what I want to use? Is
the MSDE essentially my connection from VB to our SQL
Server database? DO I have to "re-create" my tables in
MSDE or can I go straight through to the SQL Server
database. Any suggestions would be really appreciated!

I have read almost all of Microsoft's articles and help
files concerning MSDE and I still do not understand.
Please don't just send me a link.

Ali Baba
10/27/2003 10:47:45 PM

Hi,

MSDE is a stripped down version of Microsoft SQL Server. It has the same
engine but does not have the following:

* Does not include Enterprise manager
* No Query Analyzer or any other quering tool for that matter.
* No backup/restore

MSDE is great for developing or small scale app. It uses the same sql
dialect that is offered by MS SQL Server and therefore, is very easy to
upgrade. The only disadvantage is that there is no GUI tool to manager
the database. This problem can be solved by using free third party tools
such as WinSQL (http://www.synametrics.com)

Baba

--

You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>

[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 about sql server odbc

sql server odbc : When and How Do I Use Desktop Engine