FreeTDS Development Group

["Brandon M. Reynolds" <breynolds AT comtime.com>]

A little more info: If I use that patch below with sqsh (which
uses ctlib), things work.  But if I use a program that I wrote (in C)
with dblib, it seems to pull out all zeros.  So it would seem that
this patch is right, but it's not the whole answer.

Brandon M. Reynolds                    Ph: (330) 644-3059
Systems Engineer                       Fax: (330) 644-8110
Commercial Timesharing Inc.            Email: bmr AT comtime.com


> -----Original Message-----
> From: Brian Bruns [mailto:camber AT ais.org]
> Sent: Thursday, October 19, 2000 3:15 PM
> To: TDS Development Group
> Subject: [freetds] Re: TDS 7.0 and decimals
> 
> 
> You may want to try the following patch in tds/convert.c
> Not sure if it'll work, but it's the obviously wrong part :-)
> 
> Brian
> 
> 
>                 case SYBMONEY:
>                         return tds_convert_money(srctype,src,
>                                 desttype,dest,destlen);
>                         break;
> +               case SYBDECIMAL:
>                 case SYBNUMERIC:
>                         return 
> tds_convert_numeric(srctype,(TDS_NUMERIC *)
>                                       src,srclen,
>                                 desttype,dest,destlen);
>                         break;
> 
> > When I try to pull some decimals out of the database I get 
> this error
> > message:
> > 
> > Attempting to convert unknown source type 106
> > 
> > This works fine with TDS 4.2.
> > 
> > The decimal datatype in SQL Server 7 appears to be 9 bytes long.
> > 
> > Brandon M. Reynolds                    Ph: (330) 644-3059
> > Systems Engineer                       Fax: (330) 644-8110
> > Commercial Timesharing Inc.            Email: bmr AT comtime.com
> 
> ---
> You are currently subscribed to freetds as: [bmr AT comtime.com]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
>