Datasource Resources????

[moosesmom28]

Hi. I am new to all of this, but am using Coldfusion MX 7 developer, and need
to know more about connecting to a data source. We have a business application
on its own server, with a stand-alone PC that can access data from the
application files via an ODBC driver using a mapped drive to the application
server. How can I use coldfusion to get data from the ODBC on the stand-alone
PC? We will be using a web-host that supports Coldfusion MX 7. Everything I
read in books talks mostly about connecting to an Access Database residing on
the same server as Coldfusion, which works great, but doesn't help me outside
of tutorials! Are there any resources out there for a beginner to all of this
that needs to deal with ODBC???? Any help is appreciated! Thanks!

[philh]

If you're using a hosted site, you'll need to send them the data file and have them create the DSN for the database. They won't be able to connect to it if it lives at your site.

[moosesmom28]

It isn't actually a file. It is several files and ODBC is the only way I have
of getting data out of them (proprietary application software package). Is
there no way for me to talk to the ODBC on the stand-alone PC from a hosted
web-site using Coldfusion? If I have to go the route of using ODBC to populate
an Access mdb file and send that periodically to the host site, is that the
only way out?