?
Solved

Connection string in VB.NET

Posted on 2009-12-21
9
Medium Priority
?
423 Views
Last Modified: 2012-05-08
I have the following sql connection in the webconfig file and I want to know why they use 6100 for . Moreover, If I want to work on a local copy of the same database (in sql server2005), how can I modify the connection string.  lets say that the local copy is at a server with a name: MM123\SQLEXPRESS , and let the database name be TR
<add name="XXX" connectionString="Data Source=RTE.BBHC.YYRP.COM,6100;Initial Catalog=XXX;User ID=DDD; Password=VVV" providerName="System.Data.SqlClient"/>
0
Comment
Question by:AbebeDemeke
  • 6
  • 2
9 Comments
 
LVL 21

Accepted Solution

by:
silemone earned 1000 total points
ID: 26096761
0
 
LVL 21

Expert Comment

by:silemone
ID: 26096772
the link i supplied is what I always use and never fails, plus its informative about connectionstrings...it has (ms)sql 2005 as an option and its a great site that you will forever need.  usually just copying and pasting their connection strings work.
0
 

Author Comment

by:AbebeDemeke
ID: 26096786
My question deserves more than sending a link man
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 21

Expert Comment

by:silemone
ID: 26096827
i just gave you the answer to any questions about links you would ever need.  plus, I supplied a comment in my second comment...such as read the link and it will explain to you in full details.
0
 
LVL 21

Expert Comment

by:silemone
ID: 26096831
i just gave you the answer to any questions about connection strings you would ever need answered.  plus, I supplied a comment in my second comment...such as read the link and it will explain to you in full details.  have you opened the link and tried reading it?
0
 
LVL 21

Expert Comment

by:silemone
ID: 26096839
you will be amazed with what that site tells you about connection strings.  then if you had further questions, then I would try to answer them.  
0
 
LVL 9

Expert Comment

by:Seven price
ID: 26097450
maybe you have to put the whole address like.

either the ip or
jason.connection.net
0
 
LVL 9

Assisted Solution

by:Seven price
Seven price earned 1000 total points
ID: 26097458
Looks like a space in there also
0
 
LVL 21

Expert Comment

by:silemone
ID: 26097529
i wanted him to read everything about connectionstrings and then we could puzzle it together if he didn't figure it out.  We can guess almost anything, but we don't know enough about his systems to know the exact answer, so maybe he can figure it out from the indept teachings of the link.  Otherwise, he would have to probably ask his dba...
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Integration Management Part 2
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question