RxNorm Queries

by Marvin 24. March 2010 15:10

Over the past two years, I've been getting quite familiar with a drug NLM nomenclature called RxNorm.  If you aren't familiar with it, you can read about it here.  Here, I am just going to share some of the sample MySql queries I've written to illustrate the different tables in RxNorm and what you can do with them.  More...

Currently rated 2.8 by 6 people

  • Currently 2.833333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

Error 1001: Source 'ServiceName' already exists on local computer

by Marvin 19. March 2010 03:59

When trying to install a service I am developing locally on my laptop, I was getting an error "Error 1001: Source 'ServiceName' already exists on local computer" and the install was unsuccessful.  After about an hour of binging and googling, I figured out the solution.  More...

Currently rated 4.8 by 12 people

  • Currently 4.833333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

There Is No Source Code Available For the Current Location

by Marvin 17. March 2010 07:34

For the most part, I love Visual Studio and programming using .NET, but this error makes me nuts.  I've run into it a couple of times recently when trying to debug.  I've learned a work-around today, so I'm documenting it here for my own future reference. More...

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Enabling File Permissions For Your ASP.NET App on Windows Server 2003

by Marvin 15. March 2010 03:18

I'm ashamed it took me 3 days to figure this out.  I have a web app that performs a file operation using System.IO.FileStream.  It worked fine on my local dev box, but as soon as I pushed it to my GoDaddy server, I got a System.UnauthorizedAccessException error "Access to the path xxx is denied."  Here's how I fixed it. More...

Currently rated 3.0 by 1 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,

Getting System.Byte[] In Your MySql Query Results Through Connector v5.2.5

by Marvin 30. March 2009 07:39

This is a little thing, but I ran into it again today, forgot how I fixed it before, and had to figure it out again.  To save myself the grief (and maybe someone else), I am posting the solution here.  I had a query that worked fine when I ran it from MySql Administrator, but when I ran it in my ASP.NET application using the .NET Connector v5.2.5, I was getting System.Byte[] values.  More...

Currently rated 5.0 by 4 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Keeping DataSets To Yourself When Returning Data in your Web Service

by Marvin 5. March 2009 14:19

When I first starting developing web services, I just loved to use DataSets to return data from the service.  I mean, they are pretty easy to use, and I am all about the easy road.  Then I stumbled across Scott Hanselman's blog article where I learned that "returning DataSets from web services is the spawn of Satan and represents all that is truly evil in the world."  Oops.  While I found this and other articles which explained the problems with using DataSets as a container for returning data from a web service, I didn't really find that "for Dummies" walkthrough that I was looking for.  At least, not a walkthrough that met my particular needs and that my feeble brain could understand.  This article is intended to be that walkthrough I wish I could have found. More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

Create a Loading Indicator for AJAX Partial-Page Updates in ASP.NET

by Marvin 28. February 2009 04:02

I think one of the coolest things about ASP.NET v3.5 is that they've made it really easy to add AJAX functionality to your web pages.  I mean, hey, if I can pick it up and do it, it can't be too complex, right?  Sometimes, though, your partial-page updates take awhile because of network latency or a lot of processing on the server.  You need a way to let the user know to just be patient and wait a minute before getting overly-excited and clicking that "Submit" button again, and again, and again.  Here's how I do it.  More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

Web Development

Marvin is Going to Jail

by Marvin 9. February 2009 12:40

Sad, but true.  I am going to do time.  I have pleaded my case, but it was no use.  Authorities are coming to arrest me on March 24th.  During my incarceration, I will be separated from my family, and I will have no access to a computer.  Worst of all, I discovered that someone I know has turned me in.  I am not quite sure who it was yet.  They are under witness protection, but I am definitely going to find out.   

It's all for a good cause.  My work is particpating in the Muscular Dystrophy Association's 2009 Lock Up, so I am getting thrown in the slammer and trying to raise money for MDA as my bail bond.  If you have a soft spot for the work that MDA is doing and want to contribute, any contributions (even small ones) will be greatly appreciated.  It's pretty easy.  You can donate online at the following web-site:

https://www.joinmda.org/MyLockup/MyHomepage/tabid/50090/Participant/marvinpalmer/Default.aspx

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

GoDaddy and your MySql Database

by Marvin 6. February 2009 19:39

I have been a customer of GoDaddy's for awhile now, and at this point, I have gotten pretty comfortable with their tools to manage my websites and databases.  I forget sometimes that it was VERY painful for me in the beginning.  I suppose I repressed the memory of how frustrated I was when I got my first ASP.NET website built and everything worked great locally only to fail miserably when uploaded to GoDaddy.  Things like how to get my site published, get my database up and running, connect my published pages to my remote database, etc - these were all tricky for me to figure out the first time.  So, I am going to put together some articles on the basic stuff that you have to know to be able to get your data-driven ASP.NET website up and running using MySQL on GoDaddy.  This article will cover setting up a MySql database on GoDaddy. It will be the first in a series that I will put in the category "GoDaddy Basics". More...

Currently rated 2.7 by 3 people

  • Currently 2.666667/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,

GoDaddy Basics | Web Development

Falling in Love With Objects

by Marvin 30. January 2009 17:39

I am about to show just how much of an amateur I am.  The lightbulb has finally come on in my head regarding the value of object-oriented programming.  It has taken awhile for it to sink in, and I most certainly don't have it all figured out yet, but I thought I would share some of the epiphanies I've had about it and how it's making my life as a programmer much easier.  More...

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

Web Development

About the author

I am a junior-level C# .NET developer living in Nashville, TN.  I'm currently working in biomedical informatics, developing a web service, a MySql database, and a web application.  Every week or so, I spend hours trying to figure out how to do something, and after I find the solution, I really want to make sure I don't go through that exercise again.  I love to write.  It helps me to remember things.  So, I use this blog as a way to document those painful lessons as I learn them.  It has already helped me to be able to refer back to them.  I hope some of these will save someone else some time as well.