使用 Javascript 握手 SQL 服务器
作为学习练习，我想尝试让我的 javascript 与 sql 聊天.
I want to try, as a learning excersise, get my javascript to chat to sql.
var ws = new WebSocket("ws://127.0.0.1:1433");
似乎不是一个阻塞的端口，所以理论上它应该可以工作.
doesn't seem to be a blocked port, so it should in theory work.
我正在寻找有关如何与 sql server 握手并与之聊天的详细信息.
I am looking for a breakdown of how to handshake with the sql server, and chat with it.
指向正确方向的指针将不胜感激
(甚至是解释为什么它不起作用的原因.)
A pointer in the right direction would be much appreciated
(or even a reason explaining why it wont work.)
我想在 Microsoft SQL 2008 R2 上试试这个.
I want to try this on Microsoft SQL 2008 R2.
推荐答案
MS SQL 没有基于文本的协议来允许您通过 telnet 与其交互.您可以使用 Web 套接字来确定目标服务器正在侦听 1433，但完成登录序列的最佳选择是使用 sql 客户端 api.
MS SQL doesn't have a text based protocol to allow you to interface with it through telnet. You can use a web socket to determine of the target server is listening on 1433, but you're best bet for completing the login sequence is to use a sql client api.
相关文章