[freetds] Windows Question

James K. Lowden jklowden at freetds.org
Thu Apr 12 20:58:04 EDT 2007


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



More information about the FreeTDS mailing list