Re: Access db Query error

2003-10-17 Thread Jochem van Dieten
Mark Leder said:

 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.
 

Have you tried the Access with Unicode driver?

Jochem


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Access db Query error

2003-10-17 Thread Mark Leder
Jochem,
That simple change to Unicode support worked. Query runs in about 1.5
seconds now.

 
Thanks!
Mark 

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Friday, October 17, 2003 5:07 AM
To: CF-Talk
Subject: Re: Access db Query error

Mark Leder said:

 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.
 

Have you tried the Access with Unicode driver?

Jochem

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]