Well, there it is!! =) I had been so used to selecting Access databases that
I missed the label of "Database Directory" for the text driver and selected
the file instead. Thanks a bunch.
Pablo Nevares
Information Technology
Hendricks & Partners
[EMAIL PROTECTED]
> -----Original Message-----
> From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 02, 2000 2:05 AM
> To: [EMAIL PROTECTED]
> Subject: RE: ODBC Data Source troubles
>
>
> > I was wondering if anyone has had issues adding ODBC DSNs using the
> > Microsoft Text Driver (*.txt, *.csv). My last two attempts at it
> > have ended
> > in ColdFusion Server not being able to verify the DSN.
> >
> > When I try to verify the DSN I get "Failed", and the normal CF warnings
> > about what to check. I've added Access databases through here
> fine, but I
> > always have problems with plain text files. =) Any ideas? Thanks
> > in advance.
>
> You are setting it up to a directory and not to a file name, right?
>
> The text ODBC driver works on a directory, and the name of the "table" in
> SQL is the name of the file, thus if you put "C:\MyTextFiles" as the
> Database Directory, then use
>
> select Date, PackagesSent, SiteTours, InitialOffers
> from MyFile.csv
>
> It should work OK.
>
> 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.
------------------------------------------------------------------------------
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.
