Dave, Thanks for the pointer. On my developers server, I changed the driver from Microsoft Access with Unicode to plain Microsoft Access. The query returned the same error as the production server.
This is the first conflict I've noted throughout the development and testing of the application. If I ask the system admin to change the driver to unicode, is that likely to cause any problems? I'm the only one using that particular DB, and like I said, all apps test well on my local server. So can I assume that first removing and then adding the DB in Coldfusion administrator will resolve my problem without creating another? thanks in advance. John >That error is coming from your MS Access driver. You might want to confirm >that you have the same driver version installed on both machines as well to >eliminate that as a possibility. Not sure how to do that off the top of my >head. > >Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4270 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
