I've done it. It's tricky, but I had to go into the NTServer control panel
and define a DSN there. Once that was done, the CF Administrator could see
it and configure it for ColdFusion. (We have a partner site FTP 6 csv
files into our server every night so we always have up todate information
on our own site.)
After that it worked just like any other ODBC database.
Not sure about it's speed though, compared to SQLServer7 because it wasn't
an application that was subject to high traffic.
Perhaps someone else can advise whether it would be faster or slower than
the grown-up database?
Mike Kear
[EMAIL PROTECTED]
www.afp.zip.com.au
Windsor, NSW, Australia
AFP Web Development
AFP Electronic Forms
AFP Models
At 10:28 AM 11-08-00 -0400, you wrote:
>CF Gurus,
>
>I have a customer that is a car dealership. They want to put their car
>inventory online.
>The company that makes their inventory database tells me that the data store
>is not ODBC compliant, but that they could output a CSV text file that they
>will auto-FTP to our servers in the middle of the night. Not exactly the
>most elegant solution, but it beats entering car data manually. :)
>
>Can I create an ODBC connection in the CF Administrator to use a CSV text
>file as a data source? I tried but I could not get it to verify the data
>source.
>
>Any Tips or place I could go to for more info?
>
>
>John McKown, VP of Business Services
>Delaware.Net, Inc.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>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.mail-archive.com/[email protected]/
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.
