I have been able to reverse an Oracle 10G database using the ODBC Generic driver. However I have come across a situation where error are reported like the following "TMS ALL 08-07-23.VSD : error L2201: 'TM_ADDR.ADDR_STATUS' : The default value is incompatible with the data type or is too long." When I check the column I find that it has a default value of '18' for a Varchar2(1) column. I'm not sure how the incorrect default vale was captured as when I check the database that is the source, there is no default value. Has anyone else experienced this or know how to prevent it from happening?
Is this question about Word? -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "Peter Hattam" wrote in message news:94713E07-7543-4C91-B015-2CC54E7AE6EC@microsoft.com... >I have been able to reverse an Oracle 10G database using the ODBC Generic > driver. However I have come across a situation where error are reported > like > the following > "TMS ALL 08-07-23.VSD : error L2201: 'TM_ADDR.ADDR_STATUS' : The default > value is incompatible with the data type or is too long." > > When I check the column I find that it has a default value of '18' for a > Varchar2(1) column. > > I'm not sure how the incorrect default vale was captured as when I check > the > database that is the source, there is no default value. > > Has anyone else experienced this or know how to prevent it from happening?
