> I'm trying to use a text file as a datasource, but the source keeps
> failing to verify. The driver is Microsoft Text Driver(NT, IIS) and the
> file is a .txt file. One of the items on the error screen says:
>
> "For some databases the ColdFusion Server may need to be logged in under
> a special NT account rather than the default System Account. Use the
> Windows NT Services Control Panel to change the account the ColdFusion
> Server service is using. "
>
> We switched the CF services to an admin account(was that wise?), but the
> source(and other test text sources) still fails. Has anyone ever
> encountered this? I expected text datasources to be trivial. The data
> was exported from an Access table and contains no date or number values.
> The field names are the first row.
OK, just checking on this, you are setting the Database Directory to the
directory, and not to the file name, right?
If you are, then it should verify - then in SQL you call it with
select * from myFile.txt
HTH
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
