Intermittent ODBC Error After Deleting Duplicates

Post a reply

In an effort to prevent automatic submissions, we require that you complete the following challenge.
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review

Expand view Topic review: Intermittent ODBC Error After Deleting Duplicates

by jiri » Sun Feb 08, 2004 4:34 am

Actually, after reviewing the code I think the problem is fixed now and will be ok in the next release. Anyway, if you get to the debug log, I'd really like to see it.


by jiri » Sun Feb 08, 2004 4:24 am

That's interesting, could you please generate a debug log of this error so that I can see the whole context of the problem (see for a description of how to do it). Send it to my e-mail then, please.


Intermittent ODBC Error After Deleting Duplicates

by halftime » Sat Feb 07, 2004 12:32 pm

Symptoms: I pull up the "Duplicate Titles" view in "Files To Edit" node. I select a number of songs to delete and click he Delete button on my keyboard. I choose "Delete from Library and File System" option. The deletions proceed and the deleted titles disappear from the view. But some seconds afterward (usually 3-5 seconds), I get an error dialog with this text:

There was following problem with querying database:
40000:[Microsoft][ODBC Microsoft Access Driver]Syntax error
(missing operator) in query expression 'UCASE(LEFT(SongPath,
95)) = UCASE(':\MP3Library\SongTitle.mp3') AND IdMedia=44.

I get Cancel/Retry/Ignore buttons. Cancel and Ignore clear the error. Retry never has. It doesn't happen every time I delete duplicates, but when it does happen, that's where it happens. I might get several of these for a block of duplicates deleted and each one that comes up stops me from doing anything else until it's cleared.

ENV: WinXP w/SP3 on a P3650 w/ 256MB PC133SDRAM. My Access installation is Office XP Developer install.