Question
connecting to database in studio 8
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.
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.
