Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 10th, 2005, 12:55 PM
Authorized User
 
Join Date: Jul 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default asp and ms sql stored procedures

Is this method of calling a stored procedure considered to be safe from (SQL Injection) and efficient in terms of (speed):

dim objConn,rs

sub openDB()

set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "PROVIDER=SQLOLEDB;DATA
SOURCE=127.0.0.1;UID=papa;PWD=mama;DATABASE=Mix"

end sub

sub closeDB()

objConn.Close
set objConn = nothing

end sub


openDB()

objConn.usp_InsertCustomer firstname,lastname,companyname,phone,email,passwor d,address,zip,"kl",city,country,CInt(1),Request.Se rverVariables("REMOTE_HOST")

CloseDB()


Regards

Eugene

 
Old July 11th, 2005, 12:04 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Hi,
Please check the following URL:
http://support.microsoft.com/kb/q164485/

Om Prakash





Similar Threads
Thread Thread Starter Forum Replies Last Post
the SQL stored procedures BenCh BOOK: ASP.NET Website Programming Problem-Design-Solution 0 March 11th, 2005 04:18 PM
Crystal 9 and stored procedures with dynamic sql Pravs VB How-To 0 December 9th, 2004 05:48 AM
stored procedures and MS Access madhukp Classic ASP Basics 5 August 26th, 2004 12:22 AM
Vars passed to SQL Stored Procedures deanglass ASP.NET 1.0 and 1.1 Basics 1 March 15th, 2004 05:35 PM
Professional Sql Server 7 Stored Procedures Darrell Clary All Other Wrox Books 0 October 8th, 2003 09:31 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.