>>You might try passing delimiter=';' as an additional dsn parameter.
BINGO! The problem is that the file Schema.ini is not properly updated by the 32 bit ODBC Administrator. In my W 7 file I see Format=Delimited(;) which is correct, but in the W 2008 file I have Format=CSVDelimited I set Delimited(;) in the W 2008 file and now it works like a charm. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm