Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sproc or embedded SQL?

Status
Not open for further replies.
Beesknees

Beesknees

Programmer
Feb 27, 2001
95
GB
I have come from a firm where it was common to embed sql into their inhouse VB app's. My new work has used stored procedures for every database function the app has to do leading to nearly a hundred sproc's in per database! My question is this: What is the industry standard considering this is a mid-sized firm (500 users), COM is not really used but may be a good option. The SQL Servers are stable and unlikely to change names etc. All opinions (even those biased towards VB) are greatly appreciated. Personally I lean towards COM with ADO Prepare statements.
Thanks!
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
how to send SMS via free API or other service
Replies
2
Views
472
strongm
strongm
sal21
  • Locked
  • Question
Check if mobile number exists, with Api rest or other service. Possibile? 1
Replies
2
Views
358
sal21
sal21
sal21
  • Locked
  • Question
possible to load a .png image in picturebox or image 1
Replies
7
Views
736
Andrzejek
Andrzejek
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
372
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
Incorporate or insert the Italy map with the mouse move event in a form?
Replies
19
Views
493
sal21
sal21

Part and Inventory Search

Sponsor

Back
Top