FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Russell Kroboth [mailto:rkroboth AT visitraleigh.com]
> Sent: February 24, 2003 3:54 PM
> 
> unfortunately the SQL Server here is the only datasource I 
> have, so I'm not
> sure.  Also, I installed FreeTDS from an RPM 
> (freetds-0.60-1.i386.rpm). Is
> there another way to test that it is installed correctly?

Logging.  Set the TDSDUMP and TDSDUMPCONFIG environment variables, run your
command, and have a look.  Very likely FreeTDS isn't being asked to connect
to the system you think it is.  The top of the TDSDUMP log shows the
address, port, and TDS version being used, and if you squint you can see the
username and password, too.  

HTH.

--jkl






> > From: Craig Davison [mailto:cd AT securityfocus.com]
> > Sent: Monday, February 24, 2003 3:44 PM
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] problems configuring..
> > 
> > 
> > On Mon, Feb 24, 2003 at 03:30:25PM -0500, Russell Kroboth wrote:
> > > I am having a problem configuring FreeTDS to access my MS 
> > SQL database, at
> > > the point that I test the connection I am getting the 
> > following error?  Can
> > > anybody give me an idea as to where my error might be? I 
> > have a user on the
> > > SQL server named "testuser" with the password "password1"
> > > Thanks...
> > > 
> > > -bash-2.05b# isql -v P450 testuser password1
> > > [unixODBC][Driver Manager]Driver's SQLAllocHandle on 
> > SQL_HANDLE_HENV failed
> > > [ISQL]ERROR: Could not SQLConnect
> > 
> > Does isql work for you with other (non-freetds) data sources?
> > 
> > -- 
> > Craig Davison
> > Symantec Corporation
> > +1 (403) 213-3939 ext. 228
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.