Already answered to that:)How ever, I think that it is possible to install sqlserver express as a prerequisite and configure it from the setup, but it requires a lot of work for the first time, so is not a 1 day solution that our friend search for.
After done once, you can reuse the code for other deployment packages.As I have stated before, this happen when you simply jump to code with out well design the project. Even if you have no chance other than use sql server, first, prior to start develop the application, I do a research to see if I can do a "one click" deployment and how I can achieve that.
After this I estimate my work effort and time.Now, our friend, you can not ask from us a magicaly solution because you didn't tailored your project well.
Unfortunately there is not magical solution. You must search to see how can you interact from a custom installer classor from a windows installer package with the sql server, to configure it prior the application start.
best regards----- Original Message ----- From: "Kerneels Roos" <kerneels@xxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx> Sent: Saturday, October 23, 2010 1:21 PMSubject: Re: integrating sql with my software application: a little urgent, please
Hey Rick,Yikes, that's a bit harsh to claim that Sameer is "clueless about persistance and data structures". Sounds to me like he knows exactly what's going on, is just struggling to set up SQL Server Express via the installation shield.Sameer, why don't you try to run your app with an access db just for now. Chances are it might work with no to little additional effort. Then, when your client desires more functionality (more than 2 tables and so on) you could look into other options, like a hosted sql server etc.Hope you come right soon and still manage to impress your client! Kerneels On 10/23/2010 11:43 AM, RicksPlace wrote:OK, so you designed, coded, tested and debugged your application while clueless about the data structures and persistence? Sql Server is a DataBase Server like MySql or Oracle or other major data base engines. They need to have allot of software running to process a DataBase file consisting of Tables and other elements. An Embedded Database is a singular file something like a Text File that you can just include with your application and does not require a stand-alone DataBase Server to process DataBase files. The Engine to run your DataBase is either already on the client or included with your project. You likely should not try and put a DataBase Server like Sql Server or MySql on a client's desktop or mobile machine since maintaining and working with the server itself, not just the Database, would be beyond most client's technical skillset. You need to study up on what a DataBase is, the diference between a DataBase Server and an embedded DataBase and then pick the correct tool for the job prior to jumping in and coding or copying and pasting code and calling your finished project ready to deploy. There is no quick answer yto your problem You will either need to tdownload, install and configure a DataBase Server on every client's machine and then load it and provide the client with all necessary maintenance and reporting software or pick an embedded DataBase like SqlCE and include it in your project and just deploy it with the project. As mentioned you could turn your project into a Website or just put your Sql Server database up on a host website and then just provide each client with access to that central database. You would, of course, use user ID codes and Passwords to handle each individuals particular needs within the centralized DB. Well, Good Luck and I hope you find your quick and simple answer - I don't see one off the top of my head.Rick USA ----- Original Message ----- From: "Kerneels Roos" <kerneels@xxxxxxxxx> To: <programmingblind@xxxxxxxxxxxxx> Sent: Saturday, October 23, 2010 5:19 AMSubject: Re: integrating sql with my software application: a little urgent, pleaseHi man,If I were you I'd drop the idea of running the sql server on the client box and use a remote server, provided your client has internet access and they don't insist on having the data locally.If you plan to do a lot of M$ development in future why don't you get Windows hosting like this:http://www.discountasp.net/ and http://www.discountasp.net/features.aspxLooks like you get 3 months free trial and after that $10 per month, which is significant but it includes a lot of stuff and you would probably be able to host multiple databases and multiple sites on one package.HTH On 10/23/2010 6:38 AM, sameer manohtra wrote:Thanks again for your responses. Yes, I know that using access is more easy option in this scenario, but I’m asked by my boss to do it in sql. He says that if client likes this template, I will require to develop a lot of other tables and a more complex program. One that i’m gonna give right now is just a template to show how will it be done. I know, access is easier to use for now in this situation as well, but as you guys are aware too, “boss is always right”. I think I am still trying to adjust with the freelance system, I would have got a colleague if it was a physical office instead. Never the less, so the key is that I can’t use access as my DBMS, and sql is what I need to do at the moment. I agree that third solution is a solution of course, but I have not been able to do it properly, even though I’ve been trying to make a solution with sql express edition since this morning. Isn’t there a step-by-step tutorial, chapter of a book, or someone kind enough to explain this obtuse? That’s like asking a huge favor I know, but anyways, I’ve discovered a lot of helpful folks out here, so hopes are always alive to get a helping hand. Regards, Sameer! On 10/23/10, black ares<matematicianu2003@xxxxxxxxxxx> wrote:as I've already said, you must change the database management system. Change to access and you will not have these problems. And Access is smart enough to play with your two tables. ----- Original Message ----- From: "sameer manohtra"<sameermanohtra@xxxxxxxxx> To:<programmingblind@xxxxxxxxxxxxx> Sent: Saturday, October 23, 2010 5:51 AMSubject: Re: integrating sql with my software application: a little urgent,please Guys, I’ve been trying to do some investigation on the internet, but unfortunately it has confused me even more, instead of giving any helpful pointer. I found out that i need to install either sql server express or something called sql compact edition to target computer. ok, that would have not been a big problem, but from some other sources on the internet I got to know that express edition does not configure the databases automatically and one need to do a lot of manual work around. I did not understand anything much from the description I got to read from many ssources about how to accomplish this, hence i’ve got even much puzzled Seriously, I did not know that its going to be this much difficult to accomplish when I was developed this application. Though I’m not losing hope because I know this is how I will get to learn, but still I don’t have a proper clue about how should I perform the operation. Its just an application that’s using one database, having 2 tables, and simple storing and retrieving works are needed to be performed. I will still appreciate if someone can suggest me a clear, step-by-step way on how should I make the setup of a software that I’ve developed, that contains database. Anything which can make this work on target computer. At some places, I got to know that i can add sql express edition as a prerequisite in my setup project, but I found out that it still doesn’t solve the problem, since the database instance and creation still doesn’t work in this situation. Help, please! Regards, Sameer! On 10/23/10, sameer manohtra<sameermanohtra@xxxxxxxxx> wrote:hi, thanks for the response. I’m glad to know that these many ways exist, but should I tell you frankly, I have no idea which one to use, and how. About the third option, though that sounds easy, but still the question is, how will the MDF file work if user doesn’t have the SQL installed on the computer. The first and second ways sounds interesting too, but again, I haven’t used it, so no idea on how will it be done. Just a humble request, could you please be more specific on what should I do here? The problem is that I am asked to deliver it quick, so I just don’t have much time to investigate this in depth. @black, if you say that you use the first option frequently, please, could you explain me how do you do it, and how can I make it work quick? Its just a very simple application as I said, which has a c# form which takes the inputs from the user, stores it in the sql database, and retrieves the values back when requested. Please, help me doing this, will really appreciate. Regards, Sameer! On 10/22/10, black ares<matematicianu2003@xxxxxxxxxxx> wrote:you have two or three solutions to investigate. 1. The setup and deployment feature has a nice thing.You can write custom actions and custom class installers, which can evenhave ui elements.So you must create an window and an installer class, get from the userthedata necesary to connect to sql server and create all the database andpopulate the database.For this you simply need a script which you can generate using your sqlserver management studio.\2. When you develop such an application, you can use an database project. This project then has the create and update scripts for your database andwhen you make a setup you will include the output of this ile on your setup and it will populate your database. 3. You can use an attached database.So the mdf file will be in your project and when you will get from theusernecesary data to build the connection string, you can attach the databaseto the client server.Personally I've used irst version, but if you can quickly investigate,the third seems to be the quickest. ----- Original Message ----- From: "sameer manohtra"<sameermanohtra@xxxxxxxxx> To: "programmingblind"<programmingblind@xxxxxxxxxxxxx> Sent: Friday, October 22, 2010 6:38 PMSubject: integrating sql with my software application: a little urgent,please Hi guys, i am in need of a help urgently, please help me as quick as you can, I’ll be very thankful. I have developed an application using c# as front end and sql server 2005 as backend. Its working perfect and everything done now. Now I need to give the application to a client for who this windows based application has been developed. The problem is, that I’m not able to find how can I add the database in my application installer?I am aware of setup and deployment feature of vs.net and have used it once, but that was an application without database, so had no problemin doing it. Its as simple as it: My application simply stores some inputs given by users and displays it when needed.The database therefore is extensively needed, which is located in sqlserver at present. Obviously I won’t install the full sql server package to client’s computer, so how should I do it then? Also, my connection strings are of those specified according to my computer, how can I assure it to work on client’s computer? All that I’m looking for is a setup that can install my application with sql, which can assure the program to work successfully.Please, it’s a little urgent, as I need to supply the application rightaway Hoping for a quick help, sorry for the troubles. Regards, Sameer! __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind__________ View the list's information and change your settings at //www.freelists.org/list/programmingblind __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind__________ View the list's information and change your settings at //www.freelists.org/list/programmingblind-- Kerneels Roos Cell: +27 (0)82 309 1998 Skype: cornelis.roos "Common Sense" is not "Common Practice" . "The Strawberry Jam Law: The wider you spread it, the thinner it gets..." -- from the Java Specialist Newsletter, from a book on consulting. __________View the list's information and change your settings at //www.freelists.org/list/programmingblind__________View the list's information and change your settings at //www.freelists.org/list/programmingblind-- Kerneels Roos Cell: +27 (0)82 309 1998 Skype: cornelis.roos "Common Sense" is not "Common Practice" . "The Strawberry Jam Law: The wider you spread it, the thinner it gets..." -- from the Java Specialist Newsletter, from a book on consulting. __________View the list's information and change your settings at //www.freelists.org/list/programmingblind
__________View the list's information and change your settings at //www.freelists.org/list/programmingblind