How to make sql database enabled setup in c# windows application in vs 2010

Question

0.00/5 (No votes)

See more:

I have completed an inventory system for a client. In it's connection string I am using my computer/server name like
Data Source=arvind-PC\arvind
Initial Catalog=INVENTORY
Integrated Security=true
Installer is working properly on my computer but not working on client computer.
Is there any other process for connection string for client computer. I am using VS 2010, SQL Server 2008 R2, windows 7. Please help me

What I have tried:

my computer/server name like
Data Source=arvind-PC\arvind;Initial Catalog=INVENTORY;Integrated Security=true
arvind-PC is my computer name.

Posted 28-Feb-16 20:49pm

arvindispra

Updated 28-Feb-16 22:52pm

Add a Solution

Comments

dan!sh 29-Feb-16 2:59am

Will the database be on client systems?

arvindispra 29-Feb-16 3:14am

I have already added database in my setup. I make a folder name DB and added INVENTORY.mdb file at the time of making setup project. Is it wrong way?
Is it necessary to install sql server and INVENTORY.mdb on client machine?
Thank you

dan!sh 29-Feb-16 3:18am

MDB? Are you talking about access or MS SQL?

arvindispra 29-Feb-16 4:10am

MS SQL

dan!sh 29-Feb-16 4:17am

So, that should be MDF file. Right?

arvindispra 29-Feb-16 4:34am

yes, actually me and my client's computer name is not same thats why is showing an error on a message box. Like arvind-PC\arvind not found

dan!sh 29-Feb-16 4:39am

Step back before getting into this error.

Your setup needs to install SQLExpress on client systems. Your connection strings should use AttachFileName to attach the MDF file. Instead of giving computer name, it should be .\\SQLExpress.

arvindispra 29-Feb-16 4:53am

thanks I am trying, But how is it possible to install SQL Express on all the systems who want to use my inventory system? By the way SQL Express is a large software. No one would be install SQL before installation of my setup. Is there any other method by which any one can download my inventory system setup and install their computer easily?

dan!sh 29-Feb-16 4:55am

Your set up file should do this. SQL express edition is not large.

arvindispra 29-Feb-16 5:09am

ok sir thank you very much

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pankaj_Verma · Accepted Answer · 2016-02-28T22:52:00

If you are trying to get your DB table's data in client application then the SQL server or a client installed SQL server edition is required to install on client's system to access data using .mdb file.
--or--
Use a client-server infrastructure where client can connect to your SQL server via LAN. In this case server name would be in "System_IP/DB_Name" format.

And in client application connection string should be as below

C#

string constr="Data Source=<server_name>; Initial Catalog=<db_name>; User Id=<login_name>; Password=<password>";

And if SQL server is configured using windows authentication in place of User Id and Password use

C#

Integrated Security=true;