hi
i created my first portal in my localhost and it's working good
i used version : DotNetNuke_Community_04.09.03
my database : Microsoft SQL Server 2005

and i here this tutorial
How to transfer a localhost DotNetNuke installation to a live website
http://www.dnncreative.com/Localhos...fault.aspx
to know how i can upload it to live website and i did all steps
but after i finished and try to browse my web site i get this error message

Must declare the scalar variable "@PortalID".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@PortalID".

you can check it from this page url
http://www.almny.com/Default.aspx
and you will see the error massage

after that i deleted my files from the live server and upload new web site without create any modules our pages it's only new refresh portal but it's also give me the same error message

This might be an error related to the database.

Did you upload your database to a new database server? Did you remember to change BOTH instances of the connection string to the database in your web.config file?

If you made no changes, then web.config's connection strings are looking for the database on the original server. Can it get to that server from the live site?

hi jncraig
thanks for your reply

1- Did you upload your database to a new database server ?
yes i did to different things
- copy my local database and attached it on my server
- take backup from my local database and restor it into my server
and in both ways i get the same error

2-Did you remember to change BOTH instances of the connection string to the database in your web.config file
yes i did and the error reason not from connection string and i follow up all steps in the tutorials and i still get this error message

the problem i forget my portal and say maybe i did some mistakes and i instal new website it's fresh and try to upload it and did all configration like change conection string add alias and also i get the same error message

plz if any one have any suggestion ideas tell me it because i did erver things i can do it
thanks for all

i solved it
the problem in sql server collection was case sensitive
i reinstal sql server 2005 again and choose coolection case insensitive and it's working good now check me web site
http://www.almny.com

thanks for all guys