Solved

Dreamweaver connection to a ColdFusion Server

Posted on 2007-04-02
32
363 Views
Last Modified: 2013-12-24
Has anyone successfuly connected Dreamweaver 8 to a remote ColdFusion Server ?  I have tried but I cannot get RDS to work it says I have an invalid URL Prefix.  Any insight would be greatly appreciated.

I own the Adobe Web Bundle by the way that has almost all of their products.
0
Comment
Question by:ostashenp
  • 18
  • 14
32 Comments
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
Assuming you have the RDS password for the CF Server, the way I do it is by setting up a ODBC connection via the control panel of my pc under the System DSN tab to the datasource.  
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
Well my web server hosted by apservers.com and I am running Linux with a MySql database, does this mean anything or is it irrelevent ?  If I make the ODBC connection you think it will work ?
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
ODBC is the only part that matters.  APServers.com may have a restriction in place but otherwise, I use DW and Microsoft Access to connect to my datasource which is hosted by CrystalTech (db is SQL2000) so it should work just fine.  It should work as long as you are not behind a corporate firewall.  When I am at home, I can connect to my providers datasource but I cannot from work due to the firewall.

Also, when you setup the ODBC in your control panel, be sure to input your username and password (you can't use windows authentication).
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
well APServers blocks RDS that is why I could not connect in the first place....
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
OK

I am really confused...I dont have alot of Coldfusion expierence but I have good deal of PHP expierence.  Connecting to a mysql database with a PHP connection page is easy.  On my webserver I have created a Coldfusion DSN....What do I do with this connection ? How do I use it ?
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
Change providers?  Just kidding.  I'm not 100% what you are asking but I'll answer what it is that I think you are asking...

Here is my setup I have.

- I have CF Server (Developer's Edition - the free one) installed.  
- Inside of the Admin, I created an RDS login
- I have  the ODBC connection setup to my providers db (in my case, I'm using SQL2000)
- Inside of the CF Admin, I created a datasource pointing to the ODBC I just setup in the previous step.
- Inside of Dreamweaver, when I click the Application/Database tab, I'm prompted for a password.  I enter the password I provide to the CF Admin.  Once I enter the password, I can see the tables.  My setup is a little odd but it works well.

Not knowing your web server setup this may not work for you, but try this, create the ODBC connection (via your control panel).  Then see if you can use Microsoft Access to connect to that Datasource.  If you can, then you have your ODBC connection setup correctly.  If not, then you need to look at your settings again (such as password, username, ports, etc).  If this works, let me know and I'll post the next coule of steps.
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
So I might have an easier time if I setup a CF server locally at my development center instead of trying to connect directly to my providors web server ?
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
My real goal here is to be able to work with datasources in dreamweaver which will make coding alot easier.  I like letting dreamweaver do the work :-)
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
I think you will have an easier time.  What you are actually doing is setting up your PC to connect to your provider and then you are setting up your CF Server to connect to your PC (CFServer --> PC --> Provider)


0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
I will try it tonight and we can go from there.
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
I'm in Texas, USA (CST time zone [GMT - 6]) but if I can, I'll monitor this thread tonight and hopefully be able to provide more timely responses.  
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
I am in Connecticut so the time is not much of a difference only an hour I believe.
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
The backplane in my server dided so I just got it back up and running today...
I have the developer edition of ColdFusion server installed, have you used it with Apache (I say this becuase my webserver where my site is hosted is a linux box becuase I personally think IIS is junk)
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
Sorry, no experience with Apache.  I use the CF built-in server for my development work without any hitches.
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
How do I use the CF built in server ?  After I installed it and then opened it for the first time it asked me if I want to use IIS or Apache... ?
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
I will use anything that works at this point I am getting desperate.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 1

Expert Comment

by:dl8453
Comment Utility
During the install routine, you should seen a prompt to use the built-in server (Coldfusion MX Server) or other web server.  If you have Apache/IIS installed, I believe those would have been listed.  If I recall correctly, if you have other web servers installed, the installation routine will default to one of those.  You may want to reinstall CF Developer's Edition and watch closely during the installation routine.

Here is the link to download the Coldfusion Server Developer's Edition:  http://www.adobe.com/cfusion/tdrc/index.cfm?product=coldfusion
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
I am going to uninstall IIS and Apache and then reinstall it from that link and see what happens.
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
Ok, I'll monitor this thread.  Be sure to reboot after the UNinstalls are completed AND/OR before you install CF.
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
Installing now using CF Web Server
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
Ok it is installed and now its time to configure it, now this is where I would create an ODBC connection to my external web server correct ?
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
No, first create the ODBC connection in your control panel (Administrative Tools/Data Sources (ODBC)).  I recommend using the System DSN tab instead of User DSN tab (System DSN will make the datasource available to any account on the pc whereas User DSN is only valid for the account you are currently logged in as).  Once you do that, then go into CF Admin and createa  datasource to the datasource setup in the control panel.  

Did you create an RDS password?  I set mine the same as my CF Admin password to keep things easy.
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
Yes I setup an RDS password and it is the same as the CF one.
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
NOTE:  If you are behind a company firewall, you might not be able to access your provider's database.  I can only access my provider's datasource from home, not work; the port is blocked on our company firewall.

Where you able to create the datasource in the Administrator\Data Sources for ODBC?
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
What if I am using MySql what do I use as an ODBC driver ?
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
Trial/Error  :)
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
You may want to check your provider's FAQ.
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
OK This might do me in....

In the FAQ it says this:  

Can I Connect to My Database Remotely?
Last Updated: February 16, 2007 9:19 PM
Print This Article

No, we do not allow external connections to our database servers.

I am screwed then huh ?
0
 
LVL 1

Accepted Solution

by:
dl8453 earned 500 total points
Comment Utility
That isn't good.  My datasource is MS SQL2000 but I can access my databases via Enterprise Manager and SQL Query Analyzer.  I simply enter the datasource name, username, password, and I'm off and running.  Would you be interested in chaning providers?
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
I am going to call them to question this, I dont really want to switch but if they do not give me a good answer as to why I might be forced to.
0
 
LVL 2

Author Comment

by:ostashenp
Comment Utility
Sorry this took so long but I have been struggling with this whole thing, im going to give you all of the points for all the the quick responses.  THANKS !!!
0
 
LVL 1

Expert Comment

by:dl8453
Comment Utility
Thanks.  I hope it works out for you.  Just in case you decide to switch, I'm using CrystalTech and I love it.  
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Boost your ability to deliver ambitious and competitive web apps by choosing the right JavaScript framework to best suit your project’s needs.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now