DateTime_ODBC: There is a ODBC error when run the DateTime_ODBC.exe on x86 platform.
description
Environment:
1. Windows XP SP3 CHS x86
2. Katmai 10.0.1600.22
3. Sample 90810
4. VS 2005
5. Create ODBC data source called DateTime by readme
Repro Steps:
1. Build the DateTime_ODBC sample successfully.
2. Run the script successfully “…\Engine\Data Access\odbc\DateTime_ODBC\scripts\ setup.sql”.
3. Locate to "...\Engine\Data Access\odbc\DateTime_ODBC\cpp\Debug".
4. Double click “DateTime_ODBC.exe”.
Expectations:
The DateTime_ODBC.exe should run properly without any exception.
Actual Results:
There is a ODBC error when run the DateTime_ODBC.exe:
Error: SQLSTATE=22003, Native error=0, msg=[Microsoft][SQL Server Native Client 10.0]Numeric value out of range.
Please see the attached files:
1. Windows XP SP3 CHS x86: DateTime_ODBC_error.jpg
2. AMD64 with the default configuration (Win32): AMD64_win32_error.jpg
Comments:
This issue repro on AMD64 when building with the default configuration (Win32), but this sample works well when building with the configuration (X64).