I used 2 grip flanges between the sprocket and the BB. Just needed to add 2 thin crank spacers to leave enough room for both flanges, then when the cranks are tightened, the flanges are compressed too and create friction.
After some use, the flange next to the sprocket sticks to it, and the flange next to the BB sticks to the frame (mid bb), so only the surface between the flanges are moving and creating the kinetic friction.
It has worked for me for about 4 years with the same flanges.