471,854 Members | 1,925 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,854 software developers and data experts.

pros and cons of using stored procedures for VB app ?

Hi,

Just wondering what sort of problems and advantages people have found using
stored procedures. I have an app developed in VB6 & VB.NET and our
developers are starting to re-write some of the code in stored procedures
(im advocating encryption of them). When deploying an application however
stored procedure seem to add another level of complexity to installation. In
future we also plan to have an basic ASP app with some of the functionality
of the VB app.

What are the pros and cons of using stored procedures in the situation?

PRO
- can call same stored procedure for ASP pages which saves us writing again

CON
- more complex deployment (i.e sending a bug fix will involve shipping DLL
and SQL script for stored procedure).

Thanks for any input
Scott

pros and cons of using stored procedures for VB app ?
Aug 18 '05 #1
2 2646
My first question that springs to mind is why mix VB6 and .NET, Why not
develop your VB6 components in .NET?

Pros of using stored procedures
====================
Less chance of the application being open to SQLInjection hacks.
Developer (front end) does not need to know the structure of the database
Developer (back end, DBA) can lock down access to DB items = more secure DB

Complexity of deployment
=================
You will only need to adjust your stored procedures if you have released
them containing bugs, and I'm sure your DBA doesn't do that.
I'm sure there's a lot more to say on this subject, but right now, off the
top of my head the above is what springs to mind. Oh yes, this applies to ALL
dev languages, not just VB6.

--
Of all words of tongue and pen, the saddest are: "It might have been"

Bill.Richards @ greyskin .co .uk
http://greyskin.co.uk
"scott" wrote:
Hi,

Just wondering what sort of problems and advantages people have found using
stored procedures. I have an app developed in VB6 & VB.NET and our
developers are starting to re-write some of the code in stored procedures
(im advocating encryption of them). When deploying an application however
stored procedure seem to add another level of complexity to installation. In
future we also plan to have an basic ASP app with some of the functionality
of the VB app.

What are the pros and cons of using stored procedures in the situation?

PRO
- can call same stored procedure for ASP pages which saves us writing again

CON
- more complex deployment (i.e sending a bug fix will involve shipping DLL
and SQL script for stored procedure).

Thanks for any input
Scott

pros and cons of using stored procedures for VB app ?

Aug 18 '05 #2
thanks for the reply bill. im 100% happy stored procedures are the way to go
now ..... no doubts at all.

using mixed vb6 and .net because of third party app restrications at the
moment ..... soon to be erradicated but got about 1200 vbp's to work through
and it will take time.

cheers for your time
scott
Aug 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Axehelm | last post: by
17 posts views Thread by Oldgradgreg | last post: by
5 posts views Thread by Fred | last post: by
24 posts views Thread by Ronald S. Cook | last post: by
3 posts views Thread by Andrea | last post: by
NeoPa
reply views Thread by NeoPa | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.