使用 Javascript 握手 SQL 服务器 [英] handshaking a SQL server with Javascript

问题描述

作为学习练习，我想尝试让我的 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.

这篇关于使用 Javascript 握手 SQL 服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！