Dreamweaver, ColdFusion, MS SQL

[Brad O]

I am new to the three major aspects of my current web programming situation.
I am using Dreamweaver MX 2004, a local version of ColdFusion version
6,1,0,63958 (that I installed from the Dreamweaver disk), and a web server
that is running Microsoft SQL Server 2000. And I am having a problem getting
everything to work together properly.

If I configure my local ColdFusion server with the ability to access my
database on my remote MS SQL 2000 server and then try to preview a template
in my browser, I get a standard browser error that says, "The page cannot be
displayed". I cannot even get browser access to my templates in my working
folder by going to C:\CFusionMX\wwwroot\ My ability to view the files in a
browser is gone. If however, I remove the datasource completely, the pages
load correctly, but with errors because they cannot access my database.

I am working on a pre-existing site, so in order to understand how it
functions I want to be able see the debugging window to track the variables.
I do not have control of the remote ColdFusion server that is hosting the
actual site, so it would seem to me the best way to accomplish what I want
would be to go with the setup that I am trying for. That is, preview my
local copy of the files on my local system and pulling the database
information from the remote SQL Server.

I just cannot seem to get it to work.

Thank you for your help,
Brad O

[Brad O]

If no one wants to touch this question, maybe somebody out there knows a
group that would be better able to handle it.

Thanks,
Brad O



"Brad O" <reply@tothegroup.please> wrote in message
news:zWDAe.39773$B_3.29217@fe05.lga...

>I am new to the three major aspects of my current web programming
>situation. I am using Dreamweaver MX 2004, a local version of ColdFusion
>version 6,1,0,63958 (that I installed from the Dreamweaver disk), and a web
>server that is running Microsoft SQL Server 2000. And I am having a problem
>getting everything to work together properly.
>
> If I configure my local ColdFusion server with the ability to access my
> database on my remote MS SQL 2000 server and then try to preview a
> template in my browser, I get a standard browser error that says, "The
> page cannot be displayed". I cannot even get browser access to my
> templates in my working folder by going to C:\CFusionMX\wwwroot\ My
> ability to view the files in a browser is gone. If however, I remove the
> datasource completely, the pages load correctly, but with errors because
> they cannot access my database.
>
> I am working on a pre-existing site, so in order to understand how it
> functions I want to be able see the debugging window to track the
> variables. I do not have control of the remote ColdFusion server that is
> hosting the actual site, so it would seem to me the best way to accomplish
> what I want would be to go with the setup that I am trying for. That is,
> preview my local copy of the files on my local system and pulling the
> database information from the remote SQL Server.
>
> I just cannot seem to get it to work.
>
> Thank you for your help,
> Brad O
>