FreeTDS Development Group

["Frank M. Kromann" <frank AT kromann.info>]

Hi,

The PHP extension uses ini-settings to define ttextsize and textlimit on
Win32. You can obtain the same result by setting the text size value in
freetds.conf on *nix platforms.

It would be nice to have the TEXTLIMIT option implemented in FreeTDS as
I'm porting this to Win32.

- Frank

> Okay Tom,
> 
> I guess if PHP needs (or will need)  it we should add to the TODO list.
It
> shouldn't be difficult to code.
> 
> Bill
> 
> > -----Original Message-----
> > From:       Thomas Bange [SMTP:tb AT topbuero.de]
> > Sent:       17 July 2003 16:25
> > To: 'FreeTDS Development Group'
> > Subject:    RE: [freetds] FreeTDS 0.61 + PHP 4.3.2 cannot connect MSSQL
> > 7
> > 
> > Hi Bill,
> > 
> > it seems that newer PHP version do set a textlimit.
> > This is from my php.ini:
> > 
> > ; Valid range 0 - 2147483647.  Default = 4096.
> > mssql.textlimit = 65536
> > 
> > ; Valid range 0 - 2147483647.  Default = 4096.
> > mssql.textsize = 65536
> > 
> > I comment out the mssql.textlimit = 65536 and now
> > it works.
> > 
> > Thanks for your help!
> > 
> > Tom
> > 
> > > -----Original Message-----
> > > From: Thompson, Bill D (London)
[mailto:ThompBil AT exchange.uk.ml.com]
> > > Sent: Thursday, July 17, 2003 5:14 PM
> > > To: 'FreeTDS Development Group'
> > > Subject: RE: [freetds] FreeTDS 0.61 + PHP 4.3.2 cannot connect MSSQL
7
> > > 
> > > 
> > > Hi Tom,
> > > 
> > > Your application (or PHP under the wrappers) is issuing a db 
> > > library command
> > > dbsetopt with an option of DBTEXTLIMIT
> > > This is not currently supported by our db-library. 
> > > 
> > > If it is your application code doing this, then try and find 
> > > the piece of
> > > code and remove it temporarily. It may not be required in any case.
> > > I wouldn't think that PHP is doing this without your 
> > > instruction to do so,
> > > as we know that PHP works fine with FreeTDS...
> > > 
> > > HTH,
> > > 
> > > Bill
> > > 
> > > > -----Original Message-----
> > > > From:   Thomas Bange [SMTP:tb AT topbuero.de]
> > > > Sent:   17 July 2003 15:55
> > > > To:     'freetds AT lists.ibiblio.org'
> > > > Subject:        [freetds] FreeTDS 0.61 + PHP 4.3.2 cannot 
> > > connect MSSQL 7
> > > > 
> > > > Hi!
> > > > 
> > > > I am trying to connect to a MSSQL 7 server from PHP 4.3.2
> > > > using FreeTDS 0.61, but it doesn't work. In the trace file
> > > > I got the following message (last line):
> > > > 
> > > > UNIMPLEMENTED dbsetopt(option = 7)
> > > > 
> > > > Connecting with sqsh works, anyway.
> > > > PHP 4.2.1 with FreeTDS 0.60 does work either.
> > > > 
> > > > Any idea what the problem is?
> > > > 
> > > > Regards,
> > > > Tom
> > > > _______________________________________________
> > > > FreeTDS mailing list
> > > > FreeTDS AT lists.ibiblio.org
> > > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > > 
> > > _______________________________________________
> > > FreeTDS mailing list
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > > 
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>