FreeTDS Development Group

[John Dejournett <johnde AT greeley.sykes.com>]

Brian,

No such luck on this.  The server uses server login in this case.  They have
a completely different form from our domain logins.  I am going out on a
limb here, but I am at least reasonably certain that I did enter my login
information correctly in the PWD file.  I'll be sure to confirm that anyway.
Any other ideas?

Sincerely,
John DeJournett



                -----Original Message-----
                From:   Brian Bruns [mailto:camber AT umcc.ais.org]
                Sent:   Friday, March 10, 2000 4:26 PM
                To:     TDS Development Group
                Subject:        [freetds] Re: make test fails


                Ok, so we are talking to the SQL Server, but receiving a
negative
                acknowlegement.  One probable cause it that the sql server
is using domain
                login and not server logins.  The other (but not probable)
couase would be
                the login/password is wrong :-)

                Brian

                On Fri, 10 Mar 2000, John Dejournett wrote:

                > Brian,
                > 
                > SYBASE is set to /usr/local/freetds, and the interfaces
file is present.  I
                > am including a copy of the tds->msg_info data.  Hopefully
this will be
                > useful in determining the actual cause of the failure.
                > 
                >   priv_msg_type = 1, 
                >   line_number = 0, 
                >   msg_number = 4002, 
                >   msg_state = 1, 
                >   msg_level = 14, 
                >   server = 0x804ac90 "Microsoft SQL Server",
                >   message = 0x804ac78 " Login failed\r\n", 
                >   proc_name = 0x0, 
                >   sql_state = 0x0
                > 
                > Other than the "Login failed" message, the only thing that
looks like a clue
                > here is 4002.  Generally when I get this error number on a
Windows system I
                > start looking into the ODBC configuration.  It was my
impression that
                > FreeTDS does not require an ODBC in order to operate.  Is
this correct?
                > As always, help, suggestions, comments, and a good knock
on the head are
                > very much appreciated :)
                > 
                > Sincerely,
                > John DeJournett
                > 
                > 
                >               -----Original Message-----
                >               From:   Brian Bruns
[mailto:camber AT umcc.ais.org]
                >               Sent:   Friday, March 10, 2000 3:07 PM
                >               To:     TDS Development Group
                >               Subject:        [freetds] Re: make test
fails
                > 
                > 
                >               Have you've set the SYBASE environment
variable to the place
                > where
                >               you installed freetds?
                > 
                >               To turn on logging on set the TDSDUMP env
variable, for
                > instance 'export
                >               TDSDUMP=/tmp/freetds.log'
                > 
                >               Brian
                > 
                >               On Fri, 10 Mar 2000, John Dejournett wrote:
                > 
                >               > Brian,
                >               > 
                >               > I tried running the t0001 test, but the
only output was
                > "tds failed! on
                >               > t0001.c".
                >               > 
                >               > This inspired me to do a little debugging
on the test
                > source.  The first
                >               > thing I discovered is that in
freetds/src/tds/util.c, line
                > 245 there is a
                >               > test to determine if the interfaces file
is present.  For
                > some reason
                >               > interf_file = \000, and the test failed.
Because of this,
                > the interfaces
                >               > file was never being read.  As a temporary
workaround for
                > this I copied the
                >               > /usr/local/freetds/interfaces file to
~/.interfaces.  This
                > did work to get
                >               > the server IP and port numbers.  Anyone
who knows how to
                > fix this, I would
                >               > greatly appreciate a suggestion.
                >               > 
                >               > Now back to the main issue.  After some
further debugging
                > the t0001 program
                >               > is connecting to the server.  It sends
login information,
                > but apparently the
                >               > login fails.  It also appears that there
is a log file
                > that tracks these
                >               > transactions with the server.  If anyone
knows where that
                > file is and what
                >               > it is called, this may contain some useful
information on
                > exactly what the
                >               > error is.
                >               > 
                >               > Finally, another note for the
implementers:  not that I
                > don't appreciate
                >               > having the libraries already  compiled
with the debugging
                > information, but
                >               > to make the libraries as small as possible
I would suggest
                > having a switch
                >               > in the configure options to enable or
disable debugging.
                >               > 
                >               > Sincerely,
                >               > John DeJournett
                >               > 
                >               > 
                >               > 
                >               >               -----Original Message-----
                >               >               From:   Brian Bruns
                > [mailto:camber AT umcc.ais.org]
                >               >               Sent:   Thursday, March 09,
2000 5:22 PM
                >               >               To:     TDS Development
Group
                >               >               Subject:        [freetds]
Re: make test
                > fails
                >               > 
                >               > 
                >               >               try running one of the
example programs and
                > see what the
                >               > error is.
                >               > 
                >               >               [camber@localhost freetds]$
cd
                > src/tds/unittests
                >               >               [camber@localhost
unittests]$ make
                >               >               [camber@localhost
unittests]$ ./t0001
                >               > 
                >               >               Brian
                >               > 
                >               >               On Thu, 9 Mar 2000, John
Dejournett wrote:
                >               > 
                >               >               > Michael,
                >               >               > 
                >               >               > Thanks for the suggestion.
It is a start,
                > but make test
                >               > still fails every
                >               >               > test.  The PWD file now
contains entries
                > for my login
                >               > name, password, the
                >               >               > server entry name from
                > /usr/local/freetds/interfaces, and
                >               > the database name.
                >               >               > I doubt that it would make
any difference,
                > but I am
                >               > running configure with
                >               >               > the -with-tdsver=4.2
parameter, and the
                > database I am
                >               > using in interfaces is
                >               >               > an MS-SQL server.
                >               >               > 
                >               >               > I did not notice anything
in the install
                > file or
                >               > documentation for editing
                >               >               > the PWD, so that would be
a good note for
                > the
                >               > implementers/maintainers.  Any
                >               >               > other ideas to get these
tests working
                > would be greatly
                >               > appreciated.
                >               >               > 
                >               >               > Sincerely,
                >               >               > John DeJournett
                >               >               > 
                >               >               >
-----Original Message-----
                >               >               >               From:
Michael Suedkamp
                >               > [mailto:ms AT suedkm.franken.de]
                >               >               >               Sent:
Wednesday, March 08,
                > 2000 6:01 PM
                >               >               >               To:     TDS
Development
                > Group
                >               >               >               Subject:
[freetds]
                > Re: make test
                >               > fails
                >               >               > 
                >               >               >               Have you
adapted the PWD
                > file?
                >               >               > 
                >               >               >               Michael
                >               >               > 
                >               >               >               ---
                >               >               >               You are
currently subscribed
                > to freetds as:
                >               >               > johnde AT greeley.sykes.com
                >               >               >               To
unsubscribe, forward this
                > message to
                >               >               >
$subst('Email.Unsub')
                >               >               > 
                >               >               > ---
                >               >               > You are currently
subscribed to freetds
                > as: camber AT ais.org
                >               >               > To unsubscribe, forward
this message to
                >               > $subst('Email.Unsub')
                >               >               > 
                >               >               > 
                >               > 
                >               > 
                >               >               ---
                >               >               You are currently subscribed
to freetds as:
                >               > johnde AT greeley.sykes.com
                >               >               To unsubscribe, forward this
message to
                >               > $subst('Email.Unsub')
                >               > 
                >               > ---
                >               > You are currently subscribed to freetds
as: camber AT ais.org
                >               > To unsubscribe, forward this message to
                > $subst('Email.Unsub')
                >               > 
                >               > 
                > 
                > 
                >               ---
                >               You are currently subscribed to freetds as:
                > johnde AT greeley.sykes.com
                >               To unsubscribe, forward this message to
                > $subst('Email.Unsub')
                > 
                > ---
                > You are currently subscribed to freetds as: camber AT ais.org
                > To unsubscribe, forward this message to
$subst('Email.Unsub')
                > 
                > 


                ---
                You are currently subscribed to freetds as:
johnde AT greeley.sykes.com
                To unsubscribe, forward this message to
$subst('Email.Unsub')