AbebeDemeke
asked on
Connection string in VB.NET
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,6 100;Initia l Catalog=XXX;User ID=DDD; Password=VVV" providerName="System.Data. SqlClient" />
<add name="XXX" connectionString="Data Source=RTE.BBHC.YYRP.COM,6
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
My question deserves more than sending a link man
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.
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?
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.
maybe you have to put the whole address like.
either the ip or
jason.connection.net
either the ip or
jason.connection.net
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...