VB Migration Partner

KNOWLEDGE BASE - Database and data-binding


Previous | Index | Next 

[PRB] Passing an ADO read-only property to a ByRef argument causes a COMException

When a property is used as an argument to a method, VB6 passes the property’s value using by-value semantics, regardless of whether the receiving parameter is declared with the ByRef keyword. Under the same circumstances, however, VB.NET passes the property’s value using by-reference semantics. This detail can cause a runtime exception when the property is one of those exposed by the Connection, Recordset, and other ADODB objects. Consider the following VB6 code:

    Sub Test(fld As ADODB.Field)
        ByRefProc fld.DefinedSize
    End Sub

    Sub ByRefProc(n As Short)
        ' any code here
    End Sub

Even if the ByRefProc method doesn’t modify the incoming value, when the method exits VB.NET attempt to assign the (unmodified) value back to the DefinedSize property of the ADODB.Field object. This attempt cases a COMException error with the following message:

    Operation is not allowed when the object is open

This problem occurs only because a few ADODB properties become nonwritable when the Connection or Recordset object is open. It never occurs if the property is always read-only, because in that case VB.NET doesn’t attempt the assignment on exiting the method.

The obvious fix for this problem is using ByVal in the definition of the method’s parameter, if possible. If it isn’t possible, at least ensure that the VB6 code passes a copy of the property’s value:

    Sub Test(fld As ADODB.Field)
        ByRefProc (fld.DefinedSize)     ' use parenthesis to force by-value semantics
    End Sub
Previous | Index | Next 




Follow Francesco Balena on VB6 migration’s group on

LinkedIn





Read Microsoft Corp’s official case study of a VB6 conversion using VB Migration Partner.




Code Architects and its partners offers remote and onsite migration services.

More details




Subscribe to our free newsletter for useful VB6 migration tips and techniques.

newsletter



To learn more about your VB6 applications, run VB6 Analyzer on your source code and send us the generated text file. You will receive a detailed report about your VB6 applications and how VB Migration Partner can help you to quickly and effectively migrate it to .NET.

Get free advice



A fully-working, time-limited Trial Edition of VB Migration Partner allows you to test it against your actual code

Get the Trial




The price of VB Migration Partner depends on the size of the VB6 application, the type of license, and other factors

Request a quote




Migrating a VB6 application in 10 easy steps

Comparing VB Migration Partner with Upgrade Wizard

Migration tools: Feature Comparison Table

All whitepapers