Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James liu" <liuping.james AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Fb6 connect fail when phpinfo show mssql is ok.
  • Date: Wed, 28 Mar 2007 08:33:51 +0800

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




Archive powered by MHonArc 2.6.24.

Top of Page