I think the shaft is too thin to drill a hole through, and I dont have access to any kind of welding equipment.

Hmmm. Perhaps I could glue the sprocket to the wheel hub.