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]
