select date with ms sql 7.0 SP2

Julien de Murcia demurcia at sablet.grenoble.hp.com
Thu Aug 10 06:38:35 EDT 2000



 On Thu, 10 Aug 2000, Julien de Murcia wrote:
> 
> > Hi everybody
> > 
> > I'am new to this list, so I don't know if this problem has already
> > been submitted. I've been using freetds on ms sql 7.0, and it use to
> > worked pefectly. Unfortunately, since someone has patched msql
> > server with SP2 the db returns wrong dates on select statement. I
> > try to read a date/time column and convert it with this code
> 
> Try this with the latest snapshot[1] and tell us whether you still have
> the problem.
> 
> [1] ftp://freetds.internetcds.com/pub/freetds_jdbc/
> 
> -- 
> Bob Kline
> mailto:bkline at rksystems.com
> http://www.rksystems.com
> 
Same thing, it's not working with the snapshot. My sql server version is 
7.00.839. Do I have to specify the version in the connect string of freetds
(I'm  currently using "jdbc:freetds:sqlserver//host/db") ?

Thank, 

Julien de Murcia.




More information about the FreeTDS mailing list