Starter Kit Application deployment

**Cowboy \(Gregory A. Beamer\)** · Sep 16 '06, 03:45 PM

Re: Starter Kit Application deployment

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" <esha@newsgroup s.comwrote in message
news:On3nKca2GH A.1268@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** · Sep 16 '06, 03:55 PM

Re: Starter Kit Application deployment

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)" <NoSpamMgbworld @comcast.netNoS pamMwrote in
message news:%23r9mbka2 GHA.4924@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" <esha@newsgroup s.comwrote in message
news:On3nKca2GH A.1268@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\)** · Sep 16 '06, 04:15 PM

Re: Starter Kit Application deployment

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" <esha@newsgroup s.comwrote in message
news:%23jW1Npa2 GHA.4108@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)" <NoSpamMgbworld @comcast.netNoS pamMwrote in
message news:%23r9mbka2 GHA.4924@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" <esha@newsgroup s.comwrote in message
>news:On3nKca2G HA.1268@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** · Sep 16 '06, 05:05 PM

Re: Starter Kit Application deployment

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)" <NoSpamMgbworld @comcast.netNoS pamMwrote in
message news:u67lHxa2GH A.324@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" <esha@newsgroup s.comwrote in message
news:%23jW1Npa2 GHA.4108@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)" <NoSpamMgbworld @comcast.netNoS pamMwrote in
>message news:%23r9mbka2 GHA.4924@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" <esha@newsgroup s.comwrote in message
>>news:On3nKca2 GHA.1268@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
>>>>
>>>
>>>

>>
>>

>
>

Starter Kit Application deployment

Starter Kit Application deployment

Comment

Comment

Comment

Comment