Hi my name is mike. I have been testing out the clubsite templet. It is very nice and works very well. I recently wanted to test it in IIS. So i set it up and put the published solution in the IIS directory. When i try to load the website it directs me
to the error page for the clubwebsite. If i run the solution in visual studios it works perfectly fine. I was wondering if anyone has successfully got this site to work in IIS. Hope you guys can help. Thanks
Also can you use this site as XML, or does it have to have a data base like sql server?
It should be a reasonably simple matter to get the Club Site to run under SQL Server 2008, it should just be a matter of changing the connection string for the database.
The best place to find the correct connection string would be here:
Obviously, you will need to move the database into the SQL Server instance.
A slightly more long winded way, if you really wanted to use XML would be to implement a true n-tier database access layer, and then implement a provider for the XML file that you wanted to use. For a very good example of an n-Tier approach, I would suggest
you have a look at the BeerHouse Sample Kit, which you can find here:
Hi my name is mike. I have been testing out the clubsite templet. It is very nice and works very well. I recently wanted to test it in IIS. So i set it up and put the published solution in the IIS directory. When i try to load the website it directs me
to the error page for the clubwebsite. If i run the solution in visual studios it works perfectly fine. I was wondering if anyone has successfully got this site to work in IIS. Hope you guys can help. Thanks
Also can you use this site as XML, or does it have to have a data base like sql server?
when u execute in vs it run with the helps asp.net own server but when u publish with IIS the page need to be executed with the help of IIS Server. The problem with the port.
Try this solution
Create a sample site with a single page and publish to iis. check the port no and then use the same port no
in the clubsite project.
Jai Ganesh. J, IDC, India
Please Mark As Answer If my reply helped you.
i have already got IIS set up right. The reason is becuase i just made a quick html doc in notepad with some simple text in it, and put it on iis and set it all up. I could connect to it from a different computer. So i know that iis is set up right. I just
cannot figure out how to get the club site to work in iis. I published it in vs and then put it in a virtual directory in iis. Then i install sql server and tried to open the mdf file and attact it the the database in sql. I got a error saying that it could
not be open. So i am kinda lost. I dont really want to change the connection strings for each part of the codebehind. Is there a easier solution?
It's been a while since I have looked at the Club Site code, but from what I remember, the connection string is definitely listed in the web.config file, and this connection string is then used throughout the application where it is needed. At least, this
is the way it should be. By default, the connection string will be looking for an mdf file in the project's app_data folder, since you are moving the database onto a SQL Server instance, you are going to need to modify the connection string in the web.config
file to point to where the database now lives, and that should sort you out.
michaelkush
Member
2 Points
5 Posts
Club site wont work in IIS
Aug 06, 2009 11:18 PM|LINK
Hi my name is mike. I have been testing out the clubsite templet. It is very nice and works very well. I recently wanted to test it in IIS. So i set it up and put the published solution in the IIS directory. When i try to load the website it directs me to the error page for the clubwebsite. If i run the solution in visual studios it works perfectly fine. I was wondering if anyone has successfully got this site to work in IIS. Hope you guys can help. Thanks
Also can you use this site as XML, or does it have to have a data base like sql server?
thewebhostin...
Member
129 Points
31 Posts
Re: Club site wont work in IIS
Aug 07, 2009 12:07 AM|LINK
Club site uses SQL express as far as I know. Please confirm that database engine being used.
michaelkush
Member
2 Points
5 Posts
Re: Club site wont work in IIS
Aug 07, 2009 01:18 AM|LINK
can i use sql server 2008?
gep13
Member
228 Points
65 Posts
Re: Club site wont work in IIS
Aug 19, 2009 11:46 AM|LINK
Hey,
It should be a reasonably simple matter to get the Club Site to run under SQL Server 2008, it should just be a matter of changing the connection string for the database.
The best place to find the correct connection string would be here:
http://www.connectionstrings.com/
Obviously, you will need to move the database into the SQL Server instance.
A slightly more long winded way, if you really wanted to use XML would be to implement a true n-tier database access layer, and then implement a provider for the XML file that you wanted to use. For a very good example of an n-Tier approach, I would suggest you have a look at the BeerHouse Sample Kit, which you can find here:
http://www.asp.net/downloads/starter-kits/the-beer-house/
Hope that helps!!
Gary
Ganesh@Nilgr...
Contributor
6074 Points
2354 Posts
Re: Club site wont work in IIS
Aug 20, 2009 05:12 AM|LINK
when u execute in vs it run with the helps asp.net own server but when u publish with IIS the page need to be executed with the help of IIS Server. The problem with the port.
Try this solution
Create a sample site with a single page and publish to iis. check the port no and then use the same port no
in the clubsite project.
Please Mark As Answer If my reply helped you.
michaelkush
Member
2 Points
5 Posts
Re: Club site wont work in IIS
Aug 20, 2009 04:43 PM|LINK
i have already got IIS set up right. The reason is becuase i just made a quick html doc in notepad with some simple text in it, and put it on iis and set it all up. I could connect to it from a different computer. So i know that iis is set up right. I just cannot figure out how to get the club site to work in iis. I published it in vs and then put it in a virtual directory in iis. Then i install sql server and tried to open the mdf file and attact it the the database in sql. I got a error saying that it could not be open. So i am kinda lost. I dont really want to change the connection strings for each part of the codebehind. Is there a easier solution?
gep13
Member
228 Points
65 Posts
Re: Club site wont work in IIS
Aug 20, 2009 04:58 PM|LINK
Hey,
You shouldn't need to change the connection string everywhere, the connection string should be stored in the web.config file.
Gary
michaelkush
Member
2 Points
5 Posts
Re: Club site wont work in IIS
Aug 20, 2009 05:44 PM|LINK
do i have to change the connection strings in the web.config file?
gep13
Member
228 Points
65 Posts
Re: Club site wont work in IIS
Aug 21, 2009 06:33 AM|LINK
Hey,
It's been a while since I have looked at the Club Site code, but from what I remember, the connection string is definitely listed in the web.config file, and this connection string is then used throughout the application where it is needed. At least, this is the way it should be. By default, the connection string will be looking for an mdf file in the project's app_data folder, since you are moving the database onto a SQL Server instance, you are going to need to modify the connection string in the web.config file to point to where the database now lives, and that should sort you out.
Hope that helps!!
Gary