BUG: Visual InterDev 6.0 or Visual J++ 6.0 Crash when Editing HTML with RDS Objects

ID: Q200683

The information in this article applies to:

Microsoft Visual Studio 6.0
Microsoft Visual Studio, Professional Edition 6.0
Microsoft Visual Studio, Enterprise Edition 6.0
Microsoft Data Access Components version 2.0
on the following platforms: x86
Microsoft Visual J++, version 6.0

SYMPTOMS

You may encounter "random crashing" with Visual InterDev 6.0 or Visual J++ 6.0 when editing Active Server Pages (ASP) or HTML pages that have HTML <OBJECT> references to RDS DataControl objects (CLSID:BD96C556-65A3-11D0-983A-00C04FC29E33). Here's a sample error message:

Devenv.exe Exception: access violation (0xc0000005), Address: <address>

CAUSE

The crash will occur if the RDS DataControl parameters (Server, Connect, SQL) are specified using the <PARAM> tag as in the following example:


  <OBJECT classid="CLSID:BD96C556-65A3-11D0-983A-00C04FC29E33"
    ID=Authors height=0 width=0
    PARAM name=Server value="http://myserver"
    PARAM name=Connect value="dsn=pubs;uid=***;pwd=***;"
    PARAM name=SQL value="SELECT * FROM Authors"
  </OBJECT>

The development shell for Visual InterDev 6.0 and Visual J++ 6.0 will attempt to access the RDS data at design time if the <PARAM> tags for the Server, Connect and SQL properties are specified as a part of the OBJECT tag. This behavior exposes a bug in Microsoft's Data Access Components version 2.0, which closes an asynchronous thread, then later tries to reference the closed thread, causing the crash.

RESOLUTION

To work around this bug, specify these properties in script, as in the following example:


  <OBJECT classid="CLSID:BD96C556-65A3-11D0-983A-00C04FC29E33"
    ID=Authors height=0 width=0
 </OBJECT>
  <SCRIPT Language=VBScript>
    Authors.Server  = "http://myserver"
    Authors.Connect = "dsn=pubs;uid=***;pwd=***"
    Authors.SQL     = "SELECT * FROM Authors"
    Authors.Refresh
  </SCRIPT>

The code will function at run time and avoid the bug at design time.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Additional query words: kbDSupport

Keywords : kbVisID kbVJ600 kbVS600bug
Version : WINDOWS:2.0,6.0
Platform : WINDOWS
Issue type : kbbug