connecting to database in studio 8

The path to Cold Fusion depends on your setup. If you installed Cold Fusion
to run atop IIS, then it would be C:\Inetpub\wwwroot\nameofsite. If you
installed Cold Fusion as a standalone, then it would be
C:\CFusionMX7\wwwroot\nameofsite

The query itself would not contain the path to the database .. that should
be SELECT whatever FROM tablename ..finish query.

In Cold Fusion, you have to have the data source set up in the Cold Fusion
Administrator .. did you do that?


--
Nancy Gill
Adobe Community Expert
BLOG: http://www.dmxwishes.com/blog.asp
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development




"tjones" <webforumsuser@macromedia.com> wrote in message
news:eajdse$bqc$1@forums.macromedia.com...
>I tried to follow the tutorial at
> http://www.adobe.com/devnet/coldfusion/articles/connecting_database.html.
> I'm
> used to asp and asp.net but I'm tring to get into cold fusion. When I
> specify
> the database file as described in the tutorial, the tables come up as
> C:\Inetpub\wwwroot\MyColdFusion\data\MySource.Distributor. And, the final
> select query is SELECT Distributor_ID, Distributor_Name
> FROM C:\Inetpub\wwwroot\MyColdFusion\data\MySource.Distributor
> ORDER BY Distributor_ID ASC
> Why is it putting in the full path to the database? I tried to go to
> advanced
> settings and giving it an actual connection string, but it still asked for
> a
> database file path.
>