[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