help FREETDS

[shaider123]

how to configure freetds in win2003. i got wamp as my web deamon, and trying to up cabal toolz, i have used native mssql dll but got me tons of problems.

i have read the readme of my chumpy and follwed his instruction, but l it didnt work

this is what ive did:

1) downloaded this http://kromann.info/php5_2-Release_TS/php_dblib.dll for php 5.2
2)Place the .dll in the PHP extensions directory, mine is on folder "ext"
3).replace extension=php_mssql.dll with extension=php_dblib.dll in php ini
magic_quotes_gpc = On
magic_quotes_sybase = On
mssql.textlimit = 20971520
mssql.textsize = 20971520
mssql.secure_connection = Off

create a freetds conf file on c:\ :

[global]
host = 192.168.1.2 //mssql2005 is on a diff box
port = 1433
client charset = UTF-8
tds version = 8.0 / / tried 9.0 and 7.0 but no luck
text size = 20971520


Did i miss anything?

[MentaL]

[phiber]

you dont need tds on windows, becouse tds its mssql interpreter for linux box.

that you are doing its wrong, use mssql_php.dll directly

[shaider123]

you dont need tds on windows, becouse tds its mssql interpreter for linux box.

that you are doing its wrong, use mssql_php.dll directly

Are you sure about it? thanks for the reply, but im still not convinced freetds can't be used for windows2003.

[phiber]

well, if you have doubt always you have the option to read a little.

from freetds.org (front page... 8-))


"FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.

Technically speaking, FreeTDS is an open source implementation of the TDS (Tabular Data Stream) protocol used by these databases for their own clients. It supports many different flavors of the protocol and three APIs to access it. Additionally FreeTDS works with other software such as Perl and PHP, providing access from those languages as well."

[chumpywumpy]

Actually he is right, that is a freetds compiled for windows and in some cases it can be better than the native php libs. I have found that i works better than the native ones if configured correctly (much worse if not though :P).

What doesn't work? If it is failing to connect remember that mssql 2005 express by default installs as a named in stance and also does not allow remote connections so i would guess that is the problem. If it is a named instance (if you aren't sure then it is) then reinstall is the simplest fix and remote connections are enabled in the surface area config tool. A guide on installing and setting up mmsql 2005 express is in my sig.