timestamp data types (also DBLib Connections)

Geoff Winkless geoff at farmline.com
Mon Dec 13 07:30:35 EST 1999


>From sqsh I'm getting "Attempting to convert unknown source type -1" when I
select an MS SQL7 timestamp field. It then returns garbage.

On Sybase timestamp works fine.

Where should I start looking??? include/tds.h mentions nothing at all about
timestamps.

Putting in some debugging code returns interesting stuff - what actually
happens is first it converts the timestamp field from SYBBINARY (45)
and -then- calls the convert again with -1, even though there's only one
field, vis:

1> select msrepl_synctran_ts from folusers..tuserauth where fuserid=1793
2> go

        msrepl_synctran_ts




        --------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
------------------------
Converting type 45
Converting type -1
Attempting to convert unknown source type -1

        (@(@

Note that this isn't urgent (I've no need to return it, I was just
intrigued...)

On another matter entirely, what's the recommended DBLib way of testing if a
connection is still valid?

Thanks for any help...

Geoff




More information about the FreeTDS mailing list