Tech support from www.1and1.net in the form of any scripting is non-existant. At this point I am looking at hiring an expert in ASP.NET to assist me in getting my website up and running. I believe that I need to see
how it is done by someone else in order to understand the publishing aspect of ASP.NET.
Can I pay you to help me or do you know of someone who is qualified to assist me in setting up my site?
Hope it helps, if not let me know and I will look into testing it on 1and1 account.
Regards
Jeremy
Regards
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
I have emailed them (sectormicro), asking help, no response.
Here are the issues. We can't use the root directory, so there has to be a "redirector" in the root dir. (email and I will send you mine, or any of the code I have tried). Then, the webpage code has to be published to a sub-folder.
Next, we cant do "remote access", so we cant run reg-sql (1and1 support promises that we cant, and they are correct).
To demonstrate that the Database works, they suggest that we go into their admin tools and create a DB Table called "Products" with and "id" and a "price". Then they give the following .ASP to test: (and it works fine) where AAA, BBB, CCC, DDD values are
given by the 1and1 mssql admin tool
<html>
<head>
<title>Queries from the MS-SQL database with ASP</title>
</head>
<body bgcolor="FFFFFF">
<h2>Query from table <b>products</b> with ASP</h2>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=mssqlAA.1and1.com;UID=dboBBBB;PWD=CCCC;DATABASE=dbDDDD"
'This code block will create a recordset
Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "select * from products"
rs.open SQL, conn
'will iterate to display the records got from the database
While Not rs.EOF
response.write(rs("id") & " " & rs("price") & " ")
rs.MoveNext
Wend
'closes the connection
rs.close
conn.close
Set rs = Nothing
Set conn = Nothing
The last thing I tried was "enable frontpage extensions" then publish using VWD, directly to <root>\main and now it acts different than it did, but still doesnt seem to work when I go to
www.cushingshops.com
Thanks for any help. All my code would be available to anyone, if we get this working. Email me for further info, or keys to access my stuff.
Are you having any specific error messages or you just can't get the site running? Do you have control over how your domain redirects or you simply have to get it pointed to a sub folder?
It is true that 1and1 will not allow remote access to MSSQL which is a pain but it easy to work around just make a SQL Create script and run it from the mylittleadmin tool - tools - Query Analyser in the 1and1 admin section. Use aspnet_regsql to make the
script to run Query Analyser.
*****************************************************
I will try this. My question as I begin is:
<div>I need to run aspnet_regsql, and do I run it from my local machine, or do I run it from the server? I am guessing that I can run it, dos-mode, from my machine, specifying server, login-id, password, and the -sqlexportonly <filename> to generate a script.</div>
<div> </div> <div>Do I use the switch to turn all application services as I generate the original script? Do I care about SQL CACHE DEPENDENCY OPTIONS?</div> <div> </div> <div>I then move the script to my 1and1 site, <root>\main (where my website apps are),
and use the 1and1 mylittleadmin tool - tools - Query Analyser to run this script.</div> <div> </div> <div>Is this on the right track?</div> <div>Btw - my redirector script has worked fine, over the last month. I use the same script as Jeremy pointed out:</div>
<div> </div> <div>http://faq.oneandone.co.uk/script_cookbook__databases/asp_net/asp_net_2_0/1.html</div> <div> </div> <div>-Tom
</div>
As for any that are having problems adding data to a database,
You must download microsoft's optional sql express tool, backup your database, put it in the _db_imports folder of your ROOT webspace, then attempt to import it using 1&1's tools.
As for connection to the database, use this code (in vb)
Thanks all, and especially to jeremyh who worked on this over 3 weeks, to get me up and going. As I was putting up the classified-ads starter kit, I will go back to their forum and try to leave a detailed explanation of what it took to get 1and1 to work.
Looking back, the biggest problem was probably the web.config connection string, which ended up being:
I used the 1and1 ms-sql/admin-tool to find the values for xx, yyyyyyyyy, and zzzzzzzz
In a couple of days, I will post my detailed explanation over in the classified-ads forum. If anyone wants me to email source-changes to the stock classified-ads starter kit, let me know.
RichardHite
0 Points
7 Posts
Re: I need Help publishing my website.
Mar 31, 2007 09:18 PM|LINK
Jeff:
Thanks for the reply.
Tech support from www.1and1.net in the form of any scripting is non-existant. At this point I am looking at hiring an expert in ASP.NET to assist me in getting my website up and running. I believe that I need to see how it is done by someone else in order to understand the publishing aspect of ASP.NET.
Can I pay you to help me or do you know of someone who is qualified to assist me in setting up my site?
Rick
erinevance
Member
20 Points
9 Posts
Re: I need Help Getting publishing my website.
Apr 03, 2007 03:19 PM|LINK
.NET 2.0 personal web site host hosting ISP deploy copy configure starter kit on produciton server
jeremyh
Star
8173 Points
1477 Posts
Re: I need Help Getting publishing my website.
Apr 19, 2007 01:31 PM|LINK
Deploy starter kit to remote host
http://www.edream.org/BlogArticle.aspx?RecordID=115
Hope it helps, if not let me know and I will look into testing it on 1and1 account.
Regards
Jeremy
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
TomT
Member
15 Points
16 Posts
Re: I need Help Getting publishing my website.
Apr 19, 2007 03:46 PM|LINK
Please, please, please. Help with 1and1. I have been trying for about a month. 1and1 tech support suggests looking at following website:
http://www.sectormicro.com/sector-micro/home/default.aspx
I have emailed them (sectormicro), asking help, no response.
Here are the issues. We can't use the root directory, so there has to be a "redirector" in the root dir. (email and I will send you mine, or any of the code I have tried). Then, the webpage code has to be published to a sub-folder.
Next, we cant do "remote access", so we cant run reg-sql (1and1 support promises that we cant, and they are correct).
To demonstrate that the Database works, they suggest that we go into their admin tools and create a DB Table called "Products" with and "id" and a "price". Then they give the following .ASP to test: (and it works fine) where AAA, BBB, CCC, DDD values are given by the 1and1 mssql admin tool
<html>
<head>
<title>Queries from the MS-SQL database with ASP</title>
</head>
<body bgcolor="FFFFFF">
<h2>Query from table <b>products</b> with ASP</h2>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=mssqlAA.1and1.com;UID=dboBBBB;PWD=CCCC;DATABASE=dbDDDD"
'This code block will create a recordset
Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "select * from products"
rs.open SQL, conn
'will iterate to display the records got from the database
While Not rs.EOF
response.write(rs("id") & " " & rs("price") & " ")
rs.MoveNext
Wend
'closes the connection
rs.close
conn.close
Set rs = Nothing
Set conn = Nothing
%>
</body>
</html>
My email is tcscushing@aol.com I set up product 1 price 10 and product 2 price 5, see http://test.cushingshops.com
The last thing I tried was "enable frontpage extensions" then publish using VWD, directly to <root>\main and now it acts different than it did, but still doesnt seem to work when I go to www.cushingshops.com
Thanks for any help. All my code would be available to anyone, if we get this working. Email me for further info, or keys to access my stuff.
jeric2k5
Member
99 Points
39 Posts
Re: I need Help Getting publishing my website.
Apr 19, 2007 04:19 PM|LINK
Are you having any specific error messages or you just can't get the site running? Do you have control over how your domain redirects or you simply have to get it pointed to a sub folder?
~Eric
TomT
Member
15 Points
16 Posts
Re: I need Help Getting publishing my website.
Apr 21, 2007 05:53 PM|LINK
I got this from Jeremy:
It is true that 1and1 will not allow remote access to MSSQL which is a pain but it easy to work around just make a SQL Create script and run it from the mylittleadmin tool - tools - Query Analyser in the 1and1 admin section. Use aspnet_regsql to make the script to run Query Analyser.
<div>I need to run aspnet_regsql, and do I run it from my local machine, or do I run it from the server? I am guessing that I can run it, dos-mode, from my machine, specifying server, login-id, password, and the -sqlexportonly <filename> to generate a script.</div> <div> </div> <div>Do I use the switch to turn all application services as I generate the original script? Do I care about SQL CACHE DEPENDENCY OPTIONS?</div> <div> </div> <div>I then move the script to my 1and1 site, <root>\main (where my website apps are), and use the 1and1 mylittleadmin tool - tools - Query Analyser to run this script.</div> <div> </div> <div>Is this on the right track?</div> <div>Btw - my redirector script has worked fine, over the last month. I use the same script as Jeremy pointed out:</div> <div> </div> <div>http://faq.oneandone.co.uk/script_cookbook__databases/asp_net/asp_net_2_0/1.html</div> <div> </div> <div>-Tom*****************************************************
I will try this. My question as I begin is:
</div>
The King
Member
7 Points
21 Posts
Re: I need Help Getting publishing my website.
May 09, 2007 11:02 PM|LINK
As for any that are having problems adding data to a database,
You must download microsoft's optional sql express tool, backup your database, put it in the _db_imports folder of your ROOT webspace, then attempt to import it using 1&1's tools.
As for connection to the database, use this code (in vb)
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="server=mssqlxxx.1and1.com; initial catalog=dboxxxxxxx;uid=dbxxxxxx;pwd=xxxxxxxxxx" />
and be sure to replace the x's with your login info.
Hope this helps!
TomT
Member
15 Points
16 Posts
Re: I need Help Getting publishing my website.
May 12, 2007 02:03 AM|LINK
Thanks all, and especially to jeremyh who worked on this over 3 weeks, to get me up and going. As I was putting up the classified-ads starter kit, I will go back to their forum and try to leave a detailed explanation of what it took to get 1and1 to work.
Looking back, the biggest problem was probably the web.config connection string, which ended up being:
<connectionStrings>
<add name="classifiedsConnection" connectionString="server=mssqlxx.1and1.com; initial catalog=dbyyyyyyyyy; uid=dboyyyyyyyyy; Pwd=zzzzzzzz"/>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="server=mssqlxx.1and1.com; initial catalog=dbyyyyyyyyy; uid=dboyyyyyyyyy; Pwd=zzzzzzzz"/>
</connectionStrings>
I used the 1and1 ms-sql/admin-tool to find the values for xx, yyyyyyyyy, and zzzzzzzz
In a couple of days, I will post my detailed explanation over in the classified-ads forum. If anyone wants me to email source-changes to the stock classified-ads starter kit, let me know.
Thanks again, Jeremy!
tcscushing@aol.com - Tom
TomT
Member
15 Points
16 Posts
Re: I need Help Getting publishing my website.
May 17, 2007 04:33 PM|LINK
http://forums.asp.net/thread/1709414.aspx
Beginners might want to check this out.