Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with datetime from a MS SQL Server

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Frank M. Kromann" <frank AT kromann.info>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] Problem with datetime from a MS SQL Server
  • Date: Sun, 09 Feb 2003 19:05:04 -0800

Hi Steve,

> On Sun, Feb 09, 2003 at 04:57:14PM -0800, Frank M. Kromann wrote:
> > Thanks for the answer. I did not use --enable-msdblib. I'll test that
and
> > if it works I'll change the PHP documentation on how to build
FreeTDS.
>
> > Is there a way to check how it is compiled so I can make a fix so it
will
> > work with or wighout this option ?
>
> Given that Sybase libs will always be compiled without such an option,
> would it not perhaps be better to add an option to the PHP configure
> script itself that allows the user to specify which style of libraries
> are in use?

There is a couple of posiblilites. PHP has two extensions (MSSQL and
Sybase) that uses FreeTDS, ntwdblib and Sybase libs.

Before PHP 4.3.0 PHP users used the Sybase extension to connect to MS SQL
Servers. Te MSSQL extension was only available on Win32.
The Sybase extension does not use the dbdatecrack() function so I dont see
any problems there. The MSSQL Extension has more functions (support for
multiple results, stored procedures and fetching in batches as well as an
option for date formating using dbdatecrack())

dbdatecrack() will return different values for months depending on teh
library it is comming from:

ntwdblib: 1-12
Sybase libs: 0-11
FreeTDS: 0-11
FreeTDS with --enable-msdblib: 1-12

What I'm looking for is a way to detect the library at runtime or
compiletime (without using a switch if possible) allowing the code to get
correct values.

- Frank
>
> --
> Steve Langasek
> postmodern programmer
>







Archive powered by MHonArc 2.6.24.

Top of Page