Terrence Ryan has done it again and updated his Squidhead tool with a better interface and design. The new version includes support for mySQL (not a big deal to me but important to a lot of people.) If you come from a database background or just like to begin your project at the data design level you should check it out.
You can check out Terrence’s blog here and download Squidhead 2.0 from reaforge.
Filed under ColdFusion
Ok.. I was getting the following error in my event viewer/application log when I would try to start SQL server. I would try to start it and it would immediately fail.
“TDSSNIClient initialization failed with error 0×5, status code 0×51.”
The solution turned out to be rather simple; Open up SQL Configuration manager, and switch the account that the SQL server was running under to the Local System account.
Not necessarily secure, and wouldn’t do it for production but since I do development, it doesn’t matter too much. I’m not sure what caused this problem I recently went through the hell of installing Adobe CS3 but I’ve also had a number of packages get pushed down from the corporate SMS system as well.
Oh, I was also getting the following error in the application log.
UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.
The trick for this one is just to go change the permissions in the registry so the MicrosoftSQL keys can be updated.
Filed under SQL
After my install of FlexBuilder3 (after my install of CS3) I was having a problem connecting to my local RDS server. What made this particular problem really odd is that I was not having this problem in FlexBuilder2. (With FB2 I could connect to my RDS server just fine) The other thing that made this odd, was that I knew for a fact that I was able to use FB3 to connect to my local RDS server.
The only difference in configuration between FB2 and FB3 that I could remember making was that in FB3 I used the “”Software Updates”" feature when I was at work so I had to enable the HTTP proxy connection for Install/Updates. I tried to disable this feature (Preferences – Install/Update – Proxy Settings) but still no luck. … after messing around with it for a little longer I figured out that this was the correct solution but FlexBuilder needed to be restarted. Apparently the RDS Configuration in FlexBuilder uses the same proxy settings as the Install/Updates HOWEVER in order for that change to take effect, you have to close and reopen FlexBuilder.
Filed under AIR (Adobe Integrated Runtime), Flex
OK I won’t make yet another post on how horrible the install for CS3 has been. Let’s just say that I opened the box from UPS Wednesday around 5:00 PM and only a short 34 hours later I actually got it installed. In the end I took the shotgun approach and tried every solution I could find at the same time and it worked… so here is my recipe for a CS3 installation….USE AT YOUR OWN RISK
You will need for this recipe, the following ingredients:
(I should mention that this is for a Windows XP machine)
* Your CS3 Installation media and serial number
* Administrative rights on your machine. (Member of the Admin group)
* Windows Installer CleanUp Utility
* Adobe Flash Player Uninstaller
* Adobe CS3 Pre-release Cleaner
* Adobe Acrobat registry ACL repair utility
0. Copy and Merge the Install Files
Make a directory on your hard disk (i.e. C:\Software\ )
copy the “Adobe CS3″ directory from all of your install disks into this directory letting each copy overwrite any duplicate directories. You want to end up with one directory (C:\Software\Adobe CS3\) that contains the contents of all of the Adobe CS3 directories from each of the source disks.
1. Uninstall *ALL* Adobe and Macromedia products.
This includes FlexBuilder 2 and 3 Beta and in my case ColdFusion 8 Beta, also the AIR Beta runtime.
(note I did not uninstall ColdFusion 7)
2. Uninstall *ALL* Adobe and Macromedia products.
No not a typo… just go check and do it again if need be.
and if you didn’t do it the first time I said it, do it now.
3. Delete the applications\Adobe directory
Remove the C:\applications\Adobe directory. Yep just delete it.
4. Reboot make sure that there are no active installs/uninstalls
How do you do this… try installing an a program that uses a .MSI installation file. My suggestion would be the
Windows Installer CleanUp Utility
because you will need this later in the process anyway.
5. Run the CS3 removal utility
Run the
Adobe CS3 Pre-release Cleaner
but use the hidden level 4 clean. It doesn’t show on the menu. It’s sort of like the Spinal Tap level 11. (Actually I wish they had included a level 11!)
6. Run the CS3 removal utility AGAIN!
Yes again, in level 4 keep running it until it doesn’t actually do anything at the end.
7. Make sure flash player is really gone
Run the Adobe Flash Player Uninstaller
8. What the hell, run it again for good measure
9. Fix the registry permissions
Run the Adobe Acrobat registry ACL repair utility
10. Yep you guessed it… do it again
MISSING STEP
OK Looking back over this post and my notes I realized that I missed a couple of things between steps 10 and 11
10b: run Windows Installer CleanUp Utility (You probably installed it in step 4 above. ) It will be in your programs menu. Run it and remove any remnants of left over installs for Adobe and Macromedia products that you have removed. Oddly enough sometimes the un-install/modify install is left behind in the Add/Remove programs list after an uninstall.
10c: Manually fix registry permissions… I don’t know if it actually had an effect on ANYTHING. Basically what you want to do is open regedit, right click on HKEY_LOCAL_MACHINE, select permissions, select Administrators at the top and check the Full Control – Allow box at the bottom, then click Apply, then Advanced then check the “Replace permission…” box at the bottom, the click Apply. It will take a minute or two but regedit will try to replace permissions on all subkeys of the HKLM, you will get an error message that permissions for some keys could not be updated. Unfortunately there is no way to tell which key.
You can stop here, but if you want you can do what I did which was do the same thing for all the other top level keys. In particular I would do the HKEY_CLASSES_ROOT, HKEY_CURRENT_USER and HKEY_CURRENT_CONFIG. I believe I also spent some time poking around in the sub keys looking for anything that I thought the install might be trying to modify and doing this same process to keys. Unfortunately there is no way that I have found to update registry permissions en mass.
Now go make sure that your user id you are using to install is a member of the local administrators group in windows.
11. Clean the registry
Run RegClean
12. Clean the registry AGAIN repeat as needed
Keep cleaning the registry, until the reg undo file that it generates does not change. (i.e. open up the last two files in notepad, if they are different run it again)
13. Stop everything else running.
Go to Start->Run and type “msconfig” and hit enter.
On the “General” tab of the System Configuration Utility select “Selective Startup” and uncheck all 4 boxes under it.
Go to the “Services” tab, click Enable All, then check the “Hide All Microsoft Services” check box, then click “Disable All”, now click “OK” and let the system reboot.
14. Install
Go to the directory you setup in step 0. and run the Setup.exe. If you encountered any problems when copying the files from the DVDs, determine which program those files belong to and skip the installation of that program. (I had to skip AfterEffects for the time being.) Also if you are so inclined you might skip installation of Acrobat Pro, this seems to be the one program that is causing the most problems with installation.
If this ends up working for you… Please come back and comment.
I went to the Adobe onAIR Bus tour on Tuesday. This was the first scheduled stop with many more to follow. The complete schedule can be found at the official website
http://onair.adobe.com/
The event was held at Elysian Brewing Company down near Quest field. As far as events go, Adobe put on a good show. Free shirts, free books and CD with the AIR beta and lots of documentation. Breakfast and lunch were provided and as I understand it free beer after dinner later in the evening. I was unable to stay but was both impressed and disappointed with what I saw and heard from Adobe.
First off let me say that I am very excited about working with the Adobe Integrated Runtime. The possibility to develop full system applications using Action Script 3 (my preference) is very exciting.
My main disappointment from what I have heard is the amount of “unknown” at this point. There are a significant number of APIs that are not yet complete and several key questions regarding the security model between local running AIR application and a remote loaded content. Naturally most of this is to be expected as we are in Beta. My disappointment perhaps just shows my enthusiasm for working with AIR.
Filed under Adobe, AIR (Adobe Integrated Runtime), Flex
This is just an expansion of a previous post. The following function can be used to fix the “class is not an IEventDispatcher” problem that occurs whenever you try to bind to the items in a non-declare-class based array collection (Such as an array collection that is the result object from a remote ColdFusion query.)
If you are using the Cairngorm framework then you can add this method to your ModelLocator and have it available anywhere you need.
/* ****** applyObjectProxy ***** by: Justin Ohms
Arguments: ArrayCollection
Returns: ArrayCollection
=========================================
Adds the IEventDispatcher interface/ ObjectProxy
to the elements of the provided ArrayCollection
making those elements bindable. Usefull for
turning non bindable arraycollections
(CF Query result objects) into collections
of bindable objects.
************************************** */
public function applyObjectProxy(targetAC:ArrayCollection):ArrayCollection
{
for(var i:String in targetAC)
{targetAC[i] = new ObjectProxy(targetAC[i]);}
return targetAC;
}
/* ************************************* */
Filed under Adobe, ColdFusion, Flex
If you are experiencing the problem in FlexBuilder when using CFEclipse that typing “” causes FlexBuilder to hang for an extended period of time, this is a problem with CFEclipse and is corrected in the 1.3.1 version of CFEclipse.
For more information, that problem is detailed in the following ticket
http://trac.cfeclipse.org/cfeclipse/ticket/172
If you are experienceing a problem where by when typing a variable reference inside of a CFQuery tag such that when typing the following code FlexBuilder would hang after typing “”struct.”"
select ….
from ….
where field = #struct.var#
This problem is as of yet unresolved in CFEclipse. A work around is to increase your insight delay for the CFEclipse editor to some really high number.
Filed under ColdFusion, Flex
I am mostly quite enamored with Flex builder. Having it built on Eclipse was a brilliant move by Adobe. I also use CF-Eclipse for most of my CF development work. (I haven’t even installed Dreamweaver on my new laptop yet.)
With all that being said, there are a few things that I wish for in future versions….
1. Backspace support in intelisense. I have very fast fingers… too fast sometimes but I use the intelisense feature quite extensively in FlexBuilder. Mostly I use it to keep from fat fingering property and variable names. Being fast fingered means that I often type ahead of the intelisense and if you type past the point of matching characters in the intelisense, the drop-down list disappears. It would be nice if perhaps it would alert you, select the closest match, leave the box open but yet you continue typeing. The fact that the box disappears is rather frustrating especially when you consider the fact that in most cases if you do provide a property or method that is not in the list, it is also not valid so Flex builder is going to throw an error anyway. I find it frustrating to have to backspace and delete the last “”.”" in order to get the intelisense list back.
2. My wish for CF-Eclipse is … well funny thing, a better intelisense. It would be very handy if the editor could provide a list of my methods and properties inside of a CFC whenever I dot notate an instantiated instance in CFScript. This information is available in the services browser so perhaps there is a way to integrate this into the editor.
Filed under Adobe, ColdFusion, Flex
Here is an awesome little tool that I came across while trying to figure out some network routing issues recently.
http://jodies.de/ipcalc
Filed under Internet, Networking
“I have tons and tons of old email PST files laying around that I really cannot access easily. I’ve started using G-Mail for all of my email and have wished for a way to put all these old email into G-Mail so they could be searched.
As with everything… a quick search in Google came up with at least one possible solution.
http://www.marklyon.org/gmail/
Mark Lyon has come up with GML (GMail Loader) this little utility will process MBox files (Netscape email archives) and send each email in the archive to Google as if it was sent from the original recipient. Using GML and the ReadPST utility you can also find on his site I have been able to upload several hundred old emails into GMail. I have thousands of old emails in at least 4 or 5 archives to upload so that will probably be a project for some weekend.”
Filed under Internet, Technology
