[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