Sql server - how to make my app work on other computer

Question

0.00/5 (No votes)

See more:

SQL-Server-2016

<pre lang="c#">        static string domain = (AppDomain.CurrentDomain.BaseDirectory).ToString();
        internal static string connect = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename= "+domain+"BMS_PRO_DB.mdf;" + "Integrated Security=True;Connect Timeout=30;";

the database is inside the app's location,
i think my connection is wrong thats why the app is working fine on my server but on the other PC(SQL Server is installed in this pc too) its not working.

What I have tried:

please help, im getting the error : sql not found or not accessible ...

Posted 28-Dec-17 4:26am

Member 13116441

Updated 28-Dec-17 21:38pm

Add a Solution

4 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)

Dave Kreskowiak · Answer 1 · 2017-12-28T04:54:00

One word: DEBUGGER. Learn to use it and it'll become obvious what you did wrong.

You're doing some goofy things and not account for spaces in the path you generated.

For example, why are you calling .ToString() on a string returned by BaseDirectory? That's just ....

The connection string should be stored in the config file, not as a hardcoded value in your code. What if the user doesn't what to use LocalDB and instead has either SQL Server Express or a full SQL Server somewhere? They can't use your code because it's too inflexible.

Also, the code is (hopefully!) going to be running from somewhere under C:\Program Files. Program Files, and everything under it, is READ ONLY. That's not the place you want to be putting your database. I suggest placing it somewhere more appropriate, like in a folder under ProgramData, where normal users have write permissions.

ZurdoDev · Answer 2 · 2017-12-28T04:54:00

Solution 2

Yes, your connection is wrong. When the code runs on the other computer it will try to access a sql server at (LocalDB) so if the local computer does not have sql, it will not work. Change it to the name of the sqlserver machine or ip address so it can connect.

Posted 28-Dec-17 4:54am

ZurdoDev

Member 13116441 · Answer 3 · 2017-12-28T19:26:00

Solution 3

HappyFestivus, give me an example , also tell me that , do i need to get the code of machine on which app is running, i dont get that.

Posted 28-Dec-17 19:26pm

Member 13116441

Comments

Patrice T 29-Dec-17 3:40am

Do not use a solution to discuss with someone else.
Use 'Have a Question or Comment?' button instead, advantage, the OP is noticed.

Patrice T · Answer 4 · 2017-12-28T21:38:00

Quote:
do i need to get the code of machine on which app is running, i dont get that.

Looks like you need to learn the basics of SQL.

You need to install an SQL engine and your database on a server in your network.
Then change your app to refer to the database.
Internet is loaded with examples and tutorials, you just have to do a little search.

Sql server - how to make my app work on other computer

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0