Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best DB To Use
Message
From
20/02/2010 09:34:58
 
 
General information
Forum:
ASP.NET
Category:
Databases
Title:
Miscellaneous
Thread ID:
01448575
Message ID:
01450048
Views:
44
>>>>To everyone who responsed to this....
>>>>
>>>>I have spent the last 2 weeks creating tables and writing scripts in SQL to support a small C# WinForms contact management
>>>>application a client hired me to write.
>>>>
>>>>I posted this thread because I thought that 1) SQL was overkill, and 2) every time I have tried to install any version of SQL there
>>>>are failures.
>>>>
>>>>Sure enough I went to my client's office at lunch to install SQL and the app. The SQL installation failed. This is the reason:
>>>>http://support.microsoft.com/kb/968749
>>>>
>>>>Notice the "workaround". Notice that to fix this I will have to download, install, and run some other tool, and then hope that this
>>>>will be all of it.
>>>>
>>>>This is exactly why I didn't want to go with SQL, or any other server based DB. Had I gone with VFP or Access, my client would
>>>>be using his software right now.
>>>>
>>>>Now some of you will inevitably say, have him do this, or ask him to install that... This guy is an Allstate insurance agent with the
>>>>computer literacy of my 7 year old. He expects me, rightfully so, to show up, push a few buttons, and voila! - instant software.
>>>>
>>>>Al have always held to the rule of using the right tool for the job. SQL was not the right too for this job.
>>>
>>>Well I *did* suggest the CE version. No install issues with that......
>>
>>And didn't we suggest SQL EXpress 2008?
>
>May have been better than 2005. But, given Kevins description of the application and the context in which it would be used, I still think CE would have been a better option. Does anyone disagree...... ??
>
>>And if a developer says "every time I have tried to install any version of SQL there
>>are failures." I would be tempted to look for the one constant in the equation <bg>
>
>LOL - but that done, it is not a trivial task to put together a DVD that will install SQL Express and an application, hand it to a computer illiterate punter and expect the whole think to install seamlessly. And if the end-user is already using SQL Express (or any other version of MS SQL) you either have to install another instance (which the end user probably won't want) or add the neccessary database/s on the existing instance. etc. etc.....

That's why given the original description of the end-user my first suggest was to just install Logmein and then install the SQL EXpress or whatever is necessary for him. If I had to do it for a lot of people it would probably be more time-efficient to create an install DVD for for this one guy I'd just remote in and do it and know it had been done the way I wanted it.


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Reply
Map
View

Click here to load this message in the networking platform