This content has been marked as final. Show 3 replies
Yes you can. As long as the database server is available remotely. You would need the IP of the database server.
However, keep in that for every request that involves a query, you are going to have to make that jump from one server to the other. This could add a considerable amount of time to your request.
How do I set up something like that? I cannot find anything to set it up under dreamweaver.
There is nothing to setup in Dreamweaver. What you describe is the typical setup. It is preferable to have one server running your Oracle, MSSQL or other database, while ColdFusion is hosted on another server. Typically when you create a to an enterprise database like MSSQL or Oracle, you input the servername as one of the attributes to the datasource.
You can review setup of ColdFusion datasources in the administratror's guide. Datasource's are usually setup in the ColdFusion administrator - although dreamweaver give's you an interface to do this same functionality.