I have a linkbutton and when it's clicked it creates a variable (being the text of the linkbutton) and then it needs to run another procedure.Here's how it looks at the moment:
[Code]....
'lookup' is the name of the other procedure I need to run but I don't know what to put in the brackets. I am currently getting the error: No overload for method 'lookup' takes '0' arguments.
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?
I am using the following procedure. But when i running the procedure with multiple values it is getting error as given below. But single value specification is working fine. Ho to use dynamic query. But i am not willing to use it. solve the issue "Conversion failed when converting the varchar value ''1','2'' to data type int." My Query is:
[Code]....
Using asp.net MVC in c#, I am making a call to a stored procedure using Linq into my SQL Members table. I have no internal caching on the application, already checked to make sure it is turned off.
Test case:I have my username set to test1. From the website I change my username to test2. The website still shows test1. I go to Management Studio and run my stored procedure called MemberByEmail, it shows test2 correctly.I start simple, refresh my page to see if it's browser cache, still test1. I go to debugging and walk through the code and find that it goes correctly all the way to here to call the database:
/// <summary>Method that is mapped to the dbo.MemberByEmail database procedure.</summary>
/// <returns></returns>
[System.Data.Linq.Mapping.Function(Name="dbo.MemberByEmail")][code]...
Again I ran the stored procedure through Management Studio, and it came up with test2 as the username. I waited for 15 minutes, refreshing the web page every 5 or so, and it never cleared and served the correct test2 from the db. The last strange piece, I ran IISReset and refreshed the page, test2 was returned.
UPDATE: I created a console application to take out the web piece of it. The problem is the same when accessing directly from a console app also, no change.
I am trying to run a Stored Proc in 2008 using the sql agent. I read some posts on here and other places that say you can and I have tried what they said but isn't running. I can execute the proc form a query window and its working fine so its not my proc.I setup a job and then created a step named the step run stored procType: not sure here but I left it at default T-SQLChanged the database to the database where my sp is located Then in command i put exec dbo.sp_myprocname
View 2 RepliesI have a site that calls a long running stored procedure that eventually times out the UI. The procedure simply runs some logic in the database, and kicks of a secondary process. No data is ever returned to the UI, so I don't need the UI to wait for anything.Is there a way to call the stored procedure from the UI and move on without having the UI having to wait for the store procedure to complete?
View 4 Replies[Code]....
i have a stored procedure with this values and i need just to make a button that will send something to "Equip" column,how to do it? write the values on my webpage and make a button to exec the procedu
I am trying to create the following stored procedure in sql server Lat and Lng are the parameters being passed from c# code behind .But I am not able to create this stored procedureit indicates with error saying undefined column name Lat,Lng
CREATE FUNCTION spherical_distance(@a float, @b float, @c float)
RETURNS float
AS
BEGIN
RETURN ( 6371 * ACOS( COS( (@a/@b) ) * COS( (Lat/@b) ) * COS( ( Lng/@b ) - (@c/@b) ) + SIN( @a/@b ) * SIN( Lat/@b ) ) )
END
sqlda.SelectCommand.CommandText = "select *, spherical_distance( Lat, 57.2958, Lng) as distance
from business
[code]...
I want to apply other stored procedure select query on result of first stored procedure.
View 1 Repliessing VS 2008 at a workstation, I have successfully developed a local, file-system ASP.NET 3.5 website. The wbesite included a membership page with Windows authentication and a web parts page. The SQL Server 2005 ASPNETDB database has been created at an IIS web servr. Using the ASP.Net development server of the workstation, both the membership Membership/WebParts pages at the local website worked very well.
Then, I copied the website to a virtual directory at the IIS web server and creates a remote website for the workstation. Under theASP.NET development server of the workstation, both membership and webparts pages of the remote website at the IIS web server also worked fine.
However, when running these web pages from the IIS web server machine, something wrong happened with the web parts page. (The membership page still worked very well.) For the ASPNETDB database at the IIS web server machine, there is an EXECUTE permission error on an ASPNET stored procedure.
What are the differences between the ASP.NET development server and IIS web sever, which caused the EXECUTE permission error on the ASP.NET S.P.? How to find and fix the errors?
How can I Alter a Procedure from another one procedure?
View 2 RepliesThis is surareddy. i nead some small clarification in the "Stored Procedure"
how to convert the oracle Stored Procedure to sqlserver2005/2008 Stored Procedure.
right now i am enhancing the project that project already developed the oracle Stored Procedure. now our company is using sqlserver 2005/2008.
how to convert the Oracle Stored Procedure to sqlserver 2005 Stored Procedure
Initially, I have tried to use stored procedure. But I changed my mind and preferred to call sql query in codebase with command text. However, it stills tries to find initially-called stored procedure (which is neither called or exists).I think that it is related caching. But I tried it with different browsers it did not work.What might be the reason?
View 4 RepliesI could probably figure this out if I tried to, but I have been working so long on code, I'm a little fried
I have a stored procedure, and I want to execute another stored procedure during a time period of lets say 1/1/2011 to 12/31/2011
How Would I accomplish this?
Does anybody if it is possible that a stored procedure returns rows which is the result of the execution of another sp? Something like..
[Code]....
i want to return output parameter from 1 storeprocedure. into another stored procedure.
View 7 Replieshow can I create stored procedure and write my select statement in it, I know how to create dataset then put type stored procedure and assign it to the sp ... what I want is writing my sp... how can I make it ?
check the following code, this is what I want to write put I don't know where or how !
CREATE STORED PROCEDURE SP_CATEGORY
@CATEGORY VARCHAR(30)
AS
BEGIN
SELECT LATIN_NAME, ENGLISH_NAME, ARABIC_NAME, CATEGORY
FROM FLORA, CATEGORY_LIST
WHERE FLORA.CATEGORY=CATEGORY_LIST.CATEGORY_NAME AND CATEGORY_LIST.CATEGORY_NAME IN (SELECT * FROM SPLITLIST(@CATEGORY, ','))
END
where can I write this code ?!
I have created stored procedure and student database and also asp.net application for asp.net page but it could not found stored procedure what is the mistake actually I don't no
View 7 RepliesHow can I execute a stored procedure that takes in parameters without having to specify the prameters name? The name of the parameter in the stored procedure may change from CustomerID to CustID so I don't want to have to keep changing my code.Rather than doing what is provided below where you specify the parameter name -
command.Parameters.Add("@dtStart", SqlDbType.DateTime);
command.Parameters["@dtStart"].Value = startDate;
command.Parameters.Add("@CustomerID", SqlDbType.NChar);
command.Parameters["@CustomerID"].Value = customerID;
I am looking to do something like this -
command.Parameters.Add(startDate, customerID);
All I want to do is learn how to create a class procedure. And then. How to call it. As an example, A + B = C is the procedure. I would create a class. Right? Then do I name the procedure and put it in the class? Or create a new class for each procedure? Then I would want to, on a local level, substitue values for A & B to return C. So, if the public procedure exists, how to I call it? I know that this is really simple stuff, but I need examples to be simple.
View 1 RepliesThis is my code. Here I want to retrieve return value of stored procedure. when I am executing this, I am receiving exception as string[1] string invalid index[0].
[code].....
I have migrated a database from one server to another and following the migration had an orphaned user (WholeSystem_webuser), which has been fixed using the auto_fix option of sp_change_users_login
•The WholeSystem_webuser account is used by ASP.NET pages to connect to the database and run stored procedures.
•I can log in to Management Studio as WholeSystem_webuser OK and execute the sp's from there
•When I try to run my ASP.NET page it was saying “Can’t find stored procedure [procedure name]”
•If I drop the sp and create it as [dbo].[GetContactsCount] instead of [WholeSystem_ webuser]. [GetContactsCount] it says “The EXECUTE permission was denied on the object 'GetContactsCount', database 'WholeSystem', schema 'dbo'.” (which is what I’d expect as the connection string is using the WholeSystem_webuser account??) –does that show that the web user is logging into the database OK??
•If I try and configure the SqlDataSource in VWD to see what it is looking at though, it won’t let me get beyond the connection string window and says “Default schema could not be retrieved for this connection”
•I tried setting up a new login/user/connection string but still get the
“Default schema could not be retrieved for this connection” error
IN SQL Server:
•Users mapped to the login WholeSystem_webuser - WholeSystem_webuser, default schema dbo
•User WholeSystem_webuser has default schema dbo and db_dataread and db_datawrite permissions
•There is a schema dbo whose owner is dbo, and a schema WholeSystem_webuser whose owner is WholeSystem_webuser
I am using sqldataadapter for my gridview, but it doesn't talk with stored procedure. How can I use it with stored procedure?
View 2 RepliesI have stored procedure in my database but its give error "Could not find stored procedure"Is this error occuring when maked error in permision,sp code or connection code
View 3 RepliesI am trying to re-write an existing asp.net website using MVC with Linq to SQL. A page we have is used to insert new contracts and uses usp_contract_insert to insert a new contract into t_contract as well as t_project. On my dbml file i have dragged t_contract on and then I try to drag usp_contract_insert on top of that and I get the error :- Microsoft Visual Studio
One or more selected database objects return a schema that does not match the schema of the target data class. Nothing has been added to the designer. The stored procedure returns the id of the last project which was inserted. I don't quite follow this and unsure how to go about hooking my Controller up using Linq to SQL to call this stored procedure