Newbie DB Connectivity Question :-\

[KristenStork]

:o Hi all,

I need a little bit of help, heres my problem: I successfully developed a
database and website in ColdFusion on my local server. I then went to a hosting
company that offers ColdFusion Database Support as a service. I uploaded my
website to the hosting company. I also uploaded the access .mdb file to another
section of the site.

The basic layout of my Coldfusion Site on the server now looks like this:

I have the site in the wwwroot folder.
The database is stored in a folder within the wwwroot folder (e.x.
wwwroot/mycfdatabase/)

The problem that I am having now is that I don't know how to get the website
files to point to the database so that they can access them. I did this
correctly for the local site (before uploading it to the server), through my cf
admin panel. I do not want to develop the site remotely, but I want it to work
online with the database.

Can anyone help me?

:gift; Kristen

[rmorgan]

You will have to setup a new datasource on the remote server, the isp should give you the info on how to go about accessing the CF admin on setting it up.

[mpwoodward *TMM*]

KristenStork wrote:

> :o Hi all,
>
> I need a little bit of help, heres my problem: I successfully developed a
> database and website in ColdFusion on my local server. I then went to a hosting
> company that offers ColdFusion Database Support as a service. I uploaded my
> website to the hosting company. I also uploaded the access .mdb file to another
> section of the site.
>
> The basic layout of my Coldfusion Site on the server now looks like this:
>
> I have the site in the wwwroot folder.
> The database is stored in a folder within the wwwroot folder (e.x.
> wwwroot/mycfdatabase/)
>
> The problem that I am having now is that I don't know how to get the website
> files to point to the database so that they can access them. I did this
> correctly for the local site (before uploading it to the server), through my cf
> admin panel. I do not want to develop the site remotely, but I want it to work
> online with the database.
>
> Can anyone help me?
>
> :gift; Kristen
>

Your hosting company should have some way of creating a datasource
within CF, or they should have a ticketing system that will allow you to
submit a request and they'll create one for you. Most hosting companies
either have a control panel you can log into and create datasources by
providing a datasource name and the location of your Access file, then
behind the scenes that creates a datasource in CF. One way or another
the datasource information needs to get into CF on the remote server, so
you'll just have to see how your hosting company handles that.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[KristenStork]

rmorgan & mpwoodward:

Thank you for your help. I contacted my ISP and got the issue resolved!