[freetds] Segmentation Falt when Retrieving datetime Columns from MS SQL 7.0 SP4 Server

Ben Gribaudo me at bengribaudo.com
Fri Jul 29 11:32:48 EDT 2005


Hello,

I am attempting to use FreeTDS on a Debian 3.1 box which has libct1 
version 0.61-6.2 installed along with sqlrelay-freetds (0.35-10). When I 
attempt to retrieve datetime columns, I receive a segmentation falt. 
However, if I cast the datetime column to a char, the query works. The 
database server is MS SQL 7.0 SP4. freetds.conf is set to use tds 
version 7.0 for this server. Examples and data below. Also, see atached log.

Do you have any ideas as to how I could fix this probelm?

Thank you,
Ben Gribaudo

=============================
All examples are using the default Microsoft pubs database.

In SQSH:
| 1> select * from sales
| 2> go
|
| Program received signal SIGSEGV, Segmentation fault.
| 0x40400f64 in strftime () from /lib/tls/libc.so.6
(additional info above from dbg)

This works fine:
| 1> select stor_id, ord_num, cast(ord_date as char), qty, payterms, 
title_id from sales
| 2> go
| (results...)

I don't know if this is related but this doesn't work, either:
| 1> use pubs
| 2> select * from pub_info;
| 3> go
| (column names, dashes)
| error_handler: Data-conversion resulted in overflow.


-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: freetds log.txt
Url: http://lists.ibiblio.org/pipermail/freetds/attachments/20050729/fb12cac0/freetdslog.txt


More information about the FreeTDS mailing list