Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

connecting to database in studio 8

New Here ,
Jul 30, 2006 Jul 30, 2006
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.
TOPICS
Server side applications
225
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jul 31, 2006 Jul 31, 2006
LATEST
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.
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines