Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
PB 6.5.1 - MS SQL 7 DATETIME ISSUES
8 views
Skip to first unread message
ravikiran_uk
Sep 2, 2003, 8:42:22 AM9/2/03
to
Hi All,
We are in the process of migrating our client's SQL Anywhere 5.5 DB to
MS SQL 7. Our Application is in PB 6.5.1 build 620. We are using ODBC
driver ver 3.81.9001 to connect. After migration all DATE columns in
our tables are converted into SMALLDATETIME data type. This is causing
trouble as, in embedded SQL statements across our application we have
used DATE type variables to get date values and getting following
error at runtime - SQLSTATE=22003 [Microsoft][ODBC SQL Server
Driver][Numeric value out of range]. Is there any workaround
available? I have searched this group to find similar cases & used the
changes suggested in some of the settings/parameters to solve this.
There seems to be a problem in datawindows as well for DATE columns.
TIA,
ravikiran_uk
We are in the process of migrating our client's SQL Anywhere 5.5 DB to
MS SQL 7. Our Application is in PB 6.5.1 build 620. We are using ODBC
driver ver 3.81.9001 to connect. After migration all DATE columns in
our tables are converted into SMALLDATETIME data type. This is causing
trouble as, in embedded SQL statements across our application we have
used DATE type variables to get date values and getting following
error at runtime - SQLSTATE=22003 [Microsoft][ODBC SQL Server
Driver][Numeric value out of range]. Is there any workaround
available? I have searched this group to find similar cases & used the
changes suggested in some of the settings/parameters to solve this.
There seems to be a problem in datawindows as well for DATE columns.
TIA,
ravikiran_uk
0 new messages