Skip to Content.
Sympa Menu

freetds - RE: [freetds] FreeTDS 0.61 + PHP 4.3.2 cannot connect MSSQL 7

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Frank M. Kromann" <frank AT kromann.info>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] FreeTDS 0.61 + PHP 4.3.2 cannot connect MSSQL 7
  • Date: Thu, 17 Jul 2003 09:26:21 -0700

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
>






  • RE: [freetds] FreeTDS 0.61 + PHP 4.3.2 cannot connect MSSQL 7, Frank M. Kromann, 07/17/2003

Archive powered by MHonArc 2.6.24.

Top of Page