Need help!! Sql server database file doesn't run on an another pc.

Question

0.00/5 (No votes)

See more:

My Vb.net project with database1.mdf file as database runs on the computers where sql server is installed but it shows error on the pc(s) where sql server is not installed. Please somebody help me with brief description and solution about this problem.

Posted 21-Jan-13 6:12am

suhan 2012

Add a Solution

Comments

Richard C Bishop 21-Jan-13 12:14pm

Are you using a connection string to a sql server?

2 solutions

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)

Sandeep Mewara · Answer 1 · 2013-01-21T06:16:00

database1.mdf file as database runs on the computers where sql server is installed but it shows error on the pc(s) where sql server is not installed
MDF will need client to work. While deploying your application, see if the database client is present or not. If not, you need to install the same if that is required for you application. Here, you might need to install SQL Express along with application and database.

Have a look at these:
Creating setup With support for database creation Using VS.NET[^]
Create database during installation of a .NET application [^]
Deploy your Application and Database[^]

Thomas Daniels · Answer 2 · 2013-01-21T06:20:00

suhan 2012 wrote:
where sql server is not installed

It's necessary that SQL Server is installed, otherwise you can't connect you to it. Actually, you can't create a connection to a MDF file, you need to connect to SQL Server, and if you execute an SQL query, SQL Server modifies the data file. The file contains the data, and SQL Server can read/write to it. It's necessary to install SQL Server.

Need help!! Sql server database file doesn't run on an another pc.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0