Skip to Content.
Sympa Menu

freetds - Re: make test fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brian Bruns <camber AT umcc.ais.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: make test fails
  • Date: Fri, 10 Mar 2000 18:25:37 -0500 (EST)



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





Archive powered by MHonArc 2.6.24.

Top of Page