Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
Access violation |
Fri, Jan 13 2006 2:39 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |