RI,
I have some advice that you may find surprising, and that may seem to contradict much of what you read on the forum or elsewhere in the 'sphere. Nevertheless, I think it's what is best for you.
Forget about "game"; forget about weekend bar approaches; forget about trying to change your behavior with women in any particular way.
You need to deeply relax in your life. You have no success with women and no natural way with them. But you don't strike me as a particularly unhappy guy. You said pointedly in a different thread that you are not "depressed", and I believe you. You have a lively mind and many different interests that you can enjoy.
You need to let go of the idea that success with women -- as you define it -- is the only or main source of interest and satisfaction. In truth, there are many men who have success with women as you would see it -- meaning, they are able to get them into bed one way or another -- who derive relatively little satisfaction from that part of their lives, whether physical or emotional, beyond the merest satisfaction of checking off a mark that they feel is required to be complete as a man.
I feel that many of your "approaches" have that slightly formal quality -- it's as if you're trying to "succeed" with a woman just so you can satisfy some formal requirement which really only exists in your mind. I could be wrong, but I don't believe that you are especially starved for female affection, nor overcome with lust and desire. Even a 4 or a 5 at a bar does not want to merely be the provider of someone's abstract validation or the fulfiller of a tic of sorts. Women smell that off of you, they know that you neither especially desire them nor especially need them, whether you yourself know it or not.
You should let go of this and just relax into your life. Like I said, I think you're doing fine, maybe better than you know. You can enjoy your work, your reading, your lifts, and so many other things; you can still enjoy them even if you weekend approaches are for naught -- indeed, even if they never happen at all. You should also realize that while you are no longer very young, there is no particular rush, and a man's mature prime goes on for a very long time, some decades. There is no pressure of any kind.
If you want to do something that, over time, will give you a better chance of meeting a woman that you can have some relationship with, do this:
to the extent that you want to and feel like it, become more social; develop -- again, slowly and organically -- a social circle that allows you to meet people that are close to you in interests, personality, and disposition. This could be in your work, some hobby, some organization that you feel drawn to, or whatever.
Don't do this particularly to meet a woman -- do this because it would be an enjoyable addition to your life and a way to extend and enlarge it. But over time, and if you do this in a relaxed and unpressured way, this may well result in your meeting a woman who sees you as you are when you are not subject to the pressure to "approach"; and it is not impossible that this may lead to something. But again, don't do it for that reason, realize that it is not the only or even primary desirable outcome of any such social activity.
Other than that, just completely let go of the pressure to master "game", to score some "notches", to break a long "dry spell", etc. Realize that your life is pretty good as it is, and that you're
wasting time by making yourself feel a dissatisfaction that is not really necessary. Why waste another day when you can just enjoy it instead?
Again, this is not what most other guys here would tell you. But these things have to be treated on a case by case basis, and from reading your posts and taking a general temperature, it's what I feel to be best in your case. Try it and see where you are in a year -- if indeed, you still have time to post here between all the other things you're doing with that girlfriend you met at that social activity.