Dreamweaver connection to a ColdFusion Server

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.
LVL 2
ostashenpAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dl8453Commented:
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
ostashenpAuthor Commented:
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
dl8453Commented:
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

ostashenpAuthor Commented:
well APServers blocks RDS that is why I could not connect in the first place....
0
ostashenpAuthor Commented:
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
dl8453Commented:
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
ostashenpAuthor Commented:
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
ostashenpAuthor Commented:
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
dl8453Commented:
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
ostashenpAuthor Commented:
I will try it tonight and we can go from there.
0
dl8453Commented:
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
ostashenpAuthor Commented:
I am in Connecticut so the time is not much of a difference only an hour I believe.
0
ostashenpAuthor Commented:
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
dl8453Commented:
Sorry, no experience with Apache.  I use the CF built-in server for my development work without any hitches.
0
ostashenpAuthor Commented:
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
ostashenpAuthor Commented:
I will use anything that works at this point I am getting desperate.
0
dl8453Commented:
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
ostashenpAuthor Commented:
I am going to uninstall IIS and Apache and then reinstall it from that link and see what happens.
0
dl8453Commented:
Ok, I'll monitor this thread.  Be sure to reboot after the UNinstalls are completed AND/OR before you install CF.
0
ostashenpAuthor Commented:
Installing now using CF Web Server
0
ostashenpAuthor Commented:
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
dl8453Commented:
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
ostashenpAuthor Commented:
Yes I setup an RDS password and it is the same as the CF one.
0
dl8453Commented:
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
ostashenpAuthor Commented:
What if I am using MySql what do I use as an ODBC driver ?
0
dl8453Commented:
Trial/Error  :)
0
dl8453Commented:
You may want to check your provider's FAQ.
0
ostashenpAuthor Commented:
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
dl8453Commented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ostashenpAuthor Commented:
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
ostashenpAuthor Commented:
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
dl8453Commented:
Thanks.  I hope it works out for you.  Just in case you decide to switch, I'm using CrystalTech and I love it.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.