Calling stored procedures in VB 6

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bruce
    #1

    Calling stored procedures in VB 6

    I have a good connection to the SQL Server but, it can't
    find the stored procedures that I wrote and placed there.
    They are in the Master DB and work. The connection method
    and open recordsets work, but when I add the command "EXEC
    sp_name " into the open statement it keeps saying it can't
    find the stored Procedure. Obviously it knows to expect
    the SP but the method of defining it is wrong. I'be tried
    variations of BMname..SPname and none work? Help.

    Bruce Gilbert
    sofiyacute@msn. com
    Tags: None
    • Cor
      #2
      Re: Calling stored procedures in VB 6

      Hi Bruce,

      I do not know what it is in VB6 it is something as this in VB.net

      Dim cmd As New SqlCommand("EXE CUTE MyDatabase.dbo. SelectProc", conn)

      But maybe you can get your answer for VB6 in one of the VB classic
      newsgroups

      microsoft.publi c.VB*

      Cor[color=blue]
      > I have a good connection to the SQL Server but, it can't
      > find the stored procedures that I wrote and placed there.
      > They are in the Master DB and work. The connection method
      > and open recordsets work, but when I add the command "EXEC
      > sp_name " into the open statement it keeps saying it can't
      > find the stored Procedure. Obviously it knows to expect
      > the SP but the method of defining it is wrong. I'be tried
      > variations of BMname..SPname and none work? Help.
      >[/color]


        Comment

        • Herfried K. Wagner [MVP]
          #3
          Re: Calling stored procedures in VB 6

          * "Bruce" <sofiyacute@msn .com> scripsit:[color=blue]
          > I have a good connection to the SQL Server but, it can't
          > find the stored procedures that I wrote and placed there.
          > They are in the Master DB and work. The connection method
          > and open recordsets work, but when I add the command "EXEC
          > sp_name " into the open statement it keeps saying it can't
          > find the stored Procedure. Obviously it knows to expect
          > the SP but the method of defining it is wrong. I'be tried
          > variations of BMname..SPname and none work? Help.[/color]

          Notice that there is a separate group available for ADO.NET questions:

          ADO.NET group:

          <news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.adonet>

          Web interface:

          <http://msdn.microsoft. com/newsgroups/default.asp?url =/newsgroups/loadframes.asp? icp=msdn&slcid= us&newsgroup=mi crosoft.public. dotnet.framewor k.adonet>

          --
          Herfried K. Wagner [MVP]
          <http://www.mvps.org/dotnet>

            Comment

            • Cor
              #4
              Re: Calling stored procedures in VB 6

              Hi Herfried,

              I thought VB6 did not work with Ado.net is there a new release?

              :-))))

              Cor[color=blue]
              >
              > Notice that there is a separate group available for ADO.NET questions:
              >
              > ADO.NET group:
              >
              > <news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.adonet>
              >[/color]


                Comment

                • Herfried K. Wagner [MVP]
                  #5
                  OT: Re: Calling stored procedures in VB 6

                  * "Cor" <non@non.com> scripsit:[color=blue]
                  > I thought VB6 did not work with Ado.net is there a new release?[/color]

                  Sorry :-(...

                  --
                  Herfried K. Wagner [MVP]
                  <http://www.mvps.org/dotnet>

                    Comment

                    Previous template Next
                    Working...