Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Silly question about Database Server
Fri, May 24 2013 4:14 PMPermanent Link

John Taylor

New to the database server, so bear with me...

How does one empty table, alter table, etc. from DBSys, ie functions
required Exclusive access ?

I have DBsys open, the DBSrvr shows only one connection so I know there are
no other connections,
I'm getting access denied when I try to empty table, or any other function
requiring Exclusive access.

What have I missed ?

Thanks
JT
Fri, May 24 2013 7:13 PMPermanent Link

Raul

Team Elevate Team Elevate

As long as you're the only connection to the table it should just work -
is OK here. i can empty or alter a CS table just fine.

Make sure you don't have any tables or queries open in the DBSYS when
you do empty/alter - dbsys maintains a single connection to DBSRVR but
you can still have multiple query/table windows active in dbsys.

Same applies to make any non-CS (meaning direct file system) connections
to table.

Raul



On 5/24/2013 4:14 PM, John Taylor wrote:
> New to the database server, so bear with me...
>
> How does one empty table, alter table, etc. from DBSys, ie functions
> required Exclusive access ?
>
> I have DBsys open, the DBSrvr shows only one connection so I know there
> are no other connections,
> I'm getting access denied when I try to empty table, or any other
> function requiring Exclusive access.
>
> What have I missed ?
>
> Thanks
> JT
Sat, Jun 1 2013 11:36 AMPermanent Link

John Taylor

Yes, you are correct, it *should* work.  But I can consistently get access
denied when the DBServer shows only 1 connected session
which is DBSys.  There are no other processes running that use dbisam, just
the IDE and there are no active sessions within the
Datamodule

JT

"Raul" <raul@removethis.raul.ca> wrote in message
news:4D14B908-38EC-42E3-995C-8998522169C3@news.elevatesoft.com...
> As long as you're the only connection to the table it should just work -
> is OK here. i can empty or alter a CS table just fine.
>
> Make sure you don't have any tables or queries open in the DBSYS when you
> do empty/alter - dbsys maintains a single connection to DBSRVR but you can
> still have multiple query/table windows active in dbsys.
>
> Same applies to make any non-CS (meaning direct file system) connections
> to table.
>
> Raul
>
>
>
> On 5/24/2013 4:14 PM, John Taylor wrote:
>> New to the database server, so bear with me...
>>
>> How does one empty table, alter table, etc. from DBSys, ie functions
>> required Exclusive access ?
>>
>> I have DBsys open, the DBSrvr shows only one connection so I know there
>> are no other connections,
>> I'm getting access denied when I try to empty table, or any other
>> function requiring Exclusive access.
>>
>> What have I missed ?
>>
>> Thanks
>> JT
>
Sat, Jun 1 2013 12:21 PMPermanent Link

Raul

Team Elevate Team Elevate

JT

I'm not saying it should but that it works for me OK - dbisam 4.35b2.

Just to simplify the issue:
- close IDE to eliminate it completely
- run dbsys and make sure there is only 1 query window open in dbsys
(since all the dbsys windows share the single session)

Are you still getting the error ?

Do you have anti-virus running - any chance its locking the tables?

you could use somethign like Sysinternals Process Monitor
(http://technet.microsoft.com/en-us/sysinternals/bb896645) to all file
access attempts against the table(s) in question just to confirm only
dbsrvr is accessing the tables.


Raul



On 6/1/2013 11:36 AM, John Taylor wrote:
> Yes, you are correct, it *should* work.  But I can consistently get
> access denied when the DBServer shows only 1 connected session
> which is DBSys.  There are no other processes running that use dbisam,
> just the IDE and there are no active sessions within the
> Datamodule
>
> JT
Wed, Jun 12 2013 9:06 PMPermanent Link

Adam H.

Hi John,

Another suggestion that I'll throw forward is:

1) Close all users out of the application.

2) Stop the DBSRVR service/application.

3) delete any .lck files in the database location. (These may be hidden,
so you may need to do something to deal with these first).

I normally use the command prompt and execute the following in the
database location

attrib *.lck -r -a -s -h
del *.lck /s

4) Just for good measure, reset the permissions on the directory, and
set to apply to all subfolders and files.

5) Restart, and see how you go.

Cheers

Adam.
Image