Skip to Content.
Sympa Menu

freetds - timestamp data types (also DBLib Connections)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Geoff Winkless" <geoff AT farmline.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: timestamp data types (also DBLib Connections)
  • Date: Mon, 13 Dec 1999 12:30:35 -0000


>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





Archive powered by MHonArc 2.6.24.

Top of Page