using the msde engine instead of sql server

[Mack2]

Our program is based on a sql database. But we would like to be able to hand out the program on a disk for people to use, that does not have sql server installed. Does anyone know how we can use the MSDE engine instead of sql server. Just so people can test the program. THANKS for any help you can give

 

[SpiderBear6]

You can sure use MSDE.. as long as you don't have more than 5 concurrent users. The best thing about MSDE is that the databases for it are actually SQL Server databases and so you can easily hook up the database to a full Sql Server installation. Also depending on how you are installing your app, you can automatically install MSDE on the user's machine if they don't already have it.


--------------------------------------
"We are star-stuff. We are the universe made manifest trying to figure itself out."
-- Delenn in Babylon 5 - "A Distant Star"

 

[Mack2]

How do you add a database to it and connect to it. It does not have an enterprise manager or anything does it? I can install it ok. I am not sure how to make a connection to it. Thanks for your help!!!!!!!!!!!111

 

[nigelrivett]

You would write an application to allow the users to connect.
You can use osql to execute ad hoc queries including create database to create a datebase.

Most experienced people don't use enterprise manager anyway and it's not too difficult to change from query analyser to osql (just a bit of a pain).

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[Tankgirl]

Hi,

I am struggling to get the list of servers when MSDE is installed on the client and SQL on the server. Get Active X cannot create object but all the dll's are on the machine. What am I missing?

Thanks