Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread dbisam 3.3 / kbmmw : alter table
Mon, Nov 13 2006 4:29 AMPermanent Link

"Harry de Boer"
LS

We're using kbmMW (2.6+) middleware components together with dbIsam 3.3. I
am writing a query tool that also allows dml statements. DROP TABLE and
CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error # 11013
Access denied to table "path + table". The table is not in use by anyone,
nor is the directory read only! Anyone any idea?

Regards, Harry

Mon, Nov 13 2006 3:08 PMPermanent Link

"Peter Mora"
For what its worth, I am using Dbisam 4.22 and kbmMW 2.5,
and I am able to use the following statement:

 ALTER TABLE IF EXISTS My_Table
   ADD IF NOT EXISTS my_field BOOLEAN AT 11;

I use a TkbmMWClientQuery and call the "Execute"
method (not the "Open" method).

-Peter


"Harry de Boer" <harry@staaf.nl> wrote in message
news:4D409BD0-C1FC-4F3A-8B5A-D882E2296D41@news.elevatesoft.com...
> LS
>
> We're using kbmMW (2.6+) middleware components together with dbIsam
> 3.3. I
> am writing a query tool that also allows dml statements. DROP TABLE
> and
> CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error
> # 11013
> Access denied to table "path + table". The table is not in use by
> anyone,
> nor is the directory read only! Anyone any idea?
>
> Regards, Harry
>
>

Mon, Nov 13 2006 5:17 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< We're using kbmMW (2.6+) middleware components together with dbIsam 3.3.
I am writing a query tool that also allows dml statements. DROP TABLE and
CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error # 11013
Access denied to table "path + table". The table is not in use by anyone,nor
is the directory read only! Anyone any idea? >>

The table must be open by someone or something - an access denied error
comes directly from the OS.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Nov 14 2006 3:45 AMPermanent Link

"Harry de Boer"
Tim,

I thought of that at first too, but that's not true. Even when I do this on
one pc, restart the pc and execute the statement, the error occurs. With
dbSys it's ok, but via kbmMW it's not. The DROP and CREATE work well though.

Regard, Harry


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht
news:79C76483-D8F8-4E32-BC74-583818F0AF6B@news.elevatesoft.com...
> Harry,
>
> << We're using kbmMW (2.6+) middleware components together with dbIsam
3.3.
> I am writing a query tool that also allows dml statements. DROP TABLE and
> CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error #
11013
> Access denied to table "path + table". The table is not in use by
anyone,nor
> is the directory read only! Anyone any idea? >>
>
> The table must be open by someone or something - an access denied error
> comes directly from the OS.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>
>

Tue, Nov 14 2006 3:47 AMPermanent Link

"Harry de Boer"
Peter,

I use the execute method too. I will report to Kim that the configuration
you have does work, thanks.

Regards, Harry

"Peter Mora" <PeterXXMoratekXXXCom> schreef in bericht
news:66D32B3E-BA99-470C-8D7D-31BF2DDDC2AB@news.elevatesoft.com...
> For what its worth, I am using Dbisam 4.22 and kbmMW 2.5,
> and I am able to use the following statement:
>
>   ALTER TABLE IF EXISTS My_Table
>     ADD IF NOT EXISTS my_field BOOLEAN AT 11;
>
> I use a TkbmMWClientQuery and call the "Execute"
> method (not the "Open" method).
>
> -Peter
>
>
> "Harry de Boer" <harry@staaf.nl> wrote in message
> news:4D409BD0-C1FC-4F3A-8B5A-D882E2296D41@news.elevatesoft.com...
> > LS
> >
> > We're using kbmMW (2.6+) middleware components together with dbIsam
> > 3.3. I
> > am writing a query tool that also allows dml statements. DROP TABLE
> > and
> > CREATE TABLE do work, but ALTER TABLE raises an error: Dbisam error
> > # 11013
> > Access denied to table "path + table". The table is not in use by
> > anyone,
> > nor is the directory read only! Anyone any idea?
> >
> > Regards, Harry
> >
> >
>
>

Tue, Nov 14 2006 8:47 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< I thought of that at first too, but that's not true. Even when I do this
on one pc, restart the pc and execute the statement, the error occurs. With
dbSys it's ok, but via kbmMW it's not. The DROP and CREATE work well though.
>>

Is kbmMW caching any data modules or anything that would keep a table open
longer than expected ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Sat, Nov 3 2012 3:02 PMPermanent Link

lisun

I need help with this error, when I alter the table, If I change the name of the existed field, it works well. but when I add a new field, the error 11013 show. please help me to fix this error...., because I have to add a new field on my table.
Sat, Nov 3 2012 3:03 PMPermanent Link

lisun

lisun wrote:

I need help with this error, when I alter the table, If I change the name of the existed field, it works well. but when I add a new field, the error 11013 show. please help me to fix this error...., because I have to add a new field on my table.
Mon, Nov 5 2012 3:12 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Lisun,

<< I need help with this error, when I alter the table, If I change the name
of the existed field, it works well. but when I add a new field, the error
11013 show. please help me to fix this error...., because I have to add a
new field on my table. >>

Per email:

Please see here:

http://www.elevatesoft.com/supportfaq?action=view&category=dbisam&question=alter_table_access_denied

Tim Young
Elevate Software
www.elevatesoft.com
Image