freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] Data-conversion resulted in overflow using FreeTDS and SQLServer
- From: dmarrer AT bci.cl
- To: freetds AT lists.ibiblio.org
- Subject: [freetds] Data-conversion resulted in overflow using FreeTDS and SQLServer
- Date: Thu, 27 Nov 2008 15:26:29 -0300
We are using freetds 0.82 to connect to a MSQL database 2005.
When reading certain tables, using fisql, we have no errors but other
tables give
the error:
error_handler: Data-conversion resulted in overflow.
for each line of results.
If I use DBArtisan on this database this does not occur.
Could someone please advise possible cause of error and how we might fix
it.
The table where we have an error is pretty standard as follows:
CREATE TABLE PHONE_FAX
(
ID varchar(4) COLLATE SQL_Latin1_General_CP1_CS_AS NOT
NULL,
ID_USER varchar(9) COLLATE SQL_Latin1_General_CP1_CS_AS NOT
NULL,
OR_PHONE numeric(6,0) NOT NULL,
DT_START datetime NULL,
DT_END datetime NULL
PRIMARY KEY CLUSTERED (ID_USER,OR_PHONE,ID)
)
Thanks.
Daymel
-
[freetds] Data-conversion resulted in overflow using FreeTDS and SQLServer,
dmarrer, 11/27/2008
- Re: [freetds] Data-conversion resulted in overflow using FreeTDS and SQLServer, dmarrer, 11/27/2008
- Re: [freetds] Data-conversion resulted in overflow using FreeTDS and SQLServer, James K. Lowden, 11/29/2008
Archive powered by MHonArc 2.6.24.