FreeTDS Development Group

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

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')