BUG: T-SQL Debugger Does Not Run on NT with User Account

Article translations Article translations
Article ID: 175868 - View products that this article applies to.
This article was previously published under Q175868
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SYMPTOMS

T-SQL Debugger causes the following error when a stored procedure is called if the Visual Basic 5.0 application is being run on an NT 4.0 or Windows 2000 machine where the login was to a User Account:
"You must have Privledges to modify the registry"
Note The word "Privileges" is misspelled in the error message.

Visual Basic will hang when the application is ended and the task manager must be invoked to shut it down.

RESOLUTION

Use an login account that has administrator rights.

STATUS

This is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Login into an NT or Windows 2000 server with administrator privileges.
  2. Create a stored procedure on Sqlserver 6.5 by running the following code in ISQL/W:
          CREATE PROCEDURE findstate @whichstate char(2) as
          select * from authors where state= @whichstate
    						
  3. Create a Visual Basic Project and check "Microsoft Remote Data Object 2.0" under Project References.
  4. Under Add-Ins Manager, check Visual Basic T-SQL Debugger. Under Tools, T_SQL Debugging Option make sure both check boxes are checked. See references mentioned below for setting up T-SQL Debugger.
  5. Place two CommandButtons on the form. Paste the following code in the form:

    Note You must change Username=<username> and PWD=<strong password> to the correct values before you run this code. Make sure that Username has the appropriate permissions to perform this operation on the database.
             Option Explicit
               Dim cn As rdoConnection
               Dim qy As rdoQuery
               Dim rs As rdoResultset
               Dim strConnect As String
               Dim n As Integer
    
             Private Sub Command2_Click()
                rs.Close
                Set rs = Nothing
                unload me
             End Sub
    
         Private Sub Command1_Click()
    
            strConnect = "driver={SQL Server};server=servername;" & _
              "database=pubs;Username=<username>;PWD=<strong password>;"
            rdoEnvironments(0).CursorDriver = rdUseOdbc
            Set cn = rdoEnvironments(0).OpenConnection( _
              dsName:="", _
              Prompt:=rdDriverNoPrompt, _
              ReadOnly:=False, _
              Connect:=strConnect)
    
            Set qy = cn.CreateQuery("sql", _
                    "{call pubs.dbo.findstate(?) }")
            qy.RowsetSize = 1
            qy.rdoParameters(0) = "CA"
            Set rs = qy.OpenResultset( _
              Type:=rdOpenForwardOnly, _
              LockType:=rdConcurReadOnly)
    
            While Not rs.EOF
              debug.print rs(0) & ", " & rs(1)
              rs.MoveNext
            Wend
    
          End Sub
    						
  6. Place a break point on the procedure call line.
  7. Run the code and T-SQL debugger should come up.
  8. Press the F5 key and it should continue.
  9. Close Visual Basic and restart NT. Login to User Account.
  10. Open the same project making sure T-SQL debugger is activated.
  11. Run the application and the error will appear.

REFERENCES

Visual Basic Books Online, query on "t-sql debugger," use quotes.

Hitchhiker's Guide to Visual Basic & SQLserver. pp411-413

For additional information about T-SQL Debugger for setup problems, click the following article numbers to view the articles in the Microsoft Knowledge Base:
166280 DOC: T-SQL Debugger Server Setup Provides Incorrect Location
172099 PRB: T-SQL - Running Remote and Local SQL Debugging

Properties

Article ID: 175868 - Last Review: February 27, 2014 - Revision: 2.2
APPLIES TO
  • Microsoft Visual Basic 5.0 Enterprise Edition
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
Keywords: 
kbnosurvey kbarchive kbbug KB175868

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com