how to create .exe with database in visual studio 2008 which can be executed on any system

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

Hello Everybody

ASM

I have also added the following connection string in my config file, but still there is error

add name="cn" connectionString="Data Source=AMAN;Initial Catalog=HOSTSDB;User ID=SA;Password=1234
add name="FBTS.Properties.Settings.HOSTSDBConnectionString" connectionstring="Data Source=.;AttachDbFilename=C:\FBTS\FBTS\DB\HOSTSDB.mdf;Initial Catalog=HOSTS;Integrated Security=True" providername="System.Data.SqlClient"

add name="cn" connectionstring="Data Source=AMAN;Initial Catalog=HOSTSDB;User ID=SA;Password=1234"

Pls help me how to run my exe on other computer

Posted 17-Apr-13 19:00pm

Aman4.net

Add a Solution

3 solutions

Solution 1

Read this : http://www.connectionstrings.com/sql-server-2008[^]

Posted 17-Apr-13 19:03pm

Mehdi Gholam

Comments

Aman4.net 18-Apr-13 2:02am

SIR ACTUALLY THE PROBLEM IS THAT I HAVE ALREADY DATABASE IN MY PROJECT. I WANT TO USE THAT DATABASE. WHEN I CREATE THE .EXE FILE THAT CAN BE INSTALLED ON ANY COMPUTER , AND THAT EXE WILL WORK WITH DATABASE. I HAVE INSTALLED DATABASE IN THE CLIENTS MACHINE. NOW WHEN I INSTALL THAT EXE , IT SHOWS DATA BASE ERROR. BUT WHEN I INSTALL THE SAME EXE ON MY COMPUTER ON WHICH I HAVE CREATED THATEXE IT WORKS FINE,.
SO PLS TELL ME HOW TO MAKE IT WORK ON ANY PC...
THANKS

Mehdi Gholam 18-Apr-13 3:14am

Obviously your connection string is wrong, see he link and it will help you.

Mycroft Holmes 18-Apr-13 2:09am

Oops and you got shouted at hah hah!

Aman4.net 18-Apr-13 2:12am

CAN U HELP ME @ MYCROFT HOLMES

Mycroft Holmes 18-Apr-13 2:15am

Certainly not, I refuse to help anyone who shouts and uses txt speak. Learn to be polite and use the keyboard! Besides Karthik has given you an excellent link by the looks of it

Aman4.net 18-Apr-13 2:32am

okkk as u wish, if u cant help any 1, then i dnt need ur help.

Solution 2

Hi,

take look at the below article.
Walkthrough: Using a Custom Action to Create a Database at Installation [^]

hope it helps.

Posted 17-Apr-13 19:05pm

Karthik Harve

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)

Aman4.net · Accepted Answer · 2013-07-01T01:24:00

Solution 3

I created and new form and put a text box in it. We have to insert server name in that text box,
once we click the submit button, it update the connection string in config file, once changed it will executed on any machine.

Thanks all for your support.

Posted 1-Jul-13 1:24am

Aman4.net

Updated 1-Jul-13 1:25am

v2