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.