Today I was trying to pull some IP Addresses through a Linked Server connection on SQL Server 2008 from a MYSQL server. The IP Addresses were stored as integers using MYSQL’s INET_ATON() function. The problem was when I ran the query through openquery I started getting gibberish back:
SELECT * FROM OPENQUERY(MYSQL, ‘SELECT d_ip,INET_NTOA(d_ip) FROM IP_ADDRS [...]
Archive for the ‘Tip’ Category
OPENQUERY with INET_NTOA (or reason # 5,643,532 varchar(16) is better)
July 20th, 2010
No Comments
Yellowstone National Park
August 22nd, 2009
No Comments
It’s been two weeks since we got back from Yellowstone and I am now only finally getting around to putting up a post about it. I do have good reason though since I was out of town the weekend we came back and then started a new job last week. Anyways, Yellowstone was awesome. If [...]
Wordpress 2.8 Upgrade problems
June 12th, 2009
3 Comments
Just a quick note. Today I upgraded this site to WordPress 2.8 . As usual I used the WordPress Automatic Upgrade Plugin, but after the upgrade was finished I started getting weird gzinflate / guncompress errors.
The site worked fine but I would see the errors when I tried to upgrade a plugin. Searching the [...]
The Big Hawaiian Post
April 28th, 2009
2 Comments
OK, I have been terribly remiss in getting back to posting after vacation. I know. Here’s my excuse. We flew back Saturday night on an 11pm flight out of Kona. Somehow, I managed to stay awake all night over the Pacific Ocean and only dozed a little on the flight from Phoenix. When we [...]
Power Twitter Tricks
February 23rd, 2009
No Comments
One of the reasons I love Twitter so much is that it is so extensible. You can use it to accomplish a ton of tasks with almost no work on your part. Recently, several friends had of mine had joined Twitter and asked about how I do some things. I thought it might be beneficial [...]
Transparent PNGs with IE
September 2nd, 2008
No Comments
Yesterday I finally got around to doing some cleanup on the site. I forget sometimes how easy CMSs like Wordpress actually make publishing and writing on the web. That is until I actually have to go into my website and edit some of the old HTML pages by hand in vi. That is what I [...]
Better Marriage Planning Through Technology
July 29th, 2008
No Comments
I’m getting married on August 16th. And while I’m running around like a crazy person, I’ve found some tools that make things a lot easier for us to keep somewhat organized. I’m not talking about marriage websites like theknot.com or similar.
What has been saving my skin time and time again is Remember the Milk and [...]
Some Cool Things I Learned at PodcampOhio
July 1st, 2008
No Comments
This weekend, I went ot PodcampOhio. It was just a really awesome new media conference here in Columbus. I learned a whole bunch and met some cool people. I thought I would share some of the things I picked up for everyone who couldn’t attend.
Blackbird – A lightweight Twitter client for the Blackberry. No need [...]
Remember The (Milk) Books
May 21st, 2008
No Comments
For a while now I’ve been using Remeber The Milk and while it is useful, the reason I’ve really come to love it is for how it lets me keep track of books. I read a lot and, like most of you, I am always finding or hearing about books I would like to read. [...]
TaxAct and the Stimulus Check
May 19th, 2008
No Comments
So May 16th has come and gone and no Economic Stimulus Check has shown up in my bank account. I was getting pretty worried that there was some sort of snafu, but then I ran across this piece of information.
Apparently, if you used TaxAct software to file your taxes (like I did) and chose direct [...]
