I presently have a query run against an Access 2000 db in preparation for a
Verity CFIndex on CF5.This is 5 fields containing about 17,000 records -
runs fine (but slow) on the CF5 box.
Here's the query:
cfquery name=indexCitations datasource= timeout=900
SELECT *
FROM citationsTable
/cfquery
I now want to move this over to CFMX 6.1, but running just a simple query to
return all records throws the following error (after about 15 seconds):
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] The Microsoft Jet database engine stopped the process because
you and another user are attempting to change the same data at the same
time.
There are no other users accessing this db or process since I'm in a test
environment right now.
I've tried increasing the timeout in CFQUERY to 900 with no change.
Is there a way to solve this - I do have access to CFAdmin?
Or should I be looking at other tools, such as dtsearch or the Lucene sw
that was discussed a few days ago? (I'm in a Win 2003 server environment.I
had a lot of problems with Verity when I originally built the app, so I'm
concered that I might be up against a lot more issues here.
PS - The client absolutely refuses to move to SQL2000 or MySQL because the
db is ftp'ed a couple of times a week, and he insists on working on it on
his local windows machine (for speed and searching - he's in it several
hours six days a week), as well as having a few backups.It's his life's
work, and he feels that if he were to loose it, he might as well commit
hari-kari.
Thanks, Mark
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
