Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread 11013 Access denied to table c/s 4.25 Build 6 Server
Wed, Aug 8 2007 11:55 PMPermanent Link

Dennis Allsopp
Anybody else experiencing the issue with dbisam c/s 4.25 build 6 server
where the second and subsequent login to a database is throwing an
access denied error 11013. Rolling back to an earlier build of the
server, the error disappears.

It seems as if the IF NOT EXISTS function is being ignored, e.g..  The
following passes the test for the first user, then when the next user(s)
logs on it tries to create the index.

CREATE INDEX IF NOT EXISTS "id_source" ON "m100" ("id_source") COMPRESS
FULL;

This problem first surfaced after we installed  dbisam c/s 4.25 build 6
server earlier today.

Dennis
Thu, Aug 9 2007 2:43 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Dennis,

<< It seems as if the IF NOT EXISTS function is being ignored, e.g..  The
following passes the test for the first user, then when the next user(s)
logs on it tries to create the index.

CREATE INDEX IF NOT EXISTS "id_source" ON "m100" ("id_source") COMPRESS
FULL; >>

This was due to this change here:

http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=dbisam&release=4.25&type=f&incident=2297

I will see what I can do to get around this, but for now you'll have to trap
the exception and ignore it.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image