asp_database_setup thread: Can't connect to logfile in .CSV format with .LOG extenstion
I daily save information to a text file "signoff.log" in .CSV format.
Currently I look at it directly with a web browser.
My intent was to view it through a database connection so I could query it
(filter, sort, etc.)
Then connection string is created with the following code:
provider="Provider=Microsoft.Jet.OLEDB.4.0;"
properties="Extended Properties=""text;HDR=Yes;FMT=Delimited;"";"
datasource="Data Source=" & server.mappath(".")
CONN=provider & properties & datasource
The error I get is:
Cannot update. Database or object is read-only.
If I change the extension of the file to .csv: IT WORKS!!!
However, I want to be able to identify all my log files using the .log
extension.
How can I inform OLEDB that I want to use the .LOG extension for text
files?
Thanks,
Dan