p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: SQL Server Stored Programs


Message #1 by "Dave Fashenpour" <davefash@m...> on Tue, 4 Jul 2000 19:3:52
I am implementing the downloaded code for Chapter 3 (ADO 2.5 RDS 

Programming with ASP 3.0) -- Executing Stored Procedures from ASP.

My SQL Server is remote at a web site that has given me SQL 

access to the database, but NOT to Query Analyzer.

 

Simple Question.

 

How can I store a Stored Procedure into SQL Server via a SQL connection?  

(i.e. no Enterprise Manager/Query Analyzer access)



Will appreciate any assistance.



Dave Fashenpour

mailto:davefash@m...

Message #2 by "Ravi Kumar" <ravik@w...> on Wed, 5 Jul 2000 18:27:35 +0530
By writing a 'C' program either using db library or ODBC, you can create a

stored procedure i.e. store a stored procedure.



RK



----- Original Message -----

From: Dave Fashenpour 

To: ASP Databases <asp_databases@p...>

Sent: Tuesday, July 04, 2000 7:00 PM

Subject: [asp_databases] SQL Server Stored Programs





> I am implementing the downloaded code for Chapter 3 (ADO 2.5 RDS

> Programming with ASP 3.0) -- Executing Stored Procedures from ASP.

> My SQL Server is remote at a web site that has given me SQL

> access to the database, but NOT to Query Analyzer.

>

> Simple Question.

>

> How can I store a Stored Procedure into SQL Server via a SQL connection?

> (i.e. no Enterprise Manager/Query Analyzer access)

>

> Will appreciate any assistance.

>

> Dave Fashenpour

Message #3 by "Ken Schaefer" <ken.s@a...> on Thu, 6 Jul 2000 11:37:10 +1000
You could use T-SQL...just create  connection to the database and execute

your T-SQL statement against the connection...



Cheers

Ken



> ----- Original Message -----

> From: Dave Fashenpour

> To: ASP Databases <asp_databases@p...>

> Sent: Tuesday, July 04, 2000 7:00 PM

> Subject: [asp_databases] SQL Server Stored Programs

>

>

> > I am implementing the downloaded code for Chapter 3 (ADO 2.5 RDS

> > Programming with ASP 3.0) -- Executing Stored Procedures from ASP.

> > My SQL Server is remote at a web site that has given me SQL

> > access to the database, but NOT to Query Analyzer.

> >

> > Simple Question.

> >

> > How can I store a Stored Procedure into SQL Server via a SQL connection?

> > (i.e. no Enterprise Manager/Query Analyzer access)

> >

> > Will appreciate any assistance.

> >

> > Dave Fashenpour






  Return to Index