Moving test ASP.NET application to live environment

[sgreenwest]

All,
i have been pulling my hair out all day. i just completed my first section of my new ASP.net application. The system uses SQL Server 2000 and vb.Net for code behind pages. I'm using visual studio 2002. My system is working fine on my local laptop but when I copied the file over to another computer to test it the stored procedures seem to to stop working. The system seems to work but i just cannot get the stored procedures to return any information from the database so i can log into the application. I used a backup from my local machine to create DB on the other computer. So i had to assign new permissions to the stored procedures. i can get some of them to work the other one just returns nothing.

Please Please Help ME

Simon

 

[ca8msm]

First of all, I would check the simple things like access permissions from your other computer to the database?

Can you access the database from Query Analyser on the other computer and do the sp's return any values when you run then from QA?

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[sgreenwest]

checked this the run fine in the QA. i just changed the code so the error is returned it says "Procedure or function EmployeeLogin has too many arguments specified

this SP works fine in the test environment.

just to let you know i new to SQL and .NET so please excuse my ignorance for simple things

any other ideas

 

[sgreenwest]

here is the stored procedure.

CREATE PROCEDURE EmployeeLogin 
	(
	 @userName varchar(50),
	 @password varchar(20),
	 @NurseID varchar(7) OUTPUT,
	 @Forename varchar(50) OUTPUT,
	 @Surname varchar(50) OUTPUT
	)
AS
	SELECT @NurseID = NurseID, @Surname = Surname, @Forename =  Forename
	FROM tbl_User
	WHERE userName = @userName
	AND userPassword=@password

	IF @@Rowcount<1
		BEGIN
			SELECT @NurseID=0
			INSERT INTO FailedLogons(UserName, password)
			values(@userName, @password)
		END
GO

 

[ca8msm]

The error is saying that you have given too many arguments to the EmployeeLogin procedure (I guess this is the SP).

What arguments does the SP want (how many, which ones) and what are you actually passing it (how many, which ones)?

I would make sure that you are actually accessing the same db and sp from both test and live (i.e. make sure you haven't got it set to a test database where the sp could potetially differ between db's).

----------------------------------------------------------------------

Need help finding an answer?

Try the search facilty (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.