Re: Read only text datasource?
OK, I found the problem. Since some update, for security reason, the Microsoft text ODBC driver does not read files with extensions other that .txt, .tab, or .csv... First, I do not see why it could be dangerous to read files with .log extension, and last but not least, it would have been so simple to generate a clear message like does not read files with extensions other that .txt, .tab, or .csv.. Microsoft is definitely the leader for stupid error messages. ~| 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:336042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Read only text datasource?
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