FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

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