FreeTDS Development Group

[Ruiyuan Jiang <Ruiyuan_Jiang AT liz.com>]

Hi, guys

I have made freetds (v0.91) work on my HPUX 11.23 server.

$ isql -v MSSQLSERVER username password
Connected!
Sql-statement
Help [tablename]
Quit

SQL>

Since we will access MSSQL server through application, there is a request 
that whether I can put the username and password into odbc.ini instead of 
part of 'isql' command line.
I appended "username=xxx" and "password=xxx" in the odbc.ini.

$ isql -v MSSQLSERVER
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed.
[ISQL]ERROR: Could not SQLConnect
$

I have tried to use "user", "uid" and "userid" instead of "username" in the 
odbc.ini but no luck. Does anyone know how to accomplish this? Thanks.

Ryan Jiang




This message (including any attachments) is intended
solely for the specific individual(s) or entity(ies) named
above, and may contain legally privileged and
confidential information. If you are not the intended 
recipient, please notify the sender immediately by 
replying to this message and then delete it.
Any disclosure, copying, or distribution of this message,
or the taking of any action based on it, by other than the
intended recipient, is strictly prohibited.