[freetds] Fb6 connect fail when phpinfo show mssql is ok.

James liu liuping.james at gmail.com
Tue Mar 27 19:33:51 EST 2007


It work well. Thks jkl.

How to config freetds.conf,, i wanna use php to link ms sql server.


2007/3/28, James K. Lowden <jklowden at freetds.org>:
>
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
regards
jl


More information about the FreeTDS mailing list