[freetds] Windows Question

Frank M. Kromann frank at kromann.info
Thu Apr 12 21:22:10 EDT 2007


If I understtod Patricks original problem correct he's looking for a way to
connect using named pipes and not tcp/ip. FreeTDS does not support named
pipes afaik?

- Frank

> Patrick Corbett wrote:
> > I was speaking ealier to Frank Kromann about using FreeTDS on a
windows
> > machine with PHP in order to avoid an issue that limits data pulled
from
> > SQL Server 2000 with PHP from a varchar field to 255 characters using
> > php_mssql.dll. Normally, I would use Kromann's php_dblib.dll to fix
> > this, but because apparently this library doesn't allow named
instances
> > for a server name in the freetds.conf file, and because I have to
> > connect to my server with named instances (e.g.,
server\instance_name),
> > I'm not sure what I can do.
> 
> http://www.freetds.org/userguide/freetdsconf.htm#FREETDSCONFFORMAT
> 
> Just put the instance name in freetds.conf and make sure you're using
TDS
> version 7.0 or 8.0.  
> 
> It took me a minute to understand your question.  Then I understood: if
> you use Microsoft's ntwdblib.dll, you get TDS version 4.2, which limits
> varchars to 255 characters.  If you use FreeTDS, you get an updated
> protocol and 8000-byte varchars.  
> 
> I never thought I'd see FreeTDS supplant the vendor's own library....
> 
> HTH.
> 
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 






More information about the FreeTDS mailing list