Skip to content

Call for Help: MS Access Select Statement Crashing CF Server

September 16, 2010
tags:

I have a client that still relies on an MS Access database, and I occasionally have a problem with a corrupt mdb file. If I open the file with Access 2000, the field looks empty in datasheet view; in Access 2010 it shows up as ################.
I’m trying to build in some error checking to catch the corrupt data before it gets sent out, and the column typically has a whole lot of data, so I wrote a query in ColdFusion to check if that field is less than 100 characters.


select count(1) as foo from main where len(pers_stmt) < 100

When I ran the page, however, the CF service immediately stopped. There are no entries in the server or application logs, so I can’t figure out what about the request is crashing the server. I even tried wrapping the query in a try/catch and the server still crashed.
Does anyone have any ideas (besides ditching Access) about where I can find logs relating to this?

About these ads
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: