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


The information in this article applies to:

  • Microsoft ODBC for Oracle version 2.5 Build 2.573.2927
  • Microsoft ODBC for Oracle version 2.0 Build 2.73.7269
  • Microsoft ODBC Driver for Oracle (Build 2.06325) 1.0
  • Microsoft Data Access Components 2.5

INTRODUCTION

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

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.

REFERENCES

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:

Connection string format and attributes
http://msdn.microsoft.com/library/en-us/odbc/htm/odbcoracleconnection_string_format_and_attributes.asp

ODBC Driver for Oracle user's guide
http://msdn.microsoft.com/library/en-us/odbc/htm/odbcoracleusers_guide.asp

SQLDescribeCol and SQLColAttribute
http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqldescribecol_and_sqlcolattribute.asp

Using SQLConfigDatasource with the ODBC Driver for Oracle
http://msdn.microsoft.com/library/en-us/odbc/htm/odbcoracleusing_sqlconfigdatasource_with_the_odbc_driver_for_oracle.asp

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.
Modification Type:MinorLast Reviewed:10/22/2004
Keywords:kbhowto kbOracle kbDriver kbDatabase kbinfo KB827574 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.