A very academic question:

[blu_sky]

I feel quite silly having to ask for help on what should be a very simple
operation, but I can't seem to figure it out where to upload my files to? I
mean, what is correct path syntax for uploading to the host server. I've been
using Dreamweaver for the past 3 years, built quite a few sites - no problem.
Now I'm giving CF 7 a spin, but I can't get my db to work, even when I put it
in the CFIDE directory. It works fine on my local server, but not when I upload
it to the host. Thanks for the help.

I think that I'll really love CF, once I get it working properly.

[Paul Whitham TMM]

Where you put your sites on the server will depend on how they set up your
domain. Normally on a shared server the CFIDE folder is completely locked
out.

Some hosts have the entry point at the root of the site, whereas others have
a set up where it is one level up from the root so that databases can be
stored outside of the root.

Are you getting a specific error.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"blu_sky" <webforumsuser@macromedia.com> wrote in message
news:d447vs$ofs$1@forums.macromedia.com...

> I feel quite silly having to ask for help on what should be a very simple
> operation, but I can't seem to figure it out where to upload my files to?

I

> mean, what is correct path syntax for uploading to the host server. I've

been

> using Dreamweaver for the past 3 years, built quite a few sites - no

problem.

> Now I'm giving CF 7 a spin, but I can't get my db to work, even when I put

it

> in the CFIDE directory. It works fine on my local server, but not when I

upload

> it to the host. Thanks for the help.
>
> I think that I'll really love CF, once I get it working properly.
>

[blu_sky]

I have full access to the site's root. The error message that I get is: "Error
while processing request. Error Executing database Query. Data source not
found".

The Access db is in the root folder on the host. What am I doing wrong?

[Stressed_Simon]

You need to get your host to create a data source name for you. Remeber when
you created your data source in the CF Administrator. Well your host has to do
the same thing.

Ask them to create you one, if you are lucky they will let you use the same
one that you defined locally. However, some hosts will supply you with one.

That is why it is really a good idea to set your DSN in a variable in the
Application.cfm so that you can change it site wide in one place.

HTH

[Brendon]

Stressed_Simon wrote:

> You need to get your host to create a data source name for you. Remeber when
> you created your data source in the CF Administrator. Well your host has to do
> the same thing.
>
> Ask them to create you one, if you are lucky they will let you use the same
> one that you defined locally. However, some hosts will supply you with one.
>
> That is why it is really a good idea to set your DSN in a variable in the
> Application.cfm so that you can change it site wide in one place.
>
> HTH
>

Also, if you can - get you host to allow you to store the Access DB
outside of the root folder - and set the DSN there - that way, no-one
can browse to the DB and download it.

Cheers
Brendon

[blu_sky]

Thanks guys!!!! I got it to work with the info provided here and also with much help from my new host. As suggested, I had my host locate my db outside of the site's root. Thanks again!