<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
ThetablebelowshowstheADODataTypemappingbetween,,and:
DataTypeEnumValueAccessSQLServerOracleadBigInt20 BigInt(SQLServer2000+) adBinary128 Binary
TimeStampRaw*adBoolean11YesNoBit adChar129 CharCharadCurrency6CurrencyMoney
SmallMoney adDate7DateDateTime adDBTimeStamp135DateTime(Access97(ODBC))DateTime
SmallDateTimeDateadDecimal14 Decimal*adDouble5DoubleFloatFloatadGUID72ReplicationID(Access97(OLEDB)),(Access2000(OLEDB))UniqueIdentifier(SQLServer7.0+) adIDispatch9 adInteger3AutoNumber
Integer
LongIdentity(SQLServer6.5)
Int
Int*adLongVarBinary205OLEObjectImageLongRaw*
Blob(Oracle8.1.x)adLongVarChar201Memo(Access97)
Hyperlink(Access97)TextLong*
Clob(Oracle8.1.x)adLongVarWChar203Memo(Access2000(OLEDB))
Hyperlink(Access2000(OLEDB))NText(SQLServer7.0+)NClob(Oracle8.1.x)adNumeric131Decimal(Access2000(OLEDB))Decimal
NumericDecimal
Integer
Number
SmallIntadSingle4SingleReal adSmallInt2IntegerSmallInt adUnsignedTinyInt17ByteTinyInt adVarBinary204ReplicationID(Access97)VarBinary adVarChar200Text(Access97)VarCharVarCharadVariant12 Sql_Variant(SQLServer2000+)VarChar2adVarWChar202Text(Access2000(OLEDB))NVarChar(SQLServer7.0+)NVarChar2adWChar130 NChar(SQLServer7.0+)
*InOracle8.0.x-decimalandintareequaltonumberandnumber(10).
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
ThetablebelowshowstheADODataTypemappingbetween,,and:
DataTypeEnumValueAccessSQLServerOracleadBigInt20 BigInt(SQLServer2000+) adBinary128 Binary
TimeStampRaw*adBoolean11YesNoBit adChar129 CharCharadCurrency6CurrencyMoney
SmallMoney adDate7DateDateTime adDBTimeStamp135DateTime(Access97(ODBC))DateTime
SmallDateTimeDateadDecimal14 Decimal*adDouble5DoubleFloatFloatadGUID72ReplicationID(Access97(OLEDB)),(Access2000(OLEDB))UniqueIdentifier(SQLServer7.0+) adIDispatch9 adInteger3AutoNumber
Integer
LongIdentity(SQLServer6.5)
Int
Int*adLongVarBinary205OLEObjectImageLongRaw*
Blob(Oracle8.1.x)adLongVarChar201Memo(Access97)
Hyperlink(Access97)TextLong*
Clob(Oracle8.1.x)adLongVarWChar203Memo(Access2000(OLEDB))
Hyperlink(Access2000(OLEDB))NText(SQLServer7.0+)NClob(Oracle8.1.x)adNumeric131Decimal(Access2000(OLEDB))Decimal
NumericDecimal
Integer
Number
SmallIntadSingle4SingleReal adSmallInt2IntegerSmallInt adUnsignedTinyInt17ByteTinyInt adVarBinary204ReplicationID(Access97)VarBinary adVarChar200Text(Access97)VarCharVarCharadVariant12 Sql_Variant(SQLServer2000+)VarChar2adVarWChar202Text(Access2000(OLEDB))NVarChar(SQLServer7.0+)NVarChar2adWChar130 NChar(SQLServer7.0+)
*InOracle8.0.x-decimalandintareequaltonumberandnumber(10).
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>