Hi Jeremy, - I follow the instruction and it all started to work after my provider eventually let the server know my username and password. I then had to play around with my Web.config a few times but eventually go that to work but when publishing the database "personal" i get an error as follows.
Database Publishing Progress
- Gathering list of objects to script (Success)
- Connecting to web service (Success)
- Scripting objects (Success)
- Creating table dbo.Photos (Error)
Messages
* Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>
<p>
<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
</span></p>
<p>
<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.
</p>
</body>
</html>
--. (System.Web.Services)
and on the website the error
Could not find stored procedure 'GetNonEmptyAlbums'.
Description: An
unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the
error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'GetNonEmptyAlbums'.
Source Error:
Line 196: connection.Open()
Line 197: Dim list As New Generic.List(Of Album)()
Line 198: Using reader As SqlDataReader = command.ExecuteReader
Line 199: Do While reader.Read
Line 200: Dim temp As New Album(CType(reader("AlbumID"), Integer), 0, "", False)
|
Source File: \\WEBSHARE4\Webshare4\Users\markeu\webroot\App_Code\PhotoManager.vb Line: 198