FreeTDS Development Group

["Varley, David(CBorn at Alcoa)" <David.Varley AT alcoa.com.au>]

More details on these tests crashing the server.
I've been running the unit tests against a local
SQLServer 7 system rather than JDBC, since it was
having problems some time back, and is also much
slower.
I've just tried the tests using the latest CVS code
against JDBC, and all tests pass, from both Linux
and Tru64 systems.

Testing against SQLServer again, I found that the tests
fail using the #dblibxxx tables due to lack of INSERT
permission, and if I give the login explicit data_writer
or owner permission on tempdb it crashes the server.
As tempdb is rebuilt on server start, next time it fails
permissions again until I change them.
I changed the tests to use permanent tables in another
database on the server, same thing, except as the database
is not rebuilt after the crash I've ended up with database
problems (orphaned logins).

I'm just wondering if anyone has tried running the
unittests against a MS database, and if so if they have
encountered the same problems ?

David

> -----Original Message-----
> From: James K. Lowden [mailto:jklowden AT speakeasy.org]
> Sent: Monday, 9 September 2002 6:03 AM
> To: TDS Development Group
> Cc: David.Varley AT alcoa.com.au
> Subject: [freetds] RE: DBLIB Unit Tests failing again
> 
> 
> On Sun, 8 Sep 2002 11:34:04 +0800, "Varley, David(CBorn at Alcoa)"
> <David.Varley AT alcoa.com.au> wrote:
> 
> > now t0016 and t0017 don't just
> > fail, but also blow the SQLServer process out of the water!
> 
> FreeTDS, the Free Torpedo Data Sequence protocol.  Fire when ready,
> Gridley!
> 
> Sorry, David.  Couldn't help myself.  
> 
> --jkl
> 
> ---
> You are currently subscribed to freetds as: 
> [David.Varley AT alcoa.com.au]
> To unsubscribe, forward this message to 
> $subst('Email.Unsub')
>