Re: integrating sql with my software application: a little urgent, please

  • From: "black ares" <matematicianu2003@xxxxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Sat, 23 Oct 2010 07:06:39 +0300

hello,
This is another example of how the things go if you don't adapt the technology to your project. For your application you don't need a beast such SQLServer which is an enterprise server and, for this reason, needs to be installed, configured and administered by a technical person on the production machine. For your project best suited should be microsoft access .mdb file which caries the database engin inside and all you need to install if not already present is the mdac library which can be installed as a prerequisite of setup in dotnet. 
Or another embeded sql library such sql lite, hsql, derby.
Second, this is how it happens when you don't well architecture your application to be able to run on any database platform. How ever, for your case, the third solution presented by me remains the solution, 
but you must install and configure sqlserver express on the target machine.
After this, you can attach that file.
the attachment of the database file is made in the connection string where you must say someting like this: 
data source=instance name;
attachdbfilename=path_to_file;
initial catalog=dbname;
user=user;
pwd=password;

And so on.
----- Original Message ----- From: "sameer manohtra" <sameermanohtra@xxxxxxxxx> 
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Saturday, October 23, 2010 4:41 AM
Subject: Re: integrating sql with my software application: a little urgent, please 


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 even
have ui elements.
So you must create an window and an installer class, get from the user the
data necesary to connect to sql server and create all the database and
populate the database.
For this you simply need a script which you can generate using your sql
server 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 and
when 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 the user necesary data to build the connection string, you can attach the database to 
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 PM
Subject: 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 problem
in 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 sql
server 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 right away 
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

Other related posts:

  1. Home
  2. programmingblind
  3. Archive
  4. 10-2010