How To

If you can’t connect to SQL Server on port 1433

Just had two fun days of troubleshooting this by working together with Adobe/Macromedia support, and found the solution.

Here’s the original issue: could not set up a new data source connecting locally (localhost, 127.0.0.1) to SQL Server 2000 Standard running on the web server; kept getting a SQL Exception error. Was told SQL just wasn’t listening on port 1433, or any TCP port for that matter, even though TCP/IP and Named Pipes were clearly enabled in the SQL Network Config Utility. Even in the registry, port 1433 was specified, yet I could not connect to SQL on TCP by any means. I couldn’t even telnet to the machine on that port.

Turns out that even though I’d upgraded SQL Server 2000 to SP4, I needed to downgrade to SP3. Still doesn’t make sense, after all, MS SPs are supposed to be roll-ups, but hey, that’s what worked. Luckily, the server I was working was running on VMware, so I reverted to a snapshot I took after I installed SQL and before I upgraded to SP4. Installed SP3, and was able to set up the data source immediately! Something to keep in mind if you’re in the same boat.

Standard
Places

The National Seminary at Forest Glen

Just posted photos taken this summer at the National Seminary at Forest Glen, a historic site located in the suburbs of DC.

The history of the place is a pretty interesting read. After being bought in the 1730’s as a much larger property, parts of it were sold off, and finally, what is now known as National Seminary was sold to John and Vesta Cassedy in 1894. They set out to transform it into a girls’ finishing school. In 1916, the school was sold to Dr. James E. Ament after Vesta Cassedy died. John Cassedy then married a recent graduate of the school and lost interest in running it. In 1937, during the Great Depression, with the school’s student population foundering, it was sold to Roy Tasco Davis, who set out to transform it into National Park College, a place where academics and practical skills. He didn’t have much time to do this, because the property caught the eye of an Army general, who invoked the War Powers Act, condemned the property, annexed it to Walter Reed Hospital, and used it as a place where wounded soldiers could recover.

When the Army tired of the property, they let it go to ruin. They wanted to completely tear down the buildings, but local residents objected and managed to get the site designated as a historical landmark in the 1970s. Finally, a deal was made in 2005 to get the entire site redeveloped, the old buildings restored or rebuilt, and luxury condominiums built there. From what I understand, a development company bought the property, under the solemn promise to stick to the historical character and look of the site as they rebuild there. The site is now under construction, and many of the old buildings, too dilapidated to stand up, will be torn down and reconstructed.

Ligia and I visited it this summer (2006) and last summer (2005), and photographed the various buildings. It was also a great place to eat raspberries and mulberries. I still need to post the photos taken last summer, but I’ll do it soon.

(Added 10/19/06: here they are!)

Standard
Places

A trip to the C&O Canal Park

Back at the start of September, Ligia and I visited the C&O Canal Park, on the Maryland side. It was a rainy day, so we didn’t stay for long, but I did manage to take quite a few photos. I thought I’d share them with you. Enjoy!

Here’s Part 2.

Standard
Thoughts

Do you like macro photos?

If you do, I’ve got tons of them. Here are just a few I’ve taken recently. These are everyday objects, like clocks, handles, knobs, appliance logos, fruits, etc. Hope you enjoy them. If you’d like to use any of them for a project you’re working on, please let me know.

Standard
Lists

Two wonderful short movies

I recently found out about two videos, both found on YouTube. The first, called I Can Only Imagine – Mercy Me, is a wonderfully inspirational video showing the amazing willpower of two people, a father-son team, who compete in triathlons. The catch is that the son is completely disabled, and the father carries him all the way through each leg of the competitions.

The second is called Fast Film, and is a stop-motion animation mash-up made with paper cutouts and live action from past movies. Must see both!

Standard