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

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