Re: Debug stored procedures with VB6

From: Allcomp (fa097770_at_nospam.skynet.be)
Date: 06/08/04

  • Next message: DBAL: "Recordset or Object is closed HELP PLEASE!" 
    Date: Tue, 8 Jun 2004 16:35:02 +0200

    Thank you for your help,
    I can't see in the sql server analyser a tool to debug a stored procedure.
    Where is it exactly?

    For vb6, it still doesn't work, but I believe that it is because I have a
    WinXP French, VB6 English and MSDE English
    When I will need to reinstall my computer, I will try with a English Windows

    "Val Mazur" <group51a@hotmail.com> a écrit dans le message de
    news:%23kIyqfQTEHA.3844@TK2MSFTNGP11.phx.gbl...
    > Hi,
    >
    > Could be something missing from installation, but it is hard to say
    exactly.
    > Another way to debug your SPs is to use debugger directly from the Query
    > Analyzer, which ships with the SQL Server 2000.
    >
    > --
    > Val Mazur
    > Microsoft MVP
    >
    >
    > "Allcomp" <fa097770@nospam.skynet.be> wrote in message
    > news:40c01df8$0$8392$a0ced6e1@news.skynet.be...
    > > Hello,
    > >
    > > For the first link, it is not the case, I use the default instance name.
    > > For the second one : It doesn't work for the first one and with the
    sample
    > > to make it work with 2 stored procedures, I have the error two times.
    > > For the third one, I have already the value in the registery.
    > >
    > > I am sorry but it still doesn't work.
    > >
    > > Thank you for your help
    > >
    > > Marc Allard
    > > Allcomp
    > >
    > > "Val Mazur" <group51a@hotmail.com> a écrit dans le message de
    > > news:O4qpxgdSEHA.1764@TK2MSFTNGP10.phx.gbl...
    > >> Hi,
    > >>
    > >> Could be some issue described in a next KBs
    > >>
    > >> http://support.microsoft.com/default.aspx?scid=kb;en-us;310647
    > >>
    > >> http://support.microsoft.com/default.aspx?scid=kb;en-us;191513
    > >>
    > >> http://support.microsoft.com/default.aspx?scid=kb;en-us;172099
    > >>
    > >>
    > >> --
    > >> Val Mazur
    > >> Microsoft MVP
    > >>
    > >>
    > >> "Allcomp" <fa097770@nospam.skynet.be> wrote in message
    > >> news:e$lKxDUSEHA.2612@TK2MSFTNGP10.phx.gbl...
    > >> > Hello,
    > >> >
    > >> > I am trying to debug a stored procedure with VB6 on SQL Server
    > > Developper
    > >> > 2000.
    > >> >
    > >> > I always have a mistake. Searching the net, I have seen that I have
    to
    > >> > copy
    > >> > the files from the installation CD (x86\Other\Sdi ) to the
    > > mssqlServer\Bin
    > >> > directory and it still doesn't work.
    > >> > I have also sait MSSQLServer to start as administrator on the
    computer
    > >> > where
    > >> > it is installed.
    > >> > The error is "The query could not be debuged due to a problem
    > >> > coordinating
    > >> > events with the server. Check the server and client log to find the
    > > exact
    > >> > cause, fix the problem and try again"
    > >> > I have no event on the application, security and system log.
    > >> > My database is installed locally.
    > >> >
    > >> > Thank you
    > >> > Marc Allard
    > >> > Allcomp
    > >> >
    > >> >
    > >>
    > >>
    > >
    > >
    >
    >

  • Next message: DBAL: "Recordset or Object is closed HELP PLEASE!"

    Relevant Pages

    • Re: Create Storedprocedure with VB6? Is this possible?
      ... VB6 and ADO no .NET ... can SQL Server Management Studio." ... Can VB6 create a stored procedure on the fly. ... something similar) exactly what you're sending to the db engine (via ADO), ...
      (microsoft.public.vb.database.ado)
    • Re: testing with sql server
      ... Regarding your SQL Server 2000 debugging problems, ... version to debug with a sql server 2000 database. ... My goal is to debug some t-sql commands. ... attach to a process and the process that I need to attach to is ...
      (microsoft.public.sqlserver.setup)
    • Re: Walkthrough Instruction Error
      ... behave the same as if run from outside of the IDE ??? ... working in VB6, I really wasn't expecting it to be that very very bad. ... It's cute, but hardly practical given you can't run it from the IDE, can't debug it etc, etc. ... folks in .NET groups first what they think about this idea. ...
      (microsoft.public.vb.general.discussion)
    • Re: T-SQL and OLE Automation
      ... A library created as type ActiveX.exe will run out of the SQL Server ... To deploy a .dll, you make it, using the VB6 file/make command, then copy to ... Creating COM libraries with VB6 is probably better discussed in a VB ... > OLE automation and I'm not sure how to write the application on the VB6 ...
      (microsoft.public.sqlserver.programming)
    • Re: T-SQL and OLE Automation
      ... components from VB6 now that VB.Net is so well established as that code will ... Choose a path to save the .dll & remember where it is. ... If you are running your SQL Server on that machine, ... >> Greg Linwood ...
      (microsoft.public.sqlserver.programming)
    Loading