Database access from a remote server

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.

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.