Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Access violation
Fri, Jan 13 2006 2:39 AMPermanent Link

Pete
Hi!

I'm testing dbIsam (v. 4.22) and on my machine everything works fine...
But then I copied DB to another machine (P3 600MHz, 256 MB ram) and ran
my test application.
Opening table is no problem on any machine but query is another story.
I'm constantly getting error "Access violation at address ... module
'shell32.dll'." I just can't execute any query with large result set.

Query example:
select *
from
table1 as t1
left outer join jtable1 as t2 on t1.jfield1 = t2.id
left outer join jtable2 as t3 on t1.jfield2 = t3.id
left outer join jtable3 as t4 on t1.jfield3 = t4.id
left outer join jtable4 as t5 on t1.jfield4 = t5.id
left outer join jtable5 as t6 on t1.jfield5 = t6.id
left outer join jtable6 as t7 on t1.jfield6 = t7.id

All tables except table1 (which have 170.000 records, 50MB of data) are
small (less than 5MB of data).

Thanks for any help!

Best regards,
Pete
Fri, Jan 13 2006 4:07 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Pete,

<< I'm testing dbIsam (v. 4.22) and on my machine everything works fine...
But then I copied DB to another machine (P3 600MHz, 256 MB ram) and ran my
test application. Opening table is no problem on any machine but query is
another story. I'm constantly getting error "Access violation at address ...
module 'shell32.dll'." I just can't execute any query with large result set.
>>

Is there plenty of hard drive space ?  How many records (approximately) are
expected to be returned from the query ?

--
Tim Young
Elevate Software
www.elevatesoft.com



Mon, Jan 16 2006 3:00 AMPermanent Link

Pete
Hi!

Yes the machine does have more than enough free space avaible. I have
also closed all other applications to free more ram.
Number of records: approximately 170.000 records - 60MB.

Best regards,
Pete

Tim Young [Elevate Software] wrote:
> Pete,
>
> << I'm testing dbIsam (v. 4.22) and on my machine everything works fine...
> But then I copied DB to another machine (P3 600MHz, 256 MB ram) and ran my
> test application. Opening table is no problem on any machine but query is
> another story. I'm constantly getting error "Access violation at address ...
> module 'shell32.dll'." I just can't execute any query with large result set.
>  >>
>
> Is there plenty of hard drive space ?  How many records (approximately) are
> expected to be returned from the query ?
>
Mon, Jan 16 2006 1:20 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Pete,

<< Yes the machine does have more than enough free space avaible. I have
also closed all other applications to free more ram. Number of records:
approximately 170.000 records - 60MB. >>

Have you tried this on a different machine ?  Usually a shell32.dll error is
an OS configuration/installation problem.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Jan 17 2006 2:42 AMPermanent Link

Pete
Yes I know this is supposed to be an OS problem but the system is quite
fresh on that computer.
On other computers it works quite well...

Pete


Tim Young [Elevate Software] wrote:
> Pete,
>
> << Yes the machine does have more than enough free space avaible. I have
> also closed all other applications to free more ram. Number of records:
> approximately 170.000 records - 60MB. >>
>
> Have you tried this on a different machine ?  Usually a shell32.dll error is
> an OS configuration/installation problem.
>
Tue, Jan 17 2006 3:32 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Pete,

<< Yes I know this is supposed to be an OS problem but the system is quite
fresh on that computer. On other computers it works quite well... >>

Then there must be something particular about this computer that is causing
it to have a problem with that query, and it must have something to do with
the I/O.  Is there anti-virus software on this computer that isn't on the
other ones ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Image