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.

Information about the GuessTheColDef connection string attribute of the ODBC Driver for Oracle


View products that this article applies to.

Introduction

This article contains information about the GuessTheColDef connection string attribute of the Microsoft ODBC driver for Oracle.

↑ Back to the top


More information

The ODBC driver for Oracle contains a connection string attribute that is named GuessTheColDef. The GuessTheColDef attribute specifies whether the ODBC driver must return a non-zero value or a zero value for the cbColDef argument of the SQLDescribeCol function. The GuessTheColDef attribute applies only to columns where there is no Oracle-defined scale such as computed numeric columns and columns that are defined as NUMBER data type without a precision or scale. A call to the SQLDescribeCol function returns 130 for the precision when Oracle does not provide that information.

Note The GuessTheColDef attribute functions the same as the SQLDescribeCol always returns a value for precision option. To turn on this option, click to select SQLDescribeCol always returns a value for precision in the Data Sources dialog box.

↑ Back to the top


References

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:
Connection string format and attributes
http://msdn2.microsoft.com/en-us/library/ms709346.aspx
ODBC Driver for Oracle user's guide
http://msdn2.microsoft.com/en-us/library/ms714756.aspx
Using SQLConfigDatasource with the ODBC Driver for Oracle
http://msdn2.microsoft.com/en-us/library/ms715448.aspx
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
199293� PRB: Numeric value out of range error with MS Oracle ODBC Driver version 2.5 or higher
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

↑ Back to the top


Keywords: KB827574, kbinfo, kbdatabase, kbdriver, kboracle, kbhowto

↑ Back to the top

Article Info
Article ID : 827574
Revision : 5
Created on : 11/26/2007
Published on : 11/26/2007
Exists online : False
Views : 300