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. No error or anything.

Please Please Help ME

Simon

 

[SQLSister]

If you run the sp in Query Analyzer, do you get nothing?

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[sgreenwest]

i did run it though the query analyser and it seemed to work ok. But i've just noticed a problem with it. Something happened when i backed up DB and restored it. Some of the output parameters in the stored procedure got wiped out of the file so i copied the developemnt ST over the backed up one an it fixed the problem. I now have another problem but thats for another post.

Thanks for the quick response

Simon