headers
wamon | 3 Jul 2012 04:32
Picon
Favicon

datetime problem in php with mssql.datetimeconvert = Off


Hi,I have a new setup of centos 6.2 with following packages installed:[root <at> centos6 ~]# rpm -qa|grep
phpphp-devel-5.3.3-3.el6_2.8.i686php-common-5.3.3-3.el6_2.8.i686php-5.3.3-3.el6_2.8.i686php-ldap-5.3.3-3.el6_2.8.i686php-mysql-5.3.3-3.el6_2.8.i686php-cli-5.3.3-3.el6_2.8.i686php-pdo-5.3.3-3.el6_2.8.i686php-mssql-5.3.3-1.el6.i686[root <at> centos6
~]# rpm -qa|grep freetdsfreetds-0.91-2.el6.i686
I have a simple test php program as followed:<?php// connect database ...$rs=mssql_query("select
cast(getdate() as varchar),getdate()");$row=mssql_fetch_row($rs);print_r($row);?>With
mssql.datetimeconvert = On in php.ini, I got:Array(    [0] => Jul  2 2012 10:23PM    [1] => Jul  2 2012
10:23:39:073PM)But with mssql.datetimeconvert = Off, I got this strange result:Array(    [0] => Jul  2 2012
10:25PM    [1] => 2012-03-07 13625386)
Could anyone tell me how to fix it?Thanks,
Amonw
Permalink | Reply | 0 comments |
headers
wamon | 3 Jul 2012 04:59
Picon
Favicon

datetime problem in php with mssql.datetimeconvert = Off‏


The format of my previous email was totally messed up. So I'm sending it again.

Hi,
I have a new setup of centos 6.2 with following packages installed:

[root <at> centos6 ~]# rpm -qa|grep php
php-devel-5.3.3-3.el6_2.8.i686
php-common-5.3.3-3.el6_2.8.i686
php-5.3.3-3.el6_2.8.i686
php-ldap-5.3.3-3.el6_2.8.i686
php-mysql-5.3.3-3.el6_2.8.i686
php-cli-5.3.3-3.el6_2.8.i686
php-pdo-5.3.3-3.el6_2.8.i686
php-mssql-5.3.3-1.el6.i686
[root <at> centos6 ~]# rpm -qa|grep freetds
freetds-0.91-2.el6.i686

I have a simple test php program as followed:

<?php
// connect database ...
$rs=mssql_query("select cast(getdate() as varchar),getdate()");
$row=mssql_fetch_row($rs);
print_r($row);
?>

With mssql.datetimeconvert = On in php.ini, I got:
Array
(
(Continue reading)

Permalink | Reply | 0 comments |
headers
Techathuvanan, Tim | 6 Jul 2012 15:41
Favicon

files missing from ibiblio?

Hi,
I'm trying to download the latest version of the source from ibiblio.org and it appears as though the files
are gone. Everything under http://ibiblio.org/pub/Linux/ALPHA/freetds/ is missing. Last modified
date is 02-Jul-2012 13:15. Did the distribution site change?

Thank you,
Tim
Permalink | Reply | 3 comments |
headers
Ken Collins | 6 Jul 2012 15:56
Gravatar

Re: files missing from ibiblio?


I am seeing the same thing. Changing this URL without a redirect or some notice would be very problematic for
all packages systems. Any news on this?

$ curl -I http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-0.91.tar.gz
HTTP/1.1 404 Not Found
Date: Fri, 06 Jul 2012 13:54:57 GMT
Server: Apache
Last-Modified: Fri, 10 Jun 2011 21:02:03 GMT
ETag: "130f8b6-6100-4a561e1a5e8c0"
Accept-Ranges: bytes
Content-Length: 24832
Content-Type: text/html; charset=utf-8

On Jul 6, 2012, at 9:41 AM, Techathuvanan, Tim wrote:

> Hi,
> I'm trying to download the latest version of the source from ibiblio.org and it appears as though the files
are gone. Everything under http://ibiblio.org/pub/Linux/ALPHA/freetds/ is missing. Last modified
date is 02-Jul-2012 13:15. Did the distribution site change?
> 
> Thank you,
> Tim
Permalink | Reply | 2 comments |
headers
Ken Collins | 6 Jul 2012 19:57
Gravatar

Re: files missing from ibiblio?


I now get this and if I trust the status code, I guess that means I will be updating to that location as the new permanent?

$ curl -I http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-0.91.tar.gz
HTTP/1.1 301 Moved Permanently
Date: Fri, 06 Jul 2012 17:53:28 GMT
Server: Apache
Location: http://mirrors.ibiblio.org/freetds/stable/freetds-0.91.tar.gz
Content-Type: text/html; charset=iso-8859-1

On Jul 6, 2012, at 9:56 AM, Ken Collins wrote:

> 
> I am seeing the same thing. Changing this URL without a redirect or some notice would be very problematic
for all packages systems. Any news on this?
> 
> $ curl -I http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-0.91.tar.gz
> HTTP/1.1 404 Not Found
> Date: Fri, 06 Jul 2012 13:54:57 GMT
> Server: Apache
> Last-Modified: Fri, 10 Jun 2011 21:02:03 GMT
> ETag: "130f8b6-6100-4a561e1a5e8c0"
> Accept-Ranges: bytes
> Content-Length: 24832
> Content-Type: text/html; charset=utf-8
> 
> 
> On Jul 6, 2012, at 9:41 AM, Techathuvanan, Tim wrote:
> 
>> Hi,
(Continue reading)

Permalink | Reply | 0 comments |
headers
dariusz ostolski | 10 Jul 2012 14:14
Picon

FreeTDS support for 7.3

Hello,

I've got few questions regarding FreeTDS
- where is the current source code repository? Sourceforge cvs repo seems
to be dead,
- is 7.3 protocol version supported? Are there any plans?

--

-- 
Regards
Darek Ostolski
Permalink | Reply | 2 comments |
headers
Randy Syring | 10 Jul 2012 14:26
Picon
Gravatar

Re: FreeTDS support for 7.3

Darek,

I know the repo moved to Git.  This looks promising:

http://gitorious.org/freetds/freetds

7.3 is not currently supported in released versions.  I do believe its 
on the roadmap/in development, I've heard talk of it on the mailing list 
before.  Frediano mentions it being supported in CVS (?) in this reply:

http://permalink.gmane.org/gmane.comp.db.tds.freetds/14153

---------------------------------------------
Randy Syring
Development & Executive Director
Level 12 Technologies  <https://www.lev12.com/>
Direct: 502-276-0459
Office: 502-212-9913

Principled People, Technology that Works

On 07/10/2012 08:14 AM, dariusz ostolski wrote:
> Hello,
>
> I've got few questions regarding FreeTDS
> - where is the current source code repository? Sourceforge cvs repo seems
> to be dead,
> - is 7.3 protocol version supported? Are there any plans?
>
(Continue reading)

Permalink | Reply | 1 comment |
headers
Frediano Ziglio | 11 Jul 2012 20:24
Picon

Re: FreeTDS support for 7.3

2012/7/10 Randy Syring <rsyring <at> gmail.com>:
> Darek,
>
> I know the repo moved to Git.  This looks promising:
>
> http://gitorious.org/freetds/freetds
>

Yes, this became official repository. Actually we have some problems
with snapshots. Perhaps due to ibiblio server rename/move too.

> 7.3 is not currently supported in released versions.  I do believe its
> on the roadmap/in development, I've heard talk of it on the mailing list
> before.  Frediano mentions it being supported in CVS (?) in this reply:
>
> http://permalink.gmane.org/gmane.comp.db.tds.freetds/14153
>

Not many changes but I think it's mostly there (I mean in 0.92 branch
which is not the stable one).

> ---------------------------------------------
> Randy Syring
> Development & Executive Director
> Level 12 Technologies  <https://www.lev12.com/>
> Direct: 502-276-0459
> Office: 502-212-9913
>
> Principled People, Technology that Works
>
(Continue reading)

Permalink | Reply | 0 comments |
headers
Frediano Ziglio | 11 Jul 2012 20:31
Picon

array fixes

Hi,
  sometimes I tried to updated DBD::ODBC and see how it works with
FreeTDS. Documentation and code points out that our array
implementations was not so fine :(
After some checks it turned out that return codes were different and
row number on errors was not implemented.
Fixes are now in 0.91 (stable branch) and 0.92 (development).

Frediano
Permalink | Reply | 0 comments |
headers
Frediano Ziglio | 11 Jul 2012 23:08
Picon

Re: ODBC bug large image parameter

Hi,
  sorry to reply so late but I saw the mail only after looking at
DBD::ODBC bug report.

Probably that's something wrong with the way we handle parsing the rpc
call. mssql have a limit of 64kb of query so perhaps from here the
32kb limit came (still to test).

Frediano

2012/2/27 Matthew McGillis <matthew <at> jenika.com>:
> With intel 64 running Red Hat Enterprise Linux Server 6.1 using FreeTDS 0.82, unixODBC 2.3.0, perl 5.10
and DBD::ODBC 1.29.
>
> Connecting to a Windows box with Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
>
> If I create this stored procedure in a database.
>
> "create procedure testbug  <at> data image as begin return end"
>
> Then create a script "bug" with the following:
>
> #!/usr/bin/perl
>
> use DBI;
>
> my $dbh=DBI->connect("dbi:ODBC:".$ENV{DB},$ENV{USER},$ENV{PASS},
>                    {PrintError => 1, RaiseError=> 1}) ||
>   die "Failed DB connect: ".$dbh->errstr;
>
(Continue reading)

Permalink | Reply | 0 comments |

Gmane