Re: Column types reported from SQL Server 1008

Thanks James,

So at least I know where I am now.

Everyone needs more hands. I'm up to my neck with various efforts toward
D modules for database access. I shall switch over to Microsoft's ODBC
for the moment, then at least I might be able to get an approximation to
what my final ODBC interface might be. But I do want to get a Linux/SQL
Server implementation going.

I see that MS are threatening a Linux ODBC driver, but only a 64 bit one
at the moment.

What would be your position on licensing if I were to think about doing
a translation of FreeTDS to D. The D standard library Phobos uses the
Boost license. The ideal is just a D module with no associated library.

Thanks again
Steve

On Sat, 2011-11-19 at 11:34 -0500, James K. Lowden wrote:
> You're missing support for TDS version 7.3.  
> 
> The TDS client you're using cannot decode the binary format of bigint,
> date, and time types.  These types first appeared on SQL Server 2008,
> which brought us TDS 7.3.   
> 
> The client announces the TDS version it uses in the login packet.  The
> server knows which datatypes are defined for each protocol version.
> It converts datatypes not defined in a given version to something
> defined i.e., something the client will recognize and be able to
> decode.  
> 
> The version of FreeTDS you're using logs in as TDS 7.2, for which
> BIGINT is undefined.  The server returns it as FLOAT.  IEEE 754 defined
> double-precision floating point as 52 bits of precision, which, while
> not 64 bits, is certainly better than the 32 bits in an INT.  After
> 2^52 you get approximations.  Perhaps before then you'll get TDS 7.3.  
> 
> Work toward support for TDS 7.3 in FreeTDS is ongoing and has been
> discussed before on this list in the last few months.  No promises
> when it will be ready, not even guesses. There's always room for more
> hands.  
> 
> --jkl
> 
> 
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds