Don't all jump in at once here, I didn't know it was that difficult a question or that I was the only one operating under this type of environment! Oh well. Doesn't look like I'll be using CFB anyway. Back to DreamWeaver I go.
DCWebGuy, I think no one responded because you offered a lot of variables. I suppose no one wanted to try to help deal with all of those. And as I just noted in the message just sent, you do indeed need to get some of these problems sorted to benefit from the code assist (and SQL assist) features, so until you do resolve them, I'll understand why you're not impressed with CFB.
And since you now (and in the last note) seem to be saying "so long", there may be even less interest among readers to try to help out.
I will note that if you can't get the RDS stuff to work, then I'm pretty sure the SQL assist won't work. I don't know why CFB tripped over compression when DW did not. You're sure they are both pointing at the exact same version of CF, right? I'm not aware of the issue, but here's another thought: couldn't you create a new site, just to use for RDS, and turn off compression for that?
But again, I realize you may not be interested in futzing with things any more. (BTW, if you didn't say so in response to my last note, I'd appreciate knowing your first name. Just curious if we know each other, since I used to live in DC, too. Always nicer to have someone in mind when writing.)
I'm not saying so long to CF or the community, just saying I will stick with DW even though I'd really, REALLY like to switch over to CFB. Done futzing, yes. Yes, we know each other, I sent you a private email. These forums use my old username from waaay back.
For what it's worth, I've tried to address this envinroment variables thing to the CF community in the past and never got any help so that's why it appears I am expressing some frustration, it's dejavu, that's all. Love CF though, it's given me quite a life over these past 14 years (I've been on it since v3). I hope CF lives forever.
I would try to help because I am operating in a similiar invironment. But if running IIS with compression enabled is the problem I would be no help. I wouldn't compress anything. ;o) If the problem is getting CFB2 configured, I may be some help.
"should I use local, remote, RDS, FTP? " Well my short answer is yes. I use them all depending??
I have a local MS SQL database, IIS and Coldfusion. When I am playing with ideas I work all local. When I am working on a real project I connect to the remote development server RDS and setup the remote databases in the local CF admin and the remote CF admins. I work with a local developers copy of CF 9 with the remote databases and CF. Get everything working then move the files to the servers generally as mapped drives.
LMK if you still want to give it a try or have decided to bypass for now.