Solved

Dreamweaver connection to a ColdFusion Server

Posted on 2007-04-02
32
371 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 18
  • 14
32 Comments
 
LVL 1

Expert Comment

by:dl8453
ID: 18883584
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
ID: 18884953
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
ID: 18885069
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

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

Author Comment

by:ostashenp
ID: 18886987
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
ID: 18889156
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
ID: 18896943
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
ID: 18896961
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
ID: 18897329
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
ID: 18897358
I will try it tonight and we can go from there.
0
 
LVL 1

Expert Comment

by:dl8453
ID: 18897410
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
ID: 18897581
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
ID: 18923650
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
ID: 18923883
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
ID: 18931068
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
ID: 18931073
I will use anything that works at this point I am getting desperate.
0
 
LVL 1

Expert Comment

by:dl8453
ID: 18931307
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
ID: 18931515
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
ID: 18931526
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
ID: 18931867
Installing now using CF Web Server
0
 
LVL 2

Author Comment

by:ostashenp
ID: 18931936
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
ID: 18932066
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
ID: 18932086
Yes I setup an RDS password and it is the same as the CF one.
0
 
LVL 1

Expert Comment

by:dl8453
ID: 18932123
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
ID: 18932219
What if I am using MySql what do I use as an ODBC driver ?
0
 
LVL 1

Expert Comment

by:dl8453
ID: 18932241
Trial/Error  :)
0
 
LVL 1

Expert Comment

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

Author Comment

by:ostashenp
ID: 18932323
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
ID: 18932457
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
ID: 18932607
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
ID: 18988090
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
ID: 18988410
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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

There’s a good reason for why it’s called a homepage – it closely resembles that of a physical house and the only real difference is that it’s online. Your website’s homepage is where people come to visit you. It’s the family room of your website wh…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
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.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

739 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