Mimic SQL Server
I am trying to add a middle ware tier between my applications and database (which is SQL Server) and I don't want to change code in clients. I just wanted to listen on the same port as SQL Server listens and process all the queries coming in and send proper response back to cli开发者_开发技巧ent.
I created a socket and listened on it, but it didn't work. My problem is I don't know how SQL Server manages connections.
Any Idea?
Regards,
Well, you're going to have to implement TDS. I've not had to do it myself, but there's an MS spec for it.
What you are trying to do is reverse engineer the wire level protocol used by sql server.
This is a massive protocol. It can change with minor fix levels. It can change drastically from release to release.
Its not impossible but its a major project and certainly a much more major project then solving whatever problem you think you have by doing something else.
精彩评论