SQL Server :: Using Cursors With A Web Application?
Feb 19, 2011provide me the scenario when we go to use a cursor instead os stored procedure and query.
View 1 Replies
Similar Messages:
ADO.NET :: Stored Procedure Returning Multiple Ref Cursors
Nov 22, 2010Is it possible to have a stored procedure return multiple ref cursors to a .Net application? I tried this, but it didn't work.
<code>
While odr.Read()
dtUserData.Load(odr, LoadOption.OverwriteChanges)
End While
odr.NextResult()
While odr.Read()
dtUserRoles.Load(odr, LoadOption.OverwriteChanges)
End While
</code>
Databases :: ORA-01000 - Maximum Open Cursors Exceeded
Jun 28, 2010I have some problem according to nettiers generator..
i am using nettiers 2.3.0 to generate library for oracle datasource 10g.
here is the error when i am using the library..
ORA-01000: maximum open cursors exceeded
ORA-06512: at "EPROC.ADM_MENU_GETPAGED", line 40
ORA-06512: at line 1
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OracleClient.OracleException: ORA-01000: maximum open cursors exceeded
ORA-06512: at "USERXXX.ADM_MENU_GETPAGED", line 40
ORA-06512: at line 1
Source Error:
[Code]....
MailMessage Sent To Any Adress From Windows Forms Application, But Not From Asp.net Application, After Both Are Using The Same SMTP-server?
Jan 27, 2010I'm experiencing a to me mysterious error when sending e-mails through a SMTP-server from an ASP.NET web application. I get the famous error "unable to relay for xxx@yyy.zzz". What's mysterious to me is that when I cut and paste the exact same code that sends the e-mail into an usual .NET Windows Forms application, send the e-mail with this application, it all works just fine. This made me think that perhaps the problem is that the ASP.NET application runs as NETWORK SERVICE while the Windows Forms application runs on a domain user account, but it turns out that I have another ASP.NET application sending e-mail through the same SMTP-server running under NETWORK SERVER at the same IIS, and this application does not experience this problem.
I've further tried to send e-mails through the SMTP-server manually by telnet the smtp-server on port 25 and running the SMTP-protocol manually, and it all works fine. The SMTP-server is not configured with any kind of authentication or SSL.
Another mysterious fact is that the ASP.NET application can send e-mails from an adress within the same domain to an e-mail adress within the same domain, but not to any adress outside of the domain. But the Windows Forms application, that uses the exact same code, can send e-mails from any adress to any adress both within AND outside of the domain.
So to summarize:
The ASP.NET application can send
e-mails from addresses within the
domain to adresses within the domain,
but not to addresses outside of the
domain.
A Windows Forms application running
the same code on the same computer
can send e-mails from ANY address to
ANY address.
Another ASP.NET application on the
same IIS running under the same
account (NETWORK SERVICE) can send
e-mails using the same SMTP-server
from ANY adress to ANY adress.
There is no authentication configured
on the SMTP-Server.
Both the ASP.NET application and the
Windows Forms application utilizes
the System.Net.Mail.SmtpClient class
to send a
System.Net.Mail.MailMessage.
The code that sends the e-mail massage is:
private void button1_Click(object sender, EventArgs e)
{
MailMessage mesasge = new MailMessage(txtFrom.Text, txtTo.Text, "Test mail", txtBody.Text);
SmtpClient client = new SmtpClient();
if (!(string.IsNullOrEmpty(txtUserName.Text))) //Is false since txtUserName.Text is empty
client.Credentials = new System.Net.NetworkCredential(txtUserName.Text, txtPassword.Text);
client.EnableSsl = false;
client.Host = txtServer.Text;
client.Port = 25;
try
{
client.Send(mesasge);
}
catch (Exception ex)
{
txtResponse.Text = ex.Message;
}
}
As far as I can understand, this should be a matter of configuration rather than coding issues.
C# - Possible To Deploy Application As Desktop Application (with Server Component)
Jul 7, 2010Question: I created an ASP.NET web application. Now it originally was meant for deployment on a webserver.
That is working, so, so far so good. My question now is: Is it possible to deploy it as a desktop-application, too? That is to say the installer installs some kind of server, plus the web application, configures the server to run this application on a localhost URL, and then creates a link in the start menu/desktop, where it opens that url (website, the application) on localhost in a web browser?
I think it should be possible, though the server wouldn't be IIS, because this is a windows component which can't be separately installed. Is there anything like this already out there? The nonplusultra would be that it only starts the server when you click on the shortcut.
Web Forms :: Classes Of Web Application - Server Error In '/' Application?
Jul 21, 2010 i have classes of my web application only the default one work if i for example click a link to go to another class i get this error for each class this happens . But only on the web server WHy ?
Server Error in '/' Application.
Parser Error
Description:An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type 'WebApplication2.Login2'.
Source Error:[Code]....
Line 1: <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Login2.aspx.cs" Inherits="WebApplication2.Login2" %>Line 2: Line 3:
Source File: /Login2.aspx Line: 1
Converting A Client Application To A Server Application?
May 14, 2010I have written a program that interprets bar charts on the web and converts them into textual summaries. It is blind and visually impaired get more information during their web surfing. Anyways, right now all of the processing is handled on the user's machine and it is a very resource intensive program. So, I wanted to make it so the main computation was done by a server so that the user could simply click on a graph and get the summary instead of waiting while the computation was being done. Does anyone have a clue how to tackle this problem? If you need more information let me know.
View 8 Replies2.0 Application Never Loads Using The VS 2010 Application Server
Feb 21, 2011I have an application that runs perfectly fine locally using the VS 2010 application server, however, when I deploy to our web app machine startup just spins and spins and never loads. We have other apps on this same machine that load just fine (this is a debug deployment of same app in product). I have been spinning my wheels on this for days and I am at a loss as the problem could be. Here is what I did
1) Create a new directory (same level as other apps)
2) Copied over our existing test ([URL]) and it works fine
3) Build and publish new debug app ([URL]) and it just spins trying to load first form.
I know the diretory is "working" as the 'test' application I put there works fine.
SQL Server :: Server Error In '/staff' Application - Could Not Find Stored Procedure Dbo.aspnet_CheckSchemaVersion
Nov 27, 2010Server Error in '/staff' Application. Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. 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: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. Source Error:
[Code]....
Stack Trace:
[Code]....
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Write A Application Which Connects To Remote Server(windows 2003 Server
Jan 17, 2011I have to write a application which connects to remote server(windows 2003 server, open SQL Management studio in that server and enter a specific SQL Server address and access a stored procedure, change some values and execute the stored procedure.)
I have to write this application using C#.Net , Could anybody point me in right direction, Where do I start?
Security :: Service Call From Application Fails In Server 2008 (worked In Server 2003)
Jan 5, 2011We have a web application that makes a call to a remotely hosted ASMX service that worked in Server 2003 under IIS6. We are now migrating it to a Server 2008/IIS 7 setup and it doesn't appear that the application makes the call to the remote web service anymore. We ran Wireshark and don't see any traffic to the service URL. It seems to throw a 404 error without trying to connect.
Is there some security policy or restriction in Server 2008 or IIS 7 we need to set to allow an ASP.NET application make a call to a remote web service? We are using Network Service as our application pool user, but also tried using Local System as a troubleshooting step. In addition, the same code works if run from a console application on the server instead of the web application.
Is there some setting under IIS7 or server 2008 that would be causing this?
Server Push Technology - Develop Server Supported Application
Oct 28, 2010I would like to develop a server push supported application. Can anybody suggest which technology i should concentrate it reach this. I have already written a WCF Service using WS Binding. do i have to use JQuery? Commet? I have tried silverlight but it does support only polling. I am not looking for polling mechanism.
View 3 RepliesSQL Server :: What Will Happen If Two Application Servers Communicate One Database Server
Jan 12, 2011If i wanted to communucate from two application server to one SqlServer,what are the drawbacks if i implemented a senario like this, at the same time wat are the advantages.
View 5 RepliesServer Application Unavailable In IIS 5.0 With Window Server 2000?
Feb 5, 2010My application is in .NEt Framework 2. 0 and which i have deployed in window server 2000 . when i run this application it gives me error like . server application unavailable .
View 5 RepliesDeveloping Web Application With SQL Server Express And Server With 2008?
Jul 8, 2010I'am developing a web application with VS2010 Entity Framework and SQL Server Express. This application will be deploiyed in a server with SQL Server 2008 (not express) It is possible? What changes (if needed) i need to do?
View 2 RepliesServer Error In '/' Application. NETDB.MDF On Production Server
Jan 22, 2011I m getting the following error when i upload my site to Production Server using Database in App_Data ASPNETDB.MDF
Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current
ustom error settings for this
application prevent the details of the
application error from being viewed
[code]...
How To Access Remote Server( Ie., Want To Access Online Server Not Local Server) In Application
Sep 29, 2010I want to Access remote server( ie., want to access online server not local server) in my Application.. I change Settings in SQL surface Area Configuration---> Remote Connection ( checked the Local and Remote Connection ) Then while running the application it showing the following error.(I make off the firewall also) An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
View 1 RepliesSQL Server :: How To Terminate A SQL Server Query Within A VB Application
Jul 19, 2010In order to terminate a SQL Server query within a VB application, we use the Dispose method to close and dispose the database connection. That has been the only way we have found to actually stop a query from running and release the resources.
However, the next time a new connection is created to the same database, we are getting the error "'ObjectDisposedException - Safe Handle has been closed.". It seems like it is always trying to reuse the disposed connection from the connection pool, and it is not reinitializing it. By using a different connection string, we can avoid the error, since now it's not using the connection pool. But there must be a better way to either stop the query or to reinitialize the disposed connection.
Configuration :: "Server Error In '/' Application" When Run An Aspx File On Server Windows 2003 With IIS 6.0
Aug 9, 2010I am trying to run an aspx file on my server windows 2003 with IIS 6.0. I get the following error. Server Error in '/' Application. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local
server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
[Code]....
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
[Code]....
Javascript - JS: "The Callee (server [not Server Application]) Is Not Available And Disappeared." Accessing Window.opener?
Oct 1, 2010In our (quite large and old) ASP.NET application we use a lot of pages loaded into frames, iframes, and modal dialogs (using window.showModalDialog). We are starting to see the error above quite a bit, and I can't seem to find a single rational explanation for it anywhere.Popup Blockers. Nope. We're not running them. Not even the built-in blocker.Trusted Zone. Nope. The application runs on LocalHost right now, and it's in the trusted sites list.Stray Cosmic Rays. Possible, but not probable. It's way too consistent.
I did eventually find the error message buried on Microsoft's site in some dusty tome about retrieving automation error message information. In it, they were talking about Excel, and they said: "In this example, Microsoft Excel is the server application. Referencing a workbook object once it is destroyed (or closed) generates the error."That is probably as close as I've ever come to an explanation for the cause of the error, without a real, concrete explanation. Someone tried to use something after their reference to it was disposed of. Oddly, you can still see the windows on the screen. Curiously, however, this smacks suspiciously to me of the accepted answer to this.So here's what happens.
Page A is the main page.PageA displays PageB in a frame. PageB is a toolbar.PageA displays PageC in another frame. That's the content.PageC displays PageD in a nonmodal dialog. PageD, for reasons unknown to me, wants to modify the controls in PageB. It's trying to use window.opener to do that, and failing horribly.If someone could enlighten me as to why this is the case (the code works in FF), I'd appreciate it.
SQL Server :: Server Error In '/' Application
Aug 17, 2010[Code]....
Go to http://testxxxxx.com/to view web form
Migrate Application Running In Windows 2000 Server To Windows Server 2008?
Mar 10, 2010Currently we are running an application build in VB6,ASP,Commerce Server2000 and Sql Server 2000. This application is running in Windows 2000 server.Now we are planning to migrate Windows server 2000 to Windows 2008.Will this application run in Windows 2008 or do we need to upgrade this application to dotnet and Sql 2008?
View 1 RepliesSend Mail To Other Server (application And Mail Server On Different Locations) - How To Queue
Jan 10, 2011I am making mailing system and i am using SQL MAIL service and i need to send mail to other server(application and mail server on different locations).so i some how i need to use queue systems. for example if i send 5000 mail then it should go in batch of 500-500. if i write code in core vb.net then user need to stay untill all batches complete. so some how i need a system by which user just click and mail address fetching and sending process works in background as well send in batch.
View 4 RepliesHow To Fix Server Error In '/' Application?
Feb 8, 2011I am new to ASP.Net, I have created a sample website but when i am deploying it in IIS in windows server 2003, I am encountering the following error. Can anyone please help me to fix the following error Configuration Error
Description:An error occured during the processing of a configuration file required to service this request. Please review the s[ecific error details below and modify your configuration file appropriately.
Parse Error Message:Unrecognised attribute 'type'
Version Informatiom:Microsoft.Net Framework Version:1.1.4322.2379;ASP.NET Version:1.1.4322.2379
<configSection>
<SectionGroup name="system.web.extension" type="system.web.configuration.SystemwebExtensions SectionGroup,System.web.Extensions,Version=3.5.0.0 ,Culture=neutral,PublicKeyToken=31BF3856AD364E35">
Looking For A Server To Run A .net Framework Web Application?
Oct 11, 2010Is a server needed for the .net framework to run a .net web application on my local machine?The application is on my local machine and I have configured it in IIS. I am connecting a server(xxx). Does xxx need the .net framework to run a .net web application at my local machine?
View 2 Replies