Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

BUG: ODBC: SQLGetProp Causes IC Error in Debug Window


View products that this article applies to.

This article was previously published under Q148330

↑ Back to the top


Symptoms

An internal consistency (IC) error occurs when you attempt to view the properties of a connection using SQLGetProp in the DEBUG window.

↑ Back to the top


Cause

You are using an invalid connection handle in the SQLGetProp() function in the DEBUG window.

↑ Back to the top


Resolution

Print the return value of SQLGetProp() to the desktop or currently active window using ? or \ printing as in this example:
   ? SQLGETPROP(<handle>, "BATCHMODE")
				
In this example, <handle> is a valid handle to the connection.

↑ Back to the top


Status

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

↑ Back to the top


More information

Steps to Reproduce Problem

  1. Create an ODBC data source based on the Oracle 7.0 driver.
  2. Create a database with a remote view based on the data source created in step 1.
  3. Open the remote view.
  4. Open the Debug window, and type the following line in the left pane:
          SQLGetProp(3, "BATCHMODE")
    						
    In this example, 3 is an invalid connection handle.

↑ Back to the top


Keywords: KB148330, kbbug

↑ Back to the top

Article Info
Article ID : 148330
Revision : 4
Created on : 10/15/2003
Published on : 10/15/2003
Exists online : False
Views : 364