User-1825059547 posted
I am new at using Visual Web Developer Express (C#). I understand how to create a website and to test it on my local computer, but I am having trouble understanding what is needed for to publish to website.
1. I have a test website called
www.weddingdayplanner.net that I am using to test my VWD website. It is being hosted by
www.1and1.net . I it a business package with one SQL database included. The business package supports ASP.NET 2 but does not offer direct support for VWD Expresses templates (Personal or Club, etc...). My
first question is? Can I use www.1and1.net to publish my VWD website or should I look for a provider that offers direct support for VWD templates?
2. I have uploaded my webpages to the
www.weddingdayplanner.net for testing, and I have uploaded the aspnetdb.mdf to the db_database folder. I get the following error message.
Line 10: </connectionStrings>-->
Line 11:
Line 12: <connectionStrings>
Line 13: <add name="LocalSqlServer" connectionString="data source='mssql08.1and1.com';User ID='dboxxxxxxxxx';Password=xxxxxxxxx;database='zzzzzzzzz'" />
Line 14: </connectionStrings>
|
The following is my web.config file.
<?xml
version="1.0"
encoding="utf-8"?>
<configuration
xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<system.web>
<customErrors
mode="Off"/>
<!--<connectionStrings>
<add name="LocalSqlServer"
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
providerName="System.Data.SqlClient"/>
</connectionStrings>-->
<connectionStrings>
<add
name="LocalSqlServer"
connectionString="data source='mssql08.1and1.com';User ID='dboxxxxxxxxx';Password=xxxxxxxxx;database='dbxxxxxxxxx'"
/>
</connectionStrings>
<roleManager
enabled="true" />
<authentication
mode="Forms" />
<membership>
<providers>
<remove
name="AspNetSqlMembershipProvider"/>
<add
name="AspNetSqlMembershipProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="LocalSqlServer"
minRequiredPasswordLength="7"
minRequiredNonalphanumericCharacters="0"
passwordStrengthRegularExpression=""/>
</
providers>
</
membership>
</
system.web>
</
configuration>
____________________________________________
1and1.net offers the following inforamtion for connecting to a SQL database.
2.2 Accessing Your MS SQL Database Using ASP.NET
(This option is not supported for all packages.)
Log in to the 1&1 Control Panel, and on the My Account page choose the package you
would like to work on by clicking on it. This will bring you to the Package Administration
page. There, go to
'Applications' > 'MS SQL Administration'
and retrieve the following
access data:
database name
user name
host name
password.
Make a note of this information. Use the following script to connect to your SQL database
and query a table.
<%@ Page Language="VB" %>
<script runat="server">
Sub Page_Data
Dim oDR as System.Data.SQLClient.SQLDataReader
Dim oCom As System.Data.SQLClient.SqlCommand
Dim oConn as System.Data.SQLClient.SQLConnection
try
oConn = New System.Data.SQLClient.SQLConnection
("server=mssqlxxx.1and1.com; initial
catalog=dbxxxxxxxxx;uid=dboxxxxxxxxx;pwd=xxxxxxxx")
oConn.Open()
oCom = New System.Data.SQLClient.SqlCommand()
oCom.Connection = oConn
oCom.CommandText = "SELECT * FROM products"
oDR = oCom.ExecuteReader()
While oDR.Read
Response.Write(oDR.Item("id") & ", " &
oDR.Item("price"))
Response.Write("<BR/>")
End While
114
Windows
®
Hosting Manual, 1&1 Internet Inc.
MICROSOFT® DATABASES: MICROSOFT® SQL SERVER
catch
Response.Write("Error:" & err.Description)
Finally
oDR = Nothing
oCom = Nothing
oConn.Close()
oConn = Nothing
end try
End Sub
</script>
<html>
<title>Queries from the MS-SQL database with ASP</title>
<body bgcolor="FFFFFF">
<h2>Query from table <b>products</b> with ASP.NET</h2>
<%Page_Data()%>
</body>
</html>
Highlighted code contains crucial information:
server
is the hostname.
initial catalog
is the database name.
uid
is the user name.
pwd
is the password.
_________________________________
Any help would be appreciated.
Rick
