Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: Can't connect to logfile in .CSV format with .LOG extenstion


Message #1 by sales@d... on Wed, 25 Sep 2002 03:10:40
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

  Return to Index