[freetds] a question about install freetds with unixODBC
Frediano.Ziglio at vodafoneomnitel.it
Wed Apr 2 10:19:46 EST 2003
> hello, everyone
> I am a newbie using freetds throught unixODBC to get
> connection from SQLServer 2000.
> But I could not connect the Server from isql, the tools of
> unixODBC, and the error message is: Client unable to
> establish connection.
> Nick Gorham said that means this error was coming from
> the freeTDS driver, so the unixODBC bit was setup correctly.
> But I can use the tsql connect the SQL Server, can you tell
> me how can I deal with it?
> xuzheng at dvnchina.com
Well, ODBC section in userguide is the worth!
I currently the main maintener of ODBC and I should revise it however I know
ODBC since ages so is difficult for me to explain things like dns-less...
If you configured freetds.conf for tsql the fastest way to configure FreeTDS
is to use freetds.conf connection.
Start from page http://www.freetds.org/userguide/x1853.htm.
Compile a odbc.ini section with information similar to tsql command. ie:
Driver = /usr/local/lib/libtdsodbc.so
Servername = tsql_server
DataBase = tempdb
And replace /usr/local/lib/libtdsodbc.so with fullpath of your driver,
tsql_server with server used with tsql (-S parameter) and tempdb with your
db (remove line to use default db for user)
Now isql require this syntax
isql DSN [UID [PWD]]
use odbc_server as your DSN and appropriate UID (username) and PWD
If you want to use domain account just use domain\username as UID and your
domain account password as PWD.
If you want to write some of your experiences and/or have idea how to
improve ODBC userguide section...
"STRICTLY PERSONAL AND CONFIDENTIAL
This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."
More information about the FreeTDS