LordNader

bri - I just downleaded it. unzipped the package and opened it in Word and Wordpad and it worked. Did you unzip it? Nader Hamzei

No, I think you know what your talking about Hey Joe Mamma, I believe you are corrrect with the caviat "for small single user applications ". MSDE is actually MS SQL server on downers. It is VERY CPU intensive. The application that I designed it for however was a very large scale Catalog, with multiple table relationships with some tables having more than 200,000 rows. To make matters more difficult, The report was being run by Crystal and the average report had a SQL SP with around 7 to 8 table joins. The application needed to run on a laptop while not connected to the internet and also update the database when the user connected in the background. We did attempt many different ways of doing it, such as Access DB, but the performance was not good. There is also one downside I have noticed by using the Jet Engine. mdb table locks can cause datapackage collison. It should never be used in a multi user application. I found this out the hard way once when the Client was too cheap to pay for SQL anyway, have fun and thanks :cool: Nader Hamzei

Matthais, do distribute MSDE engine with an application please downlaod my "how To" document . unfortunately it is on gotdotnet.com not here go there and search the sample database for "Embedding MSDE SQL" and you will get a document I wrote about this good luck Nader Hamzei

If you need to automated the installation of MSDE in a setup application for Visual .NET, you can download a document I wrote that details that visir godotnet.com and search the samples database base for "Embedding MSDE SQL" and you shoudl get a word doc. it will eplain everything for you Nader Hamzei

Hey Folks, sorry it took so long for me to sign back on if you need help with MSDE, go to gotdotnet.com and search the sample database for "Embedding MSDE SQL" and you should get a document I wrote that details everything out. Let me know if you guys still need help. Nader Hamzei

Nancy, this error can be caused by two things. The first and simple one is that the user logged on does not have permisssion to load software on the machine. Sys Admin can help by either loading the machine or changing ther users permission in that case. Your problem is something else I think. The reason I say this is that you state "I am using Crystal Reports 9, by the way, not the version that came with Visual Studio." Check in your Setup and Deployment Application. Under "Detected Dependencies" see if there is a dotnetcrystalreports.msm file. now see if you have added the other msm files required. By this I mean reportengine.msm, crruntime.msm, etc. If you have both sets of the msm files, then thats your problem. You are generating duplicate objects with same GUID. There are two ways to fix this. The easiest is to just right click on dotnetcrystalreports.msm in the "Detected Dependencies" and check "Exclude" rebuild your application and you should be fine. Another way to fix the same problem is to open the msi in ORCA and regenerate the GUIDs. but this is only to test to see if this is the only problem. I would strongly recommend the first option. as the second does not fix the problem, just the MSI file. Hope this works Nader Hamzei

yeah you can but.... yes you can but it is a long process you first need to add the msm modules. I have a list for you if you need then you also need to get a copy of ORCA to hand edit the MSI file that is output by Visual Studios. on top of that you need to include a script inside the setup to name the instance of the SQL server the MSDE installs and then you need to change the password on it. if you (or anyone else) is still interested, let me know and I will list everything here, but it is a bit of work. Nader Hamzei