|
i am developing a webapp. and i need to know:
How to upload my database to the webserver , where my site is to be hosted?
|
|
|
|
|
hi Subin Alex
I think sometimes the Terms that people use are confusing. If you are a Hoster, then you Server must have SQL 2000 installed and there must be IIS, but in the real world there is a Database Server and a Application Server(IIS).
Deploy your App to your IIS , and make sure that your Connection string is in the Web Config and Change it from there after installing or you can create a Web setup Project where your users will be prompted with the name of the server on the installation. there is no differents the important thing to note is to remember where is your IIS and where is your SQL
if you are using a paid host. you need to talk to your provider and tell him what version you want of sql and what version of .NET you want on the IIS.
Hope i helped looking forward for your reply
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
THANKS,
But i am web programmer not one who "host".
I want to know that if i want to upload a web site app in asp.net2.0 and backend as sqlserver2000 ,how do i upload the database to the web server? I am familiar with MsAccess but not with sqlserver.
plz help.
|
|
|
|
|
SQL and Access are Different. In Access you will deploy your application with the Databas, but in SQL you have to point to the Server. SQL Database cannot be accessed like Access databases. SQL Database must be hosted in a Server that SQL installed on it. That mean you need to have another machine that will be your Database Server, install SQL on it and take its name and add it in the Connection String of your Application. This is to tell your application that you are using the Database in a certain Server and Database is bla bla bla.....
Thank you looking forward for your reply
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
yes i've contacted a web hosting firm which supports sqlserver2000, But my question is:
How do my mdf file get attached to the database in the remote web server?
|
|
|
|
|
Now in that case give them your MDF and they will attach them for you, because i dont think a hoster will allow you to do that. I think what they have is a GUI that allows you to create a Database with a Click , create SP's , they will create a shell for you where you can run your sql queries. but what you have to do id to give them mdf files , they will attach them and when you log in into their control panel you will see your DB
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
|
Welcome
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
I have used collectionpager for datalist pagination,its works fine but i am using dropdownlist for sorting the content in the datalist.Here the dropdownlist event is not properly working while using collectionpager .Plz help me?
Thanks in Advance..
|
|
|
|
|
I am a bit confused about ASP.NET Web Application and ASP.NET Web Service Application.
For instance if one has to develop Project Management software to be used within company and all the users are using windows OS. So one should start ASP.NET Web Application or ASP.NET Web Service.
Thank You
Andyyy
|
|
|
|
|
If it's all going to be used within the company, I see no immediate reason to use web services. It sounds like you want a Web application. If there are certain subsets of functionality that it would be helpful to have callable from other applications within the company, it might make sense to make them available as web services.
Scott
|
|
|
|
|
ok, so if i start with web application and later if there is a need to have it callable from other applications within the company, then would i be able to change it to web services?
So basically if i developed project management web application software with Gantt charts, time logs, project followup etc...and then do i have to host it ? or that can be used as intranet with in the company ? And once its all developed and being used with the company - what all features can be added if one move the application to web services ?
Sorry if its too basic but i need to get it correct to start moving in the right direction.
Thank you
|
|
|
|
|
You wouldn't move the whole application to a web service, just specific pieces of functionality. Off the top of my head I can't even think of what some of that functionality might be - perhaps logging activity on a project. A web service doesn't provide an interface.
You could run it as an intranet within the company.
Scott
|
|
|
|
|
That depends on what you're trying to acheive.
If the users are going to continue using desktop apps then they'll want to update from a web service.
If you're going to write entirely new project management software to be run on a network in a browser then you want a web application.
That's how I would look at it.
|
|
|
|
|
markymark82 wrote: If the users are going to continue using desktop apps then they'll want to update from a web service.
So you mean if i develop a project management software as a desktop application at first instance using only C# and SQL and then later once the product is developed, i can use web services to use it with in whole company ?
|
|
|
|
|
If you want to use it throughout the company, and users are using desktop software, then obviously that software will need to be rolled out to all users who'll need it. It can then connect to various web services for updates etc.
These web services could also be connected to by any other desktop (or even web) applications that you develop later on.
A web application is more self contained (please people correct me if I'm being completely misleading), and so can be accessed only by itself. This would be centrally accessed by all users who wouldn't then need their desktop applications (these would be re-written as the web application).
I hope that makes sense, and I'm not just confusing matters further
|
|
|
|
|
Hi experts.
iam using iframe in my web page.how to set the height of the iframe dynamically in c#.
iam assigining src attriubute in the code behind like this
HtmlControl frame1 = (HtmlControl)this.FindControl("iframename");
frame1.Attributes["src"] = getdetails.Bookingdata;
iam getting the data but i cant set the height automatically. i want to increase the height of my webpage depending upon the content of iframe.
regards
venu..
|
|
|
|
|
Hi all,
I'm looking at creating a system on our website to redirect abnormally large volumes of visitors to a holding page to limit the amount of bandwidth being used to keep our website working at a reasonable speed (The holding page would use virtually no bandwidth and would auto refresh to check if they can gain access yet or not).
What I'm after is to say if there are more than say 800 connections to the website, those over the 800 get assigned a queue number and sent to a holding page until a connection is free.
I had an idea to do it with Application variables and sessions, ie:
on Session_Start Application["CurrentConnCount"] = itself + 1
on Session_End Application["CurrentConnCount"] = itself - 1
However, the Session_End event can't be relied upon to be fired if a session just times out.
Is there another way I can do this, it all sounded nice and easy in my head, but the execution is currently eluding me.
I know I can limit the number of connections using iis, but this returns 'Service is Unavailable' and does not care if someone is in the middle of a transaction or not so isn't suitable.
Can I look at the number of current connections to the website using .net, rather than relying on events that may or may not be fired?
Thanks in advance for any help, I hope that all made sense and I'm not talking complete jibberish...
|
|
|
|
|
Hello All,
when i try to debug in VS2008 then build success then i got error:
"Unable to start debugging on the web server. Debugging failed because integrated Windows authentication is not enabled. Please see Help for assistance."
can you pls tell me what is solution for that?
Thanks
Anish Patel
|
|
|
|
|
anish27patel wrote: "Unable to start debugging on the web server. Debugging failed because integrated Windows authentication is not enabled. Please see Help for assistance."
I think, you have hosted sites on IIS and trying to debug from VS. Just go to IIS > Right Click VD > Properties > Authentication > Edit > Select Windows Authentication.
That's all do for you
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
thanks for reply but i already tried that but not working same error is coming.
Anish Patel
|
|
|
|
|
please check weather Web.config placed properly or not?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hello All,
I'm using ASP.NET 2008 (C#). I have created unit test project for my aspx page
after debugging it gives me error as follows
"Failed Page_LoadTest IndigoLogintest The communication channel with ASP.NET could not be configured. Requested Service not found "
Can someone please help me why I'm getting this error.
Thanks in advance.
|
|
|
|
|
Yes Even i am getting the same error given below.
"The communication channel with ASP.NET could not be configured. Requested Service not found"
|
|
|
|
|
Hi,
I am using VS 2003 with crystal report in it. I have develop a web site with crystal report for one of company client. I have done the below solution. I place the contain of release folder [setup (application), setup(config file) and an installer package] to bin folder in hosting. But still i am getting the errors
Cannot find KeycodeV2.dll, or invalid keycode.
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: CrystalDecisions.CrystalReports.Engine.InternalException: Cannot find KeycodeV2.dll, or invalid keycode.
What i should do?? Pls its quiet urgent.....any help appreciate...
>Finding Out What the Crystal Report Distribution Key is on VS.NET 2003:
>
> 1- Open VS.NET 2003
> 2- Click on Help Menu Option
> 3- Choose "About Microsoft Development Environment"
> 4- Look under Crystal Reports for Visual Studio .NET, you will see a 19
> character number, which is the Distribution Key Code:
>
> Example: AAA00-BB00000-C0000DD
>
> Producing the Deployment Project:
>
> Open Solution Explorer, right click on the “Solution Name” at the top
> and Add a New Project. On the window that appears, move to Setup and
> Deployment Projects. Click on Setup Project (not the wizard), put a name
> for your deployment project (make a note of the location where the
> folder that the deployment project will be created in) and then click
> OK. A File System dialog will appear – solution explorer should be
> displayed on the left of screen. Within solution explorer – right click
> over your deployment project and select Add – Project Output. Another
> window will appear – select Primary Output (make sure configuration is
> showing Active) and click OK. This will result in the detected
> dependencies being updated & a primary output icon appearing in the
> deployment project. Right click on the deployment project name again and
> Add – Merge Modules. Add the following modules.
>
> Crystal_Database_Access2003.msm
> Crystal_Database_Access2003_enu.msm
> Crystal_Managed2003.msm
> Crystal_regwiz2003.msm
> VC_User_CRT71_RTL_X86_---.msm
> VC_User_STL71_RTL_X86_---.msm
>
> These were the appropriate modules for my application given that I am
> using VS 2003. Yours may be slightly different.
>
> Right click on Crystal_regwiz2003.msm and go to its properties. Enlarge
> the MergeModuleProperties tree and enter the product licence key.
>
> Go onto Build – Configuration Manager . Check that the Project &
> Deployment Project which appear are set to “Release” and the Build check
> box for each is checked. Build the Project. If all is well the build
> should show no errors.
>
> If this has gone according to plan you should now have (in the folder
> specified in the “location” window given when you added your deployment
> project) a debug and release folder. The release folder will contain:
>
> - setup (application)
> - setup (config file)
> - an installer package
>
> The release folder is all that is needed to deploy the application on
> another machine.
|
|
|
|