Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Database Error (550)

Author  Topic 

ggalus
Starting Member

4 Posts

Posted - 2013-04-03 : 18:48:03
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
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-04-04 : 00:37:35
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
Go to Top of Page

ggalus
Starting Member

4 Posts

Posted - 2013-04-04 : 13:54:01
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

5072 Posts

Posted - 2013-04-04 : 14:02:00
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 - 2013-04-05 : 11:56:12
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
   

- Advertisement -