Starter Kit Application deployment

[esha]

I have ASP.NET 2 hosting. I created my first simple WEB application from
Personal WEB Starter Kit template.
Everything works fine on my local machine.
I uploaded all files to the hosting server. Pages which do not use database
work, pages which communicate with the database do not work.
I'm just starting to learn programming and have not enough knowledge to
realize what's wrong. I just suspect that I have to change ConnectionStrin g
in WEB.config file. Now I have there:
<connectionStri ngs>

<add name="Personal" connectionStrin g="Data Source=.\SQLExp ress;Integrated
Security=True;U ser
Instance=True;A ttachDBFilename =|DataDirectory |Personal.mdf"
providerName="S ystem.Data.SqlC lient"/>

<remove name="LocalSqlS erver"/>

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQLExp ress;Integrated Security=True;U ser
Instance=True;A ttachDBFilename =|DataDirectory |aspnetdb.mdf"/>

</connectionStrin gs>

First of all I do not know what should I put there and I even doubt that
SQLExpress may be used for a real web site.
Any help please

Thank you

Esha

[Cowboy \(Gregory A. Beamer\)]

You need to work with your ISP's support division and find out how they have
SQL set up for your site. You will then have to move your database to that
server (unless they are using SQLExpress, then you might have a few other
hoops to jump through). Once you have the data in a database and have the
connection string aimed to that database, your app will work.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
"esha" <es**@newsgroup s.comwrote in message
news:On******** ******@TK2MSFTN GP02.phx.gbl...

>I have ASP.NET 2 hosting. I created my first simple WEB application from
Personal WEB Starter Kit template.
Everything works fine on my local machine.
I uploaded all files to the hosting server. Pages which do not use
database work, pages which communicate with the database do not work.
I'm just starting to learn programming and have not enough knowledge to
realize what's wrong. I just suspect that I have to change
ConnectionStrin g in WEB.config file. Now I have there:
<connectionStri ngs>

<add name="Personal" connectionStrin g="Data Source=.\SQLExp ress;Integrated
Security=True;U ser
Instance=True;A ttachDBFilename =|DataDirectory |Personal.mdf"
providerName="S ystem.Data.SqlC lient"/>

<remove name="LocalSqlS erver"/>

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQLExp ress;Integrated Security=True;U ser
Instance=True;A ttachDBFilename =|DataDirectory |aspnetdb.mdf"/>

</connectionStrin gs>

First of all I do not know what should I put there and I even doubt that
SQLExpress may be used for a real web site.
Any help please

Thank you

Esha

[esha]

Thank you Cowboy
My ISP offers SQL Server 2005. I don't know about SQLExpress. Does
SQLExpress require any special action? I was thinking that it works similar
to MS Access (just copy db to the appropriate folder and that's it).
If I will move the data from SQLExpress to the SQL Server (I don't know how
to do that yet), should I then change Connection string in web.config file
only, or some additional actions are required?

Esha
"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamMwrote in
message news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

You need to work with your ISP's support division and find out how they
have SQL set up for your site. You will then have to move your database to
that server (unless they are using SQLExpress, then you might have a few
other hoops to jump through). Once you have the data in a database and
have the connection string aimed to that database, your app will work.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
"esha" <es**@newsgroup s.comwrote in message
news:On******** ******@TK2MSFTN GP02.phx.gbl...

>>I have ASP.NET 2 hosting. I created my first simple WEB application from
Personal WEB Starter Kit template.
Everything works fine on my local machine.
I uploaded all files to the hosting server. Pages which do not use
database work, pages which communicate with the database do not work.
I'm just starting to learn programming and have not enough knowledge to
realize what's wrong. I just suspect that I have to change
ConnectionStri ng in WEB.config file. Now I have there:
<connectionStr ings>

<add name="Personal" connectionStrin g="Data
Source=.\SQLEx press;Integrate d Security=True;U ser
Instance=True; AttachDBFilenam e=|DataDirector y|Personal.mdf"
providerName=" System.Data.Sql Client"/>

<remove name="LocalSqlS erver"/>

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQLEx press;Integrate d Security=True;U ser
Instance=True; AttachDBFilenam e=|DataDirector y|aspnetdb.mdf"/>

</connectionStrin gs>

First of all I do not know what should I put there and I even doubt that
SQLExpress may be used for a real web site.
Any help please

Thank you

Esha

[Cowboy \(Gregory A. Beamer\)]

It is almost as easy as Access, but not quite.

Ask your ISP if they support SQL Server 2005 file based databases. If so,
they should be able to help you link the file up to their server. They can
then tell you how to use it.

If they do not, you will have to migrate the data. Since you will only have
limited tools on the local SQL Express install, this might be a pain. The
easiest way is to recreate the seed data as scripts. The SQL Express tools
are minimal help here. You can download a trial of redgate's product and
create the data insert scripts. You then connect to the ISP SQL box and run
the sql script.

The other option is move to Access, but depending on where they have the
files, you may have to set the connection string based on file location,
using MapPath. This is fairly simple. Reason: For security, some ISPs move
the root location, which will force you to figure out the path to the .mdb
file using Server.MapPath.

Don't worry, it does get easier once you do it once.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
"esha" <es**@newsgroup s.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

Thank you Cowboy
My ISP offers SQL Server 2005. I don't know about SQLExpress. Does
SQLExpress require any special action? I was thinking that it works
similar to MS Access (just copy db to the appropriate folder and that's
it).
If I will move the data from SQLExpress to the SQL Server (I don't know
how to do that yet), should I then change Connection string in web.config
file only, or some additional actions are required?

Esha
"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamMwrote in
message news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

>You need to work with your ISP's support division and find out how they
have SQL set up for your site. You will then have to move your database
to that server (unless they are using SQLExpress, then you might have a
few other hoops to jump through). Once you have the data in a database
and have the connection string aimed to that database, your app will
work.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************** *************** *************** *****
Think outside of the box!
************** *************** *************** *****
"esha" <es**@newsgroup s.comwrote in message
news:On******* *******@TK2MSFT NGP02.phx.gbl.. .

>>>I have ASP.NET 2 hosting. I created my first simple WEB application from
Personal WEB Starter Kit template.
Everything works fine on my local machine.
I uploaded all files to the hosting server. Pages which do not use
database work, pages which communicate with the database do not work.
I'm just starting to learn programming and have not enough knowledge to
realize what's wrong. I just suspect that I have to change
ConnectionStr ing in WEB.config file. Now I have there:
<connectionSt rings>

<add name="Personal" connectionStrin g="Data
Source=.\SQLE xpress;Integrat ed Security=True;U ser
Instance=True ;AttachDBFilena me=|DataDirecto ry|Personal.mdf "
providerName= "System.Data.Sq lClient"/>

<remove name="LocalSqlS erver"/>

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQLE xpress;Integrat ed Security=True;U ser
Instance=True ;AttachDBFilena me=|DataDirecto ry|aspnetdb.mdf "/>

</connectionStrin gs>

First of all I do not know what should I put there and I even doubt that
SQLExpress may be used for a real web site.
Any help please

Thank you

Esha

[esha]

Thank you
I talked to Host technician. She said that only dedicated server can give me
the ability to use SQLExpress, but I have Shared Server account.
I have SQL Server 2005 installed on my development machine. I have a
connection to the sql server on hosting server. I created the database
(Personal) there and ran the script for tables and SPs creation. I also
manually added (copied from SQLExpress) data into tables.
I changed ConnectionStrin g in web.config to:
"Data Source=mssql4.s ecuredca.com;In itial Catalog=chapran _personal;User
ID=chapran_chap ;Password=vovan 8682;" providerName="S ystem.Data.SqlC lient"/>

I did not make any changes to:

<remove name="LocalSqlS erver"/>

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQLExp ress;Integrated Security=True;U ser
Instance=True;A ttachDBFilename =|DataDirectory |aspnetdb.mdf"/>

because I have no idea what to put there and I even do not know if I have to
use that part on the real server.

My pages with database communication still do not work

What else should I do?

Esha

"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamMwrote in
message news:u6******** *****@TK2MSFTNG P05.phx.gbl...

It is almost as easy as Access, but not quite.

Ask your ISP if they support SQL Server 2005 file based databases. If so,
they should be able to help you link the file up to their server. They can
then tell you how to use it.

If they do not, you will have to migrate the data. Since you will only
have limited tools on the local SQL Express install, this might be a pain.
The easiest way is to recreate the seed data as scripts. The SQL Express
tools are minimal help here. You can download a trial of redgate's product
and create the data insert scripts. You then connect to the ISP SQL box
and run the sql script.

The other option is move to Access, but depending on where they have the
files, you may have to set the connection string based on file location,
using MapPath. This is fairly simple. Reason: For security, some ISPs move
the root location, which will force you to figure out the path to the .mdb
file using Server.MapPath.

Don't worry, it does get easier once you do it once.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************** *************** *************** ****
Think outside of the box!
*************** *************** *************** ****
"esha" <es**@newsgroup s.comwrote in message
news:%2******** ********@TK2MSF TNGP04.phx.gbl. ..

>Thank you Cowboy
My ISP offers SQL Server 2005. I don't know about SQLExpress. Does
SQLExpress require any special action? I was thinking that it works
similar to MS Access (just copy db to the appropriate folder and that's
it).
If I will move the data from SQLExpress to the SQL Server (I don't know
how to do that yet), should I then change Connection string in web.config
file only, or some additional actions are required?

Esha
"Cowboy (Gregory A. Beamer)" <No************ @comcast.netNoS pamMwrote in
message news:%2******** ********@TK2MSF TNGP05.phx.gbl. ..

>>You need to work with your ISP's support division and find out how they
have SQL set up for your site. You will then have to move your database
to that server (unless they are using SQLExpress, then you might have a
few other hoops to jump through). Once you have the data in a database
and have the connection string aimed to that database, your app will
work.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************* *************** *************** ******
Think outside of the box!
************* *************** *************** ******
"esha" <es**@newsgroup s.comwrote in message
news:On****** ********@TK2MSF TNGP02.phx.gbl. ..
I have ASP.NET 2 hosting. I created my first simple WEB application from
Personal WEB Starter Kit template.
Everything works fine on my local machine.
I uploaded all files to the hosting server. Pages which do not use
database work, pages which communicate with the database do not work.
I'm just starting to learn programming and have not enough knowledge to
realize what's wrong. I just suspect that I have to change
ConnectionSt ring in WEB.config file. Now I have there:
<connectionS trings>

<add name="Personal" connectionStrin g="Data
Source=.\SQL Express;Integra ted Security=True;U ser
Instance=Tru e;AttachDBFilen ame=|DataDirect ory|Personal.md f"
providerName ="System.Data.S qlClient"/>

<remove name="LocalSqlS erver"/>

<add name="LocalSqlS erver" connectionStrin g="Data
Source=.\SQL Express;Integra ted Security=True;U ser
Instance=Tru e;AttachDBFilen ame=|DataDirect ory|aspnetdb.md f"/>

</connectionStrin gs>

First of all I do not know what should I put there and I even doubt
that SQLExpress may be used for a real web site.
Any help please

Thank you

Esha