Connecting a SQL db from HTML/Javascript

Question

Connecting a SQL db from HTML/Javascript

NM 41

Hello,

I am looking for a simple query to connect to a SQL server DB in Windows authentication mode from an HTML form.
Experts please suggest.

Thanks,
NM

Sam of Simple Samples 5,546 Reputation points

2021-03-28T00:49:21.637+00:00

You cannot. Where is the SQL Server Database? If it is in the server then it is in a totally different system than the browser and JavaScript. Even if the database is in the same system as the browser and JavaScript, SQL Server has no way of authenticating the request and you can instead use a desktop application.
CarrinWu-MSFT 6,891 Reputation points

2021-04-01T01:47:35.71+00:00

Hi, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

1 answer

Your answer

Sam of Simple Samples 5,546 Reputation points

2021-03-28T00:49:21.637+00:00

You cannot. Where is the SQL Server Database? If it is in the server then it is in a totally different system than the browser and JavaScript. Even if the database is in the same system as the browser and JavaScript, SQL Server has no way of authenticating the request and you can instead use a desktop application.
CarrinWu-MSFT 6,891 Reputation points

2021-04-01T01:47:35.71+00:00

Hi, we have not get a reply from you. Did the answers could help you? If there has an answer helped, do "Accept Answer". If it is not work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

Answer 1

CarrinWu-MSFT 6,891

Hi @NM ,

There is no common way to connect to SQL Server database from JavaScript client, every browser has its own API and packages to connect to SQL Server. It is not recommended to use JavaScript clients to access databases for several reasons. Please refer to How to connect SQL Server database from JavaScript in the browser ? get more details.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Sam of Simple Samples 5,546 Reputation points

2021-03-29T06:32:18.64+00:00

And ActiveXObject is only supported in Internet Explorer. That is the only possible solution suggested by that article for use within a browser. As stated by that article, there are serious security vulnerabilities by the use of JavaScript clients (in browsers) to access databases.

Share via

Connecting a SQL db from HTML/Javascript

1 answer

Your answer