HOWTO: Look Up Error Codes Related to SQL Server CE

A Microsoft SQL Server 2000 Windows CE application may produce a variety of error codes that originate from the ActiveX Data Objects (ADO), OLE DB, Replication, Microsoft Internet Information Server or Microsoft Internet Information Services, or Microsoft Windows programs. The SQL Server Windows CE Books Online topic about "Error Codes" does not document all of the possible error codes that may occur.

You can obtain a collection of major error codes that can occur when you use SQL CE (SSCE) connectivity from various sources such as:

• Microsoft Developer Network (MSDN)
  
  
  • Platform Software Development Kit (SDK)
    
    
  • Security
    
    
  • Certificate Services and Components
    
    
  • Certificate services
    
    
  • Certificate Server Reference
  
  
  
• Common HRESULT Values: Provides a short table of some of the most common HRESULTs.
  
  
• : Provides a short table of some of the most common HRESULTs. Dataaccess31\Include\Oledberr.h: Contains the has OLEDB specific error definitions.
  
  
• : Provides a short table of some of the most common HRESULTs. Wininet.h: Contains hypertext transfer protocol (HTTP) or Internet specific error definitions.
  
  
• : Provides a short table of some of the most common HRESULTs. Winerror.h: Contains operating system (OS) specific error definitions.

Note that the HTTP or Internet errors in the Wininet.h file are defined from a base of 12000. SSCE returns the errors wrapped into an HRESULT.

So, for example, you can break down HRESULT 0x80072EE7, by taking the right-most 4 hexidecimal digits (2EE7) and converting them to decimal (12007). Then, look up that value in the Wininet.h file (as INTERNET_ERROR_BASE + 7). Search for the INTERNET_ERROR_BASE in the Wininet.h file.

The SQL Server CE Books Online topic about "Error Codes" only documents native error codes. You must look for 800xxxxx errors in the Microsoft Developer Network (MSDN), Microsoft Knowledge Base articles or header files as previously described. Make sure that you add enough error handling code to your application to retrieve the error descriptions as described in the SQL Server CE Books Online topic about "Error Handling".

SQL Server CE Books Online; topic: "Error Codes"