Re: Debug stored procedures with VB6
From: Val Mazur (group51a_at_hotmail.com)
Date: 06/15/04
- Next message: Val Mazur: "Re: Can "properties" be added to an ADODB.Recordset?"
- Previous message: Val Mazur: "Re: compile error:"
- In reply to: Allcomp: "Re: Debug stored procedures with VB6"
- Next in thread: Allcomp: "Re: Debug stored procedures with VB6"
- Reply: Allcomp: "Re: Debug stored procedures with VB6"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 14 Jun 2004 23:00:46 -0400
Hi,
In a Query Analyzer you should open Object Browser, which shows all the
objects in a database. When you select stored procedure from the list and
right click on it to show popup menu, you will see debug option
-- Val Mazur Microsoft MVP "Allcomp" <fa097770@nospam.skynet.be> wrote in message news:40c5ce88$0$15468$a0ced6e1@news.skynet.be... > 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: Val Mazur: "Re: Can "properties" be added to an ADODB.Recordset?"
- Previous message: Val Mazur: "Re: compile error:"
- In reply to: Allcomp: "Re: Debug stored procedures with VB6"
- Next in thread: Allcomp: "Re: Debug stored procedures with VB6"
- Reply: Allcomp: "Re: Debug stored procedures with VB6"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
