Question on Database Project

  • Thread starter Thread starter nashak
  • Start date Start date
N

nashak

Hello,


I'm working on a asp.net project under VS-2003. I have created a
database project and connected to my database and created some stored
procedures. When I run my app, I get the error - "Stored procedure not
found".

I'm sure I'm missing some step to either compile this SP or do
something so that my code recognises the SP.

Could someone point me to the right direction or provide step by step
details on how to create a DB project and how to create SP in VSTudio
and go from there?

Thanks,
 
Hello,


I'm working on a asp.net project under VS-2003. I have created a
database project and connected to my database and created some stored
procedures. When I run my app, I get the error - "Stored procedure not
found".

I'm sure I'm missing some step to either compile this SP or do
something so that my code recognises the SP.

Could someone point me to the right direction or provide step by step
details on how to create a DB project and how to create SP in VSTudio
and go from there?

Thanks,
Click to expand...
You will find all the help you need in the vs help.
 
This means that either you're initial catalog is pointing to the wrong
database, you don't have rights to access the SPs or you created the SPs in
the wrong database.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Thanks for your response. However, my original question still stands,
if you don't mind...
 
Sorry. The answer is pretty involved. That's why I write books. Most of my
books (old and new cover this).

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Bill,

That wasn't for you. That was for Ron...

I do not know how it appeared after your response. When I'd checked it
last I'd seen only Ron's reply...
 
Bill,

What i actually did was create SP in VisualStudio. Hence I did not do
anything in Ent Mgr etc. while creating SP.

So in a nutshell - Created new solution in Studio. created a database
project and bound it to my database. Created SP in Studio. Now what are
the next steps to make this SP run?

Thanks,
 
I may not fully understand the issue but if you created the SP in VS, where
is it at run time. The SP needs to be placed in the database - at least that
is how I do it?

Wayne
 
You might want to consider using the Developer edition of SQL Server
to create the database objects for your asp.net application. Although
you can create stored procedures in Visual Studio, it does have all of
the tools you need to create, tune and secure a SQL Server database.
The Developer edition costs $49 US and the license agreement prohibits
you from using it in production. See
http://www.microsoft.com/sql/howtobuy/development.mspx for more
information.

--Mary
 
Back
Top