EasyCFM.COM - The ColdFusion Community! About Us!

Senior Member
Posts: 373
Joined: Jan 2006

One last thing...

I clicked the + sign in the DB panel, it gave me options to several different DB types. I chose Access which led me to another window. I entered the information for the connection and clicked OK, but nothing happened. No error message, no success message, no type of reaction to the click of the OK button or the test button for that matter.

That's what's really confusing me and frustrating me.

OK, I got it off my chest.

Thanks

falconseye

01-27-2006 @ 2:32 PM

Senior Member
Posts: 1033
Joined: Mar 2004

if i understand correctly, everything resides on your local machine. did you create a Data Source in CF admin? and point it to your Access DB?

if so, can you simply create a template and
<cfquery name="test" datasource="myDsn">
select ...
from ...
</cfquery>
<cfdump var="#test#">

just to make sure that you can connect to the access dB?

megan

01-27-2006 @ 2:33 PM

Moderator
Posts: 2398
Joined: Jan 2003

you have to log into rds from dreamweaver to get the database datasources to show. If you have RDS set up in coldfusion itself, then open dreamweaver and open a site and open a cfm page. click on the databases tab. if no database datasources show hit the refresh or the plus - Dream Weaver should ask you for an RDS login, log into RDS and your datasources should show.

hth, megan

We have art so that we shall not die of reality ~ Nietzsche

megan

01-27-2006 @ 2:47 PM

Moderator
Posts: 2398
Joined: Jan 2003

You might have already seen these, but just in case, have you watched the 6 multimedia tutorials on Building Your First Database Application with ColdFusion

if not, go to http://www.macromedia.com/devnet/coldfusion/articles/rd_cf.html and scroll down to the tutorial list on the bottom half of the page.

hth, megan

We have art so that we shall not die of reality ~ Nietzsche

daddyFL

01-27-2006 @ 2:49 PM

Senior Member
Posts: 373
Joined: Jan 2006

That's the thing, dw doesn't show the datasources I have set in CF. If you look at one of my previous comments about the message regarding RDS you will see what I am talking about.

Do I have to set up RDS in DW even though I do not plan on connecting to a remote server?

Thanks

megan

01-27-2006 @ 2:57 PM

Moderator
Posts: 2398
Joined: Jan 2003

right! exactly - dreamweaver will not show any of your datasources until you log into rds from dreamweaver. once you log into rds from dreamweaver, your datasources will be retrieved and displayed in the database panel. sorry if I did not say that clearly enough. hth, megan

We have art so that we shall not die of reality ~ Nietzsche

megan

01-27-2006 @ 2:59 PM

Moderator
Posts: 2398
Joined: Jan 2003

oh - and you do not have to be hooked up to a remote server for rds - sorry I missed answering that. hth , megan

We have art so that we shall not die of reality ~ Nietzsche

daddyFL

01-27-2006 @ 3:03 PM

Senior Member
Posts: 373
Joined: Jan 2006

Maybe I configured CF wrong when I installed it originally. The only thing in CFAdmin that I see regarding RDS is the password updating and changing. I changed the password to see if this could be the problem, it wasn't. When I watched the first couple of tutorials, I noticed that in the app panel, the option 4 was selected in the video. On my machine, it is not checked off.

I feel really retarded right about now.

Thanks

daddyFL

01-27-2006 @ 3:06 PM

Senior Member
Posts: 373
Joined: Jan 2006

how do i setup rds?

Thanks

megan

01-27-2006 @ 3:08 PM