Hi, I want to read records from a tab delimited log file, so I have defined an ODBC datasource on the directory, and a DSN on the ODBC socket in the CF administrator (CF 9).
All I want to do is read the records: <CFQUERY DATASOURCE="logSMTP" NAME="getLogs"> SELECT * FROM [#file#.log] </CFQUERY> I get this error: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] Cannot update. Database or object is read-only. But I don't to update, just read the file, and the file is not even read only. Is there any way I can define a "read only datasource"? I don't see any parameter for this, either in the ODBC, either in the CF Administrator. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336002 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm