ADO.NET :: Running SQL Script Using C#?
Nov 4, 2010
I'm having a problem when trying to run a SQL script from c#. I'll post my code below. I have been searching the net for a few days now and I believe my code is now correct, however I do not know how to fire it off to run the .sql file.
Default2.aspx
[Code]....
Default2.aspx.cs
[Code]....
.sql script
[Code]....
I'm not getting any errors when running the page and the data is not going into the table that the .sql is telling it to do so. I've tested the .sql using the SQL Query Analyzer and it works fine.
View 13 Replies
Similar Messages:
Jul 1, 2010
I am executing a long-running Oracle stored procedure from .NET. The procedure takes about three hours to run. Ideally, the user should be able to kick off the procedure, close the browser, and come back later to check the results.
The problem is that the connection to the Oracle procedure is lost after exactly an hour. As you would expect, the Oracle procedre runs to completion if it is executed from SQL Plus. Strangely enough, it will also run to completion if I run in debug mode on my local machine (I start two threads, one of which executes the procedure. I set a breakpoint on the second thread).
Here is my connection string:
data source= (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=serverx)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TestSID)))
Some relevant sections from web.config:
<sessionState mode="InProc" cookieless="false" timeout="3000" stateNetworkTimeout="72000"/>
<httpRuntime executionTimeout="18000" maxRequestLength="2097151" />
Any thoughts as to why the connection is being lost in exactly an hour, and what I can do to maintain the connection until the procedure finishes?
View 1 Replies
Sep 7, 2010
I have a web service which is running fine when i call it from a handler page (.ashx).
My web service returns a zip file.
But when i call the same code from my aspx page then i get a corrupted zip file. Code for calling is below and is same in both ashx class and aspx page.
[code]....
View 1 Replies
Nov 29, 2010
I have a problem with my IIS setting and I am not sure how to fix it. I created a new website which is based on .net 4.0. If I set the ASP.Net version to 2.0 for the website and try to browse to the site, I get the Run time error in the web.config which is understandable. If I change the asp.net version to 4.0 and try to browse to the website, I get the page not found error (see below). Any ideas what is wrong? I am hosting both 2.0 and 4.0 apps on this machine but this is the first time I am trying to run .net 4 application.The page cannot be foundThe page you are looking for might have been removed, had its name changed, or is temporarily unavailable.Please try the following:Make sure that the Web site address displayed in the address bar of your browser is spelled and formatted correctly.If you reached this page by clicking a link, contact the Web site administrator to alert them that the link is incorrectly formatted.Click the Back button to try another link. HTTP Error 404 - File or directory not found.Internet Information Services (IIS)
View 4 Replies
Jan 17, 2010
i have doing a video stream project,so i am facing a probrem while i encode the video.
after the user upload the video,i call a funtion continue after the video complately uplaod.
the problem is while the server side encode the video,i make the use have to wait at that page until the video is complately encode. is that any posible to seperate the upload and encode running?is that using
i wish to do is after the user upload the video,it can free using the webpage again .and in the same time the video is undergoing encoding trigger by video competely upload at the server side.
View 3 Replies
Jan 3, 2010
This may be obvious to many of you (hopefully!) I have a site under asp.net created using Visual Web Developer 2008 and MSSQL 2007 (all express editions)All ok so far.My PSP requires the addition of a couple of traditional ASP 'screens' to redirect payments to them. I cannot run this under VWD2008 development server as .asp are not allowed, so am looking to move to running it locally under IIS7 which is turned on.How do I alter the site to run on the IIS7 instance?
View 3 Replies
Feb 25, 2010
I am having a problem with FireFox, I have an app using VS 2008 and it is using a Wizard control. Under IE the app only runs Page_Load once but FireFox is running it twice which would'nt be a big deal except the second time it is not going through as a post back so all of my setting are getting reset as if it was the first time through. I have see in previous post that the problem was autoEventWireup needed set to False, well mine is. I am using Ajax and UpdatePanel.
View 3 Replies
Sep 19, 2010
I created a simple .NET 4.0 WebSite through VisualStudio 2010 using the Installed Template for ASP.NET Web Site.This brought me to "Choose Location" where I chose Local IIS, then Create New Web Application.This created the template app with all of the local files within IIS.This complies fine, but Im constantly getting the HTTP 403 Error "the website declined to show this webpage"I checked IIS properties for this and its set to 4.0 and the Directory Security has Anonymous Access enabled. Allow IIS to control password is also checked.I just installed VS 2010 on my new computer, and Im trying to get this configured so I can run 4.0 apps through IIS.
View 2 Replies
Jun 8, 2010
Has anyone had any experience trying to run a foxpro based .exe file from an asp.net page? How about just a regular asp page? My company has a com object that fires off a foxpro EXE to create a PDF document based on the user input. But we can't get the exe to fire from the COM object in our soon to be production environment. So if our hardware/network/security guys can't figure it out, I am wondering if I can, instead of calling the EXE from the com object, call it directly from the page? I have the input parameters set and available, but for some reason I keep getting an error saying that the parameter value is invalid. Yet I look at the values that are being passed to the com pbject and they are indentical.
View 3 Replies
Dec 19, 2010
What are the libraries, beside System.Web.Mvc, I need to run a MVC 3 RC2 application having the libraries in Bin Folder and not installing MVC 3 RC2?I am using JQuery and not Microsoft Ajax.
View 2 Replies
Apr 13, 2010
I'm running an ASP.NET WebService on IIS 6.0 that shows a lot of HTTP 500 (probably just exceptions from the WebService) inside the log at %systemroot%System32LogFilesW3SVC1 on a customers site.
Is it possible to log the content of those HTTP responses and there requests without modifying the WebService using IIS or a plug-in for IIS?
I thought of using Wireshark or Fiddler to sniff on the HTTP traffic but I would prefer to just turn on an option inside IIS to make him log the communication (this should not be to hard since it is logging the requested URLs anyway)
View 2 Replies
Jul 22, 2010
How can I see the version of .net framework which renders my aspx page on remote server?
View 4 Replies
Jul 20, 2010
I have a website that is hosted on IIS6 and set to use .NET 4.0, but I still have a WCF service on the site that is using 3.5. When i browse my svc file, i get the error:
unrecognized attribute 'targetFramework'
and it point to the websites root web.config. I have tried this MSDN article and still get the same error. My site is using a different app pool than my WCF service, and is configured to use 4.0 in the ASP.NET tab of properties. I have also checked and made sure that my WCF service is using 3.5(2.0) in its ASP.NET properties tab.
View 1 Replies
Mar 20, 2010
I created an MVC project in vs2010 RC and i cant really tell if its running on MVC 2 Beta or the freshly released MVC Release. Is there anything i can look out for to determine this?
View 12 Replies
Feb 11, 2010
I am learning C# in Visual Studio (VS), and in VS i have successfully made different 'projects' under the 'solution' for each fo the samples in my C# book as can be seen here:
[URL]
the thing is when i press the green play button to run the debugger/program, it always executes "ConsoleApplication1" (look at the above image) when i want to try out the new application i wrote (named ConsoleApplication3)
How do i do that?
View 1 Replies
Sep 17, 2010
I am getting below error while running the application
Exception in MS Oracle DAAB Method - GetDataSet : Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "DABResource.resources" was correctly embedded or linked into assembly "DBServices" at compile time, or that all the satellite assemblies required are loadable and fully signed.
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.Exception: Exception in MS Oracle DAAB Method - GetDataSet : Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "DABResource.resources" was correctly embedded or linked into assembly "DBServices" at compile time, or that all the satellite assemblies required are loadable and fully signed.
View 5 Replies
Mar 24, 2010
I have an application in asp.net.I configured it in IIS.When i running this application in IIS i getting an error;
Server "/" error:
Resource Cannot be Found
Error:404
Some of pages only produce this issues.Other forms are working perfectly.Without running application in IIS Its working perfectly.
If any one can answer send the answer immediatly.
View 2 Replies
Feb 21, 2011
when i am trying to run the application i am getting error like this one The service.svc file has the following code.
<%@ ServiceHost Language="C#" Debug="true" Service="prodcuts.ProductServiceImpl" CodeBehind="~/App_Code/ProductsService.cs" %>
View 1 Replies
Sep 27, 2010
I have an ASP.NET 1.1 app running fine on my local system and Win 2003 server. I transferred this site to a Win 2008 R2 server. The site is running under an app pool configured to run under ASP.NET v2.0. Some of the pages of the site throw exceptions and there are other problems in running the site as well however the same works good on Win 2003 Server. When I try to run the site under app pool for ASP.NET 1.1, it says "500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed."
View 2 Replies
Apr 2, 2010
I have a Windows 2008 server and MVC 2.0 site is hosted under IIS 7.0 root directory. The site works fine. I want to use the BlogEngine.NET with my site. For example if my mite name is [URL] (which is the root of IIS) and the blog should be [URL]
Is this possible? Can I create a sub virtual directory within my root (where the MVC 2 app is hosted) and run the ASP.NET BlogEngine.Net in it?
View 1 Replies
Dec 10, 2010
I have a question about Singletons running within IIS (6,7,7.5) and an ASP.NET 4.0 Web Application (MVC3 app to be specific).
I have a singleton object in my project that is accessed and used in the global.ascx, on the application_start, as well as a few other places within the application.
My concern is, this singleton needs to be accessable at a per instance scenario. However, since IIS is essentially the hosting process, is the singleton going to be the same object across all instances of the application?
If I use the [ThreadStatic] keyword, does it seperate at the Application Pool level?
Finally, is there a way, I can assure a singleton is only a singleton per instance of my application. i.e. if I run my application on 1 website, but inside 5 virtual directories, there is 5 instances of the singleton or if I run my website on 5 different websites within the same application pool.
[code]....
View 3 Replies
Nov 19, 2010
I have a ASP.NET web application running under IIS 6, and another process that is responsible to monitor and report status. I'd like to sample the web application by the monitoring process in order to check its status by accessing a dedicated handler on the web application, BUT i don't want to "wake up" the web application in case it is not running. Is there an option to determine whether a specific web application is currently running? if there is such an option, i would be able to first check if the application is running, and only then to access the handler to check its status.
View 6 Replies
Feb 17, 2010
We have a running asp.net application which is accessed by various offices of the client worldwide (around 42 offices in 12 countries). Now after 8 months of hosting it we have to include updations in 6 pages and addition of 15 new asp.net pages. Now is there any way by which we could update the existing upside without taking it offline i.e. stopping it ?
View 4 Replies
Sep 7, 2010
SqlCommand MyCommand1 = new SqlCommand("Insert into incoming_inventory(division_code,inv_date) select '"+dd_district.SelectedValue+"','+'" + DropDownList3.SelectedValue + "'+'/'+dayno+'/'+'2010' from month_day where month_name=datename(month,dateadd(month," + DropDownList3.SelectedValue +",0)-1)'", MyConnection1);
View 2 Replies
Feb 1, 2011
I want to start using memcached in my ASP.NET application.
I think I need to set up a memcached server and then access it using a .NET specific client.
However I'm struggling to see how to set it up, where to find the exact downloads for .NET and so on
Is there a port of memcache to .Net? memcached - using with a C# asp.net application
View 1 Replies
