Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 17, 2007 04:33 PM by TomT
Mar 31, 2007 09:18 PM|LINK
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?
Apr 03, 2007 03:19 PM|LINK
personal web site host hosting ISP deploy copy
configure starter kit on produciton server
Apr 19, 2007 01:31 PM|LINK
Hope it helps, if not let me know and I will look into testing it on 1and1 account.
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:
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
<title>Queries from the MS-SQL database with ASP</title>
<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") & " ")
'closes the connection
Set rs = Nothing
Set conn = Nothing
My email is firstname.lastname@example.org I set up product 1 price 10 and product 2 price 5, see
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
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.
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?
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.
I will try this. My question as I begin is:
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!
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:
<add name="classifiedsConnection" connectionString="server=mssqlxx.1and1.com; initial catalog=dbyyyyyyyyy; uid=dboyyyyyyyyy; Pwd=zzzzzzzz"/>
<add name="LocalSqlServer" connectionString="server=mssqlxx.1and1.com; initial catalog=dbyyyyyyyyy; uid=dboyyyyyyyyy; Pwd=zzzzzzzz"/>
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!
email@example.com - Tom
May 17, 2007 04:33 PM|LINK
Beginners might want to check this out.