<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://forums.asp.net/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Small Business Starter Kit</title><link>http://forums.asp.net/1092.aspx</link><description>Discussions about the Small Business Starter Kit for ASP.NET 2.0.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP1 (Build: 20510.895)</generator><item><title>Re: question regarding proper setup pf the web.config file</title><link>http://forums.asp.net/thread/2335257.aspx</link><pubDate>Sat, 03 May 2008 04:45:01 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:2335257</guid><dc:creator>jhar</dc:creator><slash:comments>0</slash:comments><comments>http://forums.asp.net/thread/2335257.aspx</comments><wfw:commentRss>http://forums.asp.net/commentrss.aspx?SectionID=1092&amp;PostID=2335257</wfw:commentRss><description>&lt;p&gt;Try..&lt;/p&gt;
&lt;p&gt;&amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;remove name=&amp;quot;LocalSqlServer&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add name&lt;strong&gt;=&amp;quot;LocalSqlServer&amp;quot;&lt;/strong&gt; connectionString=&amp;quot;Data Source=[IP Address of remote sql server here],1433; &lt;br /&gt;Network Library=DBMSSOCN;Initial Catalog=(db name here);User ID=xxxxxx;Password=xxxxxxxx;&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&lt;/p&gt;
&lt;p&gt;Hopefully that should get you up and running&lt;/p&gt;</description></item><item><title>Re: question regarding proper setup pf the web.config file</title><link>http://forums.asp.net/thread/2305868.aspx</link><pubDate>Fri, 18 Apr 2008 05:13:59 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:2305868</guid><dc:creator>sprakashcs</dc:creator><slash:comments>0</slash:comments><comments>http://forums.asp.net/thread/2305868.aspx</comments><wfw:commentRss>http://forums.asp.net/commentrss.aspx?SectionID=1092&amp;PostID=2305868</wfw:commentRss><description>&lt;p&gt;&amp;nbsp;Hai friend i have read your mesage,&lt;br /&gt;to use connectionstring in web.config..&lt;br /&gt;&amp;nbsp;&amp;lt;configuration&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add connectionString=&amp;quot;Server=server name;Database=databasename;uid=user id;pwd=password;&amp;quot; name=&amp;quot;ConStr&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&amp;nbsp;&amp;nbsp;  &lt;br /&gt;&amp;lt;/configuration&amp;gt; &lt;br /&gt;&lt;/p&gt;&lt;p&gt;To call the connection string to our page&lt;br /&gt;SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[&amp;quot;ConStr&amp;quot;].ToString());&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;br /&gt;I think it may useful to you..&lt;br /&gt;If still you have doubt reply me.&amp;nbsp; &amp;nbsp;&lt;/p&gt;&lt;p&gt;visit this link for further clarification&amp;nbsp;&lt;/p&gt;&lt;p&gt;&amp;nbsp;http://foraspdotnetdevelopers.blogspot.com/&lt;/p&gt;</description></item><item><title>question regarding proper setup pf the web.config file</title><link>http://forums.asp.net/thread/2305609.aspx</link><pubDate>Fri, 18 Apr 2008 01:17:57 GMT</pubDate><guid isPermaLink="false">4c671506-2930-414c-a40b-8bf57ded5924:2305609</guid><dc:creator>christly</dc:creator><slash:comments>0</slash:comments><comments>http://forums.asp.net/thread/2305609.aspx</comments><wfw:commentRss>http://forums.asp.net/commentrss.aspx?SectionID=1092&amp;PostID=2305609</wfw:commentRss><description>&lt;p&gt;I am pretty much a newbie and I am not totally familiar with the proper setup of the &lt;strong&gt;web.config&lt;/strong&gt; file for the SBSK. My web host uses SQL 2000, so I found the post on this forum where someone shared the script to create the database on SQL 2000 instead of the built in SQL 2005 Express - and that seeemd to work fine. I am now trying to mody the &lt;strong&gt;web.config&lt;/strong&gt; file to connect to that database properly. Here is what I have so far:&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&amp;lt;connectionStrings&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;remove name=&amp;quot;LocalSqlServer&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;add name=&amp;quot;MyConnectionString&amp;quot; connectionString=&amp;quot;Data Source=[IP Address of remote sql server here],1433; &lt;br /&gt;Network Library=DBMSSOCN;Initial Catalog=(db name here);User ID=xxxxxx;Password=xxxxxxxx;&amp;quot;/&amp;gt;&lt;br /&gt;&amp;nbsp; &amp;lt;/connectionStrings&amp;gt;&lt;/p&gt;
&lt;p&gt;I blanked out&amp;nbsp;the IP Address of the remote SQL server (but I have verified that I can conect to it fine), as well as the user ID, password, and database name. &lt;/p&gt;
&lt;p&gt;I am thinking I have something misconfigured - such as the NetworkLibrary&amp;nbsp;value, or maybe it is something else. Any help from the forum is appreciated.&lt;/p&gt;
&lt;p&gt;-John&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;
&lt;p&gt;&amp;nbsp;&lt;/p&gt;</description></item></channel></rss>