FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il mer, 2002-09-11 alle 05:11, Varley, David(CBorn at Alcoa) ha scritto:
> 
> 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
> 

I tried with MSSQL7 SP2 MSSQL7 SP3 and MSSQL2K, no problem at all (I
used sa account...). I had a i386 machine with Linux RH 7.2...
Can you post your freetds.log file ??

freddy77