Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

"Attempted to read or write protected memory" & index with record id.

Tue, Sep 7 2010 7:47 AM	Permanent Link
dan r na	hi, I have the record id indexing issue within he ODBC driver. thread http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_odbc&msg=1623&page=1 says to delete the offending index, but I don't know how tro delete this as it's name shows as "blank" in dbsys...I've tried "drop index table.""" and drop index table. " and a few others with no joy. any ideas?
Wed, Sep 8 2010 10:53 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Dan, << I have the record id indexing issue within he ODBC driver. thread http://www.elevatesoft.com/forums?action=view&category=dbisam&id=dbisam_odbc&msg=1623&page=1 says to delete the offending index, but I don't know how tro delete this as it's name shows as "blank" in dbsys...I've tried "drop index table.""" and drop index table. " and a few others with no joy. >> Drop it like this: DROP INDEX <TableName>.PRIMARY -- Tim Young Elevate Software www.elevatesoft.com
Wed, Sep 8 2010 11:35 AM	Permanent Link
dan r na	"Tim Young [Elevate Software]" wrote: DROP INDEX <TableName>.PRIMARY Strange - I did that in dbsys and it claims top have executed it - but the index is still there?? Might the database have some strange permissions set on it?
Thu, Sep 9 2010 4:12 AM	Permanent Link
Chris Holland SEC Solutions Ltd. Team Elevate	Hi, If you delete the index and it is the only index on the table I think DBISAM automatically recreates a primary index for you when you try and open the table. Chris Holland [Team Elevate] On 08/09/2010 16:35, dan r wrote: > "Tim Young [Elevate Software]" wrote: > > DROP INDEX<TableName>.PRIMARY > > > Strange - I did that in dbsys and it claims top have executed it - but the index is still there?? > > Might the database have some strange permissions set on it? > -- Chris Holland [Team Elevate]