« The Dopefly Tech Blog Main page
The title says it. Thanks to that wonderful human being Steven Benjamin, I've got a much newer CF to play with. We're a couple versions back at work, still, so it's really nice for me to get actually new technology one in a while. Thank you Steven!
Update: New hosting company, making this the third one in a week (1-old host, 2-host that was lame, 3-new, working host).
If you're reading this, you're looking at dopefly.com at it's new host, just 15 feet from my desk!
Thanks to Alan for the server, the AZCFUG for the software, Interactive Sites (my new employer) for the bandwidth and John & Pat for helping me set this up and getting the site moved over. You guys are all awesome.
It's sad though, I was almost enjoying having a web site blink on and off like a strobe light. Yeah, the stobe site. That's dopefly. Well, no longer, as long as we can avoid another one of those catastrophic drive failures this box had a few months back.
In related news, my 2.0 version of this blog is coming along. I had this idea to make an OO singleton-styled pattern, though it was mostly for the sake of coping with a database that was down 80% of the time. Still, I'll push ahead because it's a fun experiment.
Just read on Steven Erat's Blog that the CFMX 6.1 Updater just came out. You've got to search for it, but you can find it on the Updater page.
I know it's been tested and verified and everything, but i'm still waiting a week or two with my ears open before applying it to my production servers.
I recently switched web site hosts, following David Medlock's suggestion of going with his provider. I thought it would be great and fun --and darn cheap! Well it's great to have a ColdFusion server for my site, but working with these people is difficult.
It took a whole month to get my SQL database hooked up. Here's a shortened transcript of my little sql battle:
me: Please hook up my SQL Database in ColdFusion.
them: Ok, please give us the details.
me: Ok, here's the server, password, etc.
them: Ok, it works, please test it.
me: Doesn't work. I'm seeing the error: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined. Why are using SequeLink instead of the SQL Server driver?
them: Please double-check your code.
me: Here is my code and a link to the page where you can see it for yourself
them: Ok, forwarded to admin.
me: I can see the database, but can't add tables. Please use my dba acct instead of the limited account.
them: Ok, forwarded to admin.
me: It's been 4 days, now it says "data source not found"
them: Ok, forwarded to admin.
me: It's been 11 days. What's happening?
them: Ok, let's start over. What is your database info again?
me: Here's how to add it. Go to cf administrator, click on data sources ... ...
them: Your username is lowercase now? Before it was mixed case.
me: Case doesn't matter in SQL server usernames. I can connect to my database on your server from here. What is wrong with you?
them: Ok, forwarded to admin.
them: Ok, it works, please test it.
me: It's not working. Please refer to the test page i sent you earlier.
them: Ok, it works, please test it.
me: It's still not working. It isn't done until my test page works. I think you have it pointing to the wrong server.
them (admin): Ok, please wait.
them: (2 days later) (issue closed)
me: Do not close this issue. It should have been fixed weeks ago.
them (admin): Ok, looks like you deleted your ODBC connection. I re-made it and everything is perfect.
me: It still doesn't work. Now there is a database connected, but it isn't mine. Please view the test page again. Can I log into your CF Administrator and fix it myself?
me: Nevermind, I noticed the CF Admin was not password protected. Thanks! I have added my database using the regular SQL Server driver. Your admin may copy my settings for future databases, but DO NOT change anything