FreeTDS Development Group

[Eric <es AT fruitcom.com>]

We are using freetds to connect to a MSQL database.

When reading certain tables, we have no errors but other tables give
the error:
error_handler: Data-conversion resulted in overflow.
for each line of results.

This does not occur with other drivers that we use on this database.

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 FWIW:

 CREATE TABLE Event (
        EventTypeKey         smallint NOT NULL,
        EventKey             int IDENTITY,
        OrgTainerKey         char(6) NULL,
        DocumentExternalReference varchar(20) NULL,
        DocumentDate         smalldatetime NOT NULL,
        StartDate            smalldatetime NULL,
        EndDate              smalldatetime NULL,
        Narrative            varchar(50) NULL,
        CapturedBy           varchar(20) NULL,
        EntryDate            smalldatetime NOT NULL,
        Status               tinyint NULL
 )


Thanks.

-- 
Eric Smith