[freetds] Fb6 connect fail when phpinfo show mssql is ok.
James K. Lowden
jklowden at freetds.org
Tue Mar 27 19:21:26 EST 2007
James liu wrote:
> i can't connect(i use tsql)
>
> command : tsql -H 192.168.7.12 -p 1433 -U user -P user
>
> i m sure ip, port, username and password is right.
It's better to set up freetds.conf, but if you're using "tsql -H" you have
to make sure your TDS version is right. The default is 5.0 unless you
changed it with configure. Microsoft servers don't normally accept TDS
5.0 connections.
Try this:
$ TDSVER=7.0
$ export TDSVER
$ tsql -H [...]
I suspect that will do the trick.
--jkl
More information about the FreeTDS
mailing list