Skip to Content.
Sympa Menu

freetds - [freetds] Username and password in odbc.ini instead of command line

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ruiyuan Jiang <Ruiyuan_Jiang AT liz.com>
  • To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Username and password in odbc.ini instead of command line
  • Date: Wed, 18 Jan 2012 16:53:06 -0500

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.




Archive powered by MHonArc 2.6.24.

Top of Page