﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>Re-invent ASP.NET Hosting Community / Web Site Development / Design / SQL 2008/2005/2000 and MS Access Database  / Attaching SQL Express Database / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>Re-invent ASP.NET Hosting Community</description><link>http://community.re-invent.com/</link><webMaster>community@re-invent.com</webMaster><lastBuildDate>Tue, 06 Jan 2009 01:32:16 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Attaching SQL Express Database</title><link>http://community.re-invent.com/Topic444-4-1.aspx</link><description>Thanks Plato, I'll give it a shot when I get home today</description><pubDate>Mon, 04 Dec 2006 15:07:00 GMT</pubDate><dc:creator>dotNetDude</dc:creator></item><item><title>RE: Attaching SQL Express Database</title><link>http://community.re-invent.com/Topic444-4-1.aspx</link><description>&lt;FONT size=1&gt;&lt;P&gt;&lt;FONT size=2&gt;Hello,&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;You may be the same person I'm working with via Support Email.  I'm not sure as I have someone with the same question.  Here is the info:&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;You would need to update your connectionstrings to use the SQL 2005 database rather than the Express and make sure there is no mention of the Express Database strings:&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;Here is an example, you'll need to substitute your own information:&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;&amp;lt;connectionStrings&amp;gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;&amp;lt;add name="MyConnectionDB" connectionString="Data Source=MYSQLSERVER;Integrated Security=false;Initial Catalog=MYDATABASE;User ID=MYUSER;Password=MYPASSWORD" providerName="System.Data.SqlClient"/&amp;gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;&amp;lt;remove name="LocalSqlServer"/&amp;gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;&amp;lt;add name="LocalSqlServer" connectionString="Data Source=MYSQLSERVER;Integrated Security=false;Initial Catalog=MYDATABASE;User ID=MYUSER;Password=MYPASSWORD" providerName="System.Data.SqlClient" /&amp;gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT size=2&gt;&amp;lt;/connectionStrings&amp;gt; &lt;/FONT&gt;&lt;/P&gt;&lt;/FONT&gt;</description><pubDate>Mon, 04 Dec 2006 13:54:00 GMT</pubDate><dc:creator>Re-invent (Plato)</dc:creator></item><item><title>RE: Attaching SQL Express Database</title><link>http://community.re-invent.com/Topic444-4-1.aspx</link><description>Thanks Plato,&lt;br&gt;The database has been attached. How should I modify my connection string to get the Login controls and database working?&lt;br&gt;</description><pubDate>Mon, 04 Dec 2006 13:41:00 GMT</pubDate><dc:creator>dotNetDude</dc:creator></item><item><title>RE: Attaching SQL Express Database</title><link>http://community.re-invent.com/Topic444-4-1.aspx</link><description>&lt;P&gt;Hello!&lt;/P&gt;&lt;P&gt;Yes we do this at no charge, just email support or submit a ticket to our support dept and they will be happy to get that attached for you quickly.&lt;/P&gt;&lt;P&gt;Thanks for choosing Re-invent!&lt;/P&gt;</description><pubDate>Mon, 04 Dec 2006 13:27:00 GMT</pubDate><dc:creator>Re-invent (Plato)</dc:creator></item><item><title>Attaching SQL Express Database</title><link>http://community.re-invent.com/Topic444-4-1.aspx</link><description>&lt;P&gt;Greetings Folks,&lt;/P&gt;&lt;P&gt;I've uploaded my site which includes Login Controls and a SQL Express database.&lt;/P&gt;&lt;P&gt;All of the database files are in the App_Data folder.&lt;/P&gt;&lt;P&gt;How do I get the database attached so Ican use the Login and datbase functions?&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description><pubDate>Sun, 03 Dec 2006 17:27:00 GMT</pubDate><dc:creator>dotNetDude</dc:creator></item></channel></rss>