BUG: ODS App. GP Fault when SQL Admin Runs Full DB Properties

  - Microsoft SQL Server version 4.2

SYMPTOMS

An Open Data Services application will general protection fault (GP fault) with a stack overflow when a user selects Manage, Database, Properties, Full from the Database Management window in SQL Administrator.

CAUSE

When a user selects Manage, Database, Properties, Full from the Database Management window, SQL Administrator examines the allocation pages directly to determine exactly how much space is available in the database. Open Data Services was not intended to process this kind of request.

WORKAROUND

If a user needs to use the Full Database Properties function of SQL Administrator, the user must not connect though the ODS application, but should connect directly to the SQL Server. To prevent the ODS Application from having a GP fault, code must be added to check for the language event caused by this action.

In the language event handler, if a language event that looks like

   dbcc dbrepair(<dbname>,readpage,<page number>)

   #define SRV_NOT_SUPPORTED   SRV_MAXERROR + 5 //as an example

   // Check to see if this is a command we cannot handle
   // First check for dbcc
   if (strstr(query, "dbcc") != (char *)NULL)
   {
     // now check to see if it is one of the problem commands
     if ((strstr(query, "readpage")  != (char *)NULL) ||
         (strstr(query, "writepage") != (char *)NULL) )
     {
       srv_sendmsg(srvproc, SRV_MSG_ERROR,
                   (DBINT) SRV_NOT_SUPPORTED,
                   (DBTINYINT) 16, (DBTINYINT) 1, NULL, 0, 0,
                   "Function not supported by this connection",
                    SRV_NULLTERM);
       srv_senddone(srvproc, SRV_DONE_FINAL | SRV_DONE_ERROR,
                   (DBUSMALLINT)0, (DBINT)0);
       return(SRV_CONTINUE);
     }
   }

STATUS

Microsoft has confirmed this to be a problem in Open Data Services version 4.2 for Windows NT. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.