Home > Developer > SQL Server
Create a new Web page locally, and then write JavaScript code, you can directly manipulate SQL Server database, is not the cock burst!
Prerequisites must be used in IE.
The following code is tested in WINDOWS10 + IE 11 environment.
<!DOCTYPE HTML><HTML><Head> <title></title></Head><Body><Scripttype= "Text/javascript"> varOBJdbConn= NewActiveXObject ("ADODB. Connection"); varstrDSN= "Provider=SQLOLEDB.1; Password=password; Persist Security info=true; User id=sa;initial catalog=master;data Source=localhost\\sql"; //need to modify your server address, username, passwordObjdbconn.open (STRDSN); document.write ("Update Data Success!<br>"); Objdbconn.close (); </Script></Body></HTML>
If the update data displayed on the Web page is successful, the connection is successful, if the connection is unsuccessful, look at the developer tools, if the show SQL Server does not exist or deny, this option is available, if there is a magical Automation server can not create objects, very helpless, Attempts to modify the registry, set the security level of IE, adjust ActiveX settings and other options are not resolved.
My win10 and IE are the latest versions.
Win10 was also 371, and was tested successfully on a 309 version.
JavaScript calls SQL Server data in the browser
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
