I need informations.
Pvsw8 server NT on WTS server2003

Suppose I open FILE.BTR with FUNCTION EXECUTOR and then I go to
MONITOR to DELETE this user. For next operation of EXECUTOR obviously
I get STATUS 3. First time, I try to reopen FILE.BTR I get STATUS 170
and next times STATUS 171 (same status for all files I try to open, no
matter if I open the files before). I need to reload FUNCTION EXECUTOR
to etablish a new connection and everything OK.

With the Work group engine I can reopen without status

1) Can I etablish a new session without quit the application?
2) What's the meaning of "wrong or missing user name" or "wrong or
missing PWD"
ande the status 170-171? (I'm "administrator" in this case)

Thanks

My guess is that until you "tell" the client to close the conection
with a Btrieve Stop or Reset it is assuming you are still
authenticated and it does not re-send your credentials to the engine
on the next open. Try a stop or reset then another open.

You don't say which version of the workgroup engine. The security
status codes did not exist before Pervasive.SQL 8.5 and even then the
Workgroup engine, while it can do the security, does not have any in
"clasic" mode.

For the server engine the default configuration is that security is
set to "Clasic" so you should not be getting a status 170 or 171.
Make sure that you have a "DefaultDB" named database and that the
security on that database is set to "Clasic". I have seen the engine
behave strangely unless the named database exists and is set.
This is of course assuming that you (or the application) is not doing
a login to a specific database and that the database files are not
bound to a different database.

Leonard

On 19 Jan 2005 13:49:41 -0800, ddion (AT) infopharm (DOT) ca (danny_dion) wrote: