BUG: SQL-DMO Call GetObjectByName May Cause GPF Under VBA

• Microsoft SQL Server, version 6.0

SYMPTOMS

When you use the SQL-DMO function ::GetObjectByName in the Visual Basic for Applications environment, you may encounter a general protection (GP) fault.

A GP fault could occur when a call to the ::GetObjectByName function is invoked, resulting in the message:

   The instruction at "0x1d0fc7cd" referenced memory at "0x73737373"
   The memory could not be read.

CAUSE

If a second parameter is explicitly passed to ::GetObjectByName rather than using its default value, the GP fault is encountered.

WORKAROUND

The ::GetObjectByName does not exhibit the same behavior when used in the C/C++ environment. Both the default and a specific object type can be provided, as shown below:

   LPSQLOLEDBOBJECT pSQLObject;

      pSQLDatabase->GetObjectByName("authors", &pSQLObject);

     pSQLDatabase->GetObjectByName("authors",
               &pSQLObject, SQLOLEObj_UserTable);

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.