Results 1 to 3 of 3

Thread: calling SqlServer stored proc using ASP

  1. Mar 12th, 2001, 03:15 PM #1
    sarath_777
    sarath_777 is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Posts
    65
    hi,
    i am trying to use stored procedures written in SQLServer and calling from Activer Server pages.
    How this is done ? I have called stored procs from VB
    applications.
    Is it different while calling from ASP ?
    thanks
    sarath
    Reply With Quote Reply With Quote
  2. Mar 13th, 2001, 08:04 AM #2
    Guest
    It is the same:

    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open YourConnectString

    Conn.Execute usp_YourStoredProc @param1 = param1, @param2 = param2

    you can also execute stored proc through recordset objects and command objects.
    Reply With Quote Reply With Quote
  3. Mar 13th, 2001, 02:36 PM #3
    sarath_777
    sarath_777 is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Posts
    65

    thanks bubba..

    i see that it is no different from vb..
    thanks
    sarath
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width