Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC Username?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] ODBC Username?
  • Date: Tue, 25 Feb 2003 12:07:08 +0100

>
> I've installed freetds-0.61rc yesterday, and I've been trying
> to use it
> with unixODBC. It appears to work using tsql (this is to a Sybase
> server).
>
> However, attempting to connect I always get told that the username is
> wrong. Looking at the dump file the username is not being sent (unlike
> with the tsql tool, which is sending it correctly)
>
> I have specified the username in the odbc.ini (UID = ...), yet it is
> obviously not being used. From what I can make out of connectparams in
> libtds, UID is the correct name for this parameter.
>
> The current entry is
>
> [Test]
> Driver = /home/as/lib/libtdsodbc.so
> Description = Sybase
> Trace = Yes
> Server = 127.0.0.1
> Port = 4100
> Database = test
> UID = xxx
> PWD =
> TDS_Version = 5.0
>
>
> Which seems okay (I've tried using freetds.conf, but this doesn't like
> me either!)
>
> I'm sure I must be missing something unbelievably obvious. It doesn't
> seem to complete the DSN info function however, as it only reaches my
> initial fprintf.
>
> Sorry if that seems rambling, not enough caffeine around ;)
> Am I missing
> something really obvious? It looks like the UID argument isn't being
> parsed, although everything else is (does it exit the DSN parsing
> function for any reason?)
>

UID and PWD are not parsed from odbc.ini.
This is clearly (I hope) state in
http://www.freetds.org/userguide/x1848.htm.
odbc.ini is world readable so is not good to store such information on it...

freddy77

=================================
"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."

=================================




Archive powered by MHonArc 2.6.24.

Top of Page