how to set good connection string app vb.net with sql database

Question

0.00/5 (No votes)

See more:

Hi I have app programed by vb.net 2010 with sql server database file (mdf) I want to share this app so that when user click on Icon app work and run
my connection string is

"Data Source=.\myservername;Initial Catalog=mydatabase name;Persist Security Info=True;User ID=sa;Password=mypass"

my question is that : is this connection string work or not . in my pc this work . should i change any thing ?

Posted 2-Sep-15 4:34am

rezaeti

Updated 2-Sep-15 4:59am

phil.o

v2

Add a Solution

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)

F-ES Sitecore · Accepted Answer · 2015-09-02T04:44:00

Solution 1

That will work on your machine if your SQL instance is called "myservername" as "." means your local machine so ".\myservername" means the SQL instance called "myservername" on this machine. It won't work on other machines as the code will look for SQL on their machine rather than yours. The datasource needs updated to have the name of your machine as seen by others, or your IP address if you have a fixed one. So

Data source=machinename\instancename

If the SQL instance isn't called "myservername" but you mean to replace myservername with the name of your machine, then that's not going to work. If your SQL has no specific instance name then just use

data source=myservername

Edit: The above assumes you are looking to keep the database on your machine and others will connect to it, if that's not the case update your question to supply more info.

Posted 2-Sep-15 4:44am

F-ES Sitecore

Updated 2-Sep-15 5:11am

v2

Comments

rezaeti 2-Sep-15 10:53am

by the way i have code that write and read xml file to create dynamic connection string that replace txt.servername.text with myservername and so on

F-ES Sitecore 2-Sep-15 11:08am

There is no need, using the fully qualified machine name will work on your machine as well.

rezaeti 2-Sep-15 11:35am

is this connection work for any windows for example windows 8 or 7 or xp or ...?
and is this connection work for 64 bit and 32 bit ?
does it matter the type of sharing for example local or net or LAN or any thing else?

F-ES Sitecore 2-Sep-15 11:39am

It'll work on anything, and it will work across any network as long as the server name use you can be used by the client machine. So if you're on a lan and someone else is on the same lan they will be able to resolve your name ok. If two machines are connected via the internet then local lan names won't translate so you'll need an IP address or a name that translates via DNS like sql.yourdomain.com

rezaeti 2-Sep-15 11:54am

excuse me ths is last question :
when I install app on another pc this error display :
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
I search on internet about this error and I found this error is related to stoping sql express on another pc
I install sql express on it but sql exoress is not runing and my tring for runinig it was not successful
what i do ?

F-ES Sitecore 3-Sep-15 3:57am

This usually happens when that machine can't connect to the machine named in the connection string. If you're sure the SQL instance is running (ie the app works when on the same machine) then either the non-working machine can't resolve the name, or there might be a firewall blocking the port that sql uses, or the target server might be configured to not allow remote connections.

rezaeti 2-Sep-15 11:56am

by the way in my pc when I stop sql express app work yet