Username and password in odbc.ini instead of command line
Ruiyuan Jiang <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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.