Lost Data Source using Coldfusion 9 and DW CS4

[RAShimko]

I've been developing a site using Dreamweaver CS4 and ColdFusion 9 for several weeks now.  I had to step away to deal with other issues for a couple of weeks and upon my return I seem to have lost the Data Source I had created for access to the database.  It's weird, I can run any and all queries, updates and deletes that I want against this allegedly lacking data source, but if I wish to create a new recordset, it informs me that I must create a data source before proceeding.  Any insight into a resolution to this situation would be greatly appreciated.  Thanks.

[Lawrence_Cramer]

When you say... "I can run any and all queries, updates"   do you mean, when you test locally in the browser?

Is it that Dreamweaver isn't seeing the data source, but CF is.  Have you created your RDS connection?

Are you using a "data source name variable" in the bindings panel?  - Sometimes DW hoses up these and deleting and recreating it gets things going a gain.

Hope this helps... if not, please give some more details on what's happening and I'll be glad to help.

--
Lawrence Carmer - *Adobe Community Professional*
http://www.cartweaver.com/

http://www.Cartweaver.com
Complete Shopping Cart Application for
Dreamweaver, available in PHP and ColdFusion

Stay updated - http://blog.cartweaver.com

[RAShimko]

>When you say... "I can run any and all queries, updates"   do you mean,

>when you test locally in the browser?

I am doing development and testing on the same machine.  I leave DW and am able to browse locally and query, delete, update data source.  When I try to create a new, let's say, recordset or authenticate user, through server behaviors, I am informed of apparently lost datasource.

>Is it that Dreamweaver isn't seeing the data source, but CF is.  Have

>you created your RDS connection?

CF has data source correctly configured and yes, DW is not seeing it.  I haven't/didn't setup an RDS connection (at least I don't think so...) due to the fact that I was testing and developing on same box.  Perhaps I've missed something.  All I can guarantee is that it was working fine until just recently.

>Are you using a "data source name variable" in the bindings panel?  -

No.  Thank you for you assistance.

[RAShimko]

I was finally able to get the RDS connection configured properly.