SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Database Error (550)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ggalus
Starting Member

4 Posts

Posted - 04/03/2013 :  18:48:03  Show Profile  Reply with Quote
I am new to using MS Server. I have recently been passed along a database driven site to work on. I am working on it using Visual Web Developer 2010. For the past the past couple days, I have been able to successfully update pages on the site using T-SQL update queries. Earlier today I attempted to update a contact page with such a query. Here is the query. Please excuse the bloated html code, I did not write it. The site is rather old and I have been asked to update parts of it.

UPDATE TPAGES
SET MMESSAGE = '<div style="margin:10;"><a href="https://www.facebook.com/#!/pages/The-American-Scholar-Group/431279676945134?fref=ts"><img src="/uploads/images/facebook.jpg" style="float:left;"><p style="color:#086acb; font-size: 14px; margin-left:14px; font-fammily: Arial;">Find Us On Facebook</p></a><div>

<h1><span style="font-family: Times New Roman; color: #000000; font-size: 14pt"><strong>The American Scholar, Ltd. - Corporate</strong></span><span style="font-family: Times New Roman; font-size: 14pt"> </span></h1>
<div>
<div><span style="font-family: Times New Roman; font-size: 12pt">160 Main Street</span></div></div>
<p style="font-family: Times New Roman; font-size: 12pt">Greenville, Pennsylvania 16125</p>
<p style="font-family: Times New Roman; font-size: 12pt">United States of America</p>
<div style="margin: 0in 0in 0pt">
<div><span style="font-family: Times New Roman; font-size: 14pt"><strong>American Scholar University School</strong> </span></div></div>
<p style="font-family: Times New Roman; font-size: 12pt">160 Main Street</p>
<p style="font-family: Times New Roman; font-size: 12pt">Greenville, Pennsylvania 16125</p>
<p style="font-family: Times New Roman; font-size: 12pt">United States of America</p>

<div><span style="font-family: Times New Roman; font-size: 14pt"><strong>American Scholar Leadership Institute</strong> </span></div></div>
<p style="font-family: Times New Roman; font-size: 12pt">160 Main Street</p>
<p style="font-family: Times New Roman; font-size: 12pt">Greenville, Pennsylvania 16125</p>
<p style="font-family: Times New Roman; font-size: 12pt">United States of America</p>
<div style="font-family: Times New Roman; font-size: 14pt"><strong>American Scholar at Emmanuel Court </strong></span></div>
<p style="font-family: Times New Roman; font-size: 12pt">15 Leech Road</p>
<p style="font-family: Times New Roman; font-size: 12pt">Greenville, Pennsylvania 16125</p>
<p style="style="font-family: Times New Roman; font-size: 12pt">United States of America</p>
<div style="margin: 0in 0in 0pt"><br /><span style="font-family: Times New Roman; font-size: 14pt"><strong>American Scholar at Constitution Square</strong> </span></div>
<p style="font-family: Times New Roman; font-size: 12pt">24 Leech Road</p>
<p style="font-family: Times New Roman; font-size: 12pt">Greenville, Pennsylvania 16125</p>
<p style="font-family: Times New Roman; font-size: 12pt">United States of America</p>
<p style="margin: 0in 0in 0pt"> </p>
<p style="font-family: Times New Roman; color: ; font-size: 14pt"><strong>Email:</strong>                               <a href="#109;#97;#105;#108;#116;#111;#58;#105;#110;#102;#111;#64;#97;#109;#101;#114;#105;#99;#97;#110;#45;#115;#99;#104;#111;#108;#97;#114;#46;#111;#114;#103;"><span style="font-family: Times New Roman; font-size: 12pt">info@american-scholar.org</span></a> </p>
<p style="font-family: Times New Roman; color: ; font-size: 14pt"><strong>Phone:</strong>                              <span style="font-family: Times New Roman; font-size: 12pt">724.885.1136</span>      </p>
<p style="font-family: Times New Roman; color: ; font-size: 14pt"><strong>Fax:</strong>                                    <span style="font-family: Times New Roman; font-size: 12pt">724.638.5370</span></p>'

WHERE (MTITLE = Contact Us - Main')


After running the query, I closed Visual Web Developer which in the past has updated the database and the site when closed out. Today, after doing this, it apparently did not upload correctly and now the live site is showing an error page. Here is a link, http://www.american-scholar.org/. Now when I try to save the site, it will not allow me to update the .mdf file. I get this warning, "Cannot save the file 'App_Data/SiteData.mdf' to the web server. Can't access file (550)." Can anyone help on what may be causing this error? Or how I can fix it? I appreciate any help. Thanks.

bandi
Flowing Fount of Yak Knowledge

India
2210 Posts

Posted - 04/04/2013 :  00:37:35  Show Profile  Reply with Quote
Error Reason:
http://stackoverflow.com/questions/1655104/upload-file-via-ftp-server-returned-error-550-file-is-unavailable-cannot-fi
http://social.msdn.microsoft.com/Forums/en-US/ncl/thread/322b9ae9-0d0c-4e78-9be2-c3103e34ce5f/
For resolution, http://kb.globalscape.com/KnowledgebaseArticle10305.aspx

Edited by - bandi on 04/04/2013 00:38:44
Go to Top of Page

ggalus
Starting Member

4 Posts

Posted - 04/04/2013 :  13:54:01  Show Profile  Reply with Quote
Thanks bandi for the reply and the links. I contacted the hosting provider and they said the database was "locked." As I am very new to using the microsoft server and the Visual Web Developer software, is there something that I may have done to cause the server to database to lock? I have searched this topic without getting a real clear cut answers. I have seen other forum posts with a similar problem. Are there any common errors made by a developer that may cause a database to lock? I appreciate the help.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 04/04/2013 :  14:02:00  Show Profile  Visit russell's Homepage  Reply with Quote
There's no such thing really -- not in the context that they are telling you.

They may have been performing some sort of maintenance or something.

Doubt very much that you did anything to cause it.

Sure you're using MS SQL Server?
Go to Top of Page

ggalus
Starting Member

4 Posts

Posted - 04/05/2013 :  11:56:12  Show Profile  Reply with Quote
Thanks for the reply Russell. I'm pretty sure it's MS SQL Server. The site is built using asp.net and visual basic. It is likely a rather dated version. I could not even edit the site using visual studio 2012 for web. The database is an .mdf file. That would be MS SQL Server right? Thanks again.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000