> For the first time I'm trying to use a text file as a data source. The
> problem is that all that I attempt to create fail to verify. 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."
>
> Is this a clue? I'm not much of an NT person and didn't know accounts
> were created for services.
OK, 2 questions:
1) what have you set up as the Database Directory? This MUST be a directory,
and not the file name - the file name is the name of the SQL table
2) does the CF login have access to said directory? If not, make it so...
The main problem I ran into originally (and have helped with here) is that
the Database Directory is set up as the file name; c:\myData\myFile.csv
rather than c:\myData
When accessing via a CFQuery, the SQL would be;
select * from myFile.csv
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.
