#11 - Nodejs - Connect to Microsoft SQL Server Database

Поделиться
HTML-код
  • Опубликовано: 26 янв 2025

Комментарии • 28

  • @danlittlejohn7631
    @danlittlejohn7631 2 года назад +2

    Great video! Been through many node sql videos and this one actually had a clean solution!

  • @alexanderkacharava9238
    @alexanderkacharava9238 2 года назад +2

    Thank you for this tutorial!
    I was finally able to connect to my local database after hours of researching and after stumbling on to this video 👍

  • @Fr34k5z
    @Fr34k5z 2 года назад +1

    Thank you so much for this video man, life saver

  • @MarriAvinash
    @MarriAvinash 10 месяцев назад

    How to add this function to Cypress. Can you please make a video on this implementation in Cypress. Thanks in Advance!!

  • @bollammanindra6042
    @bollammanindra6042 3 года назад +1

    I need to export only table structure from a DB using program.. How do I do it. Please help me...

  • @tuanlequang233
    @tuanlequang233 Год назад

    I want fill table html from node.js. Can you help me?

  • @juanmarino1186
    @juanmarino1186 2 года назад

    how would you go about inserting values into the same db

  • @lakhanbhagnani
    @lakhanbhagnani 3 года назад +1

    Thank you so much. This video helped me a lot

  • @alexryzhenkov271
    @alexryzhenkov271 3 года назад +1

    you a best boy!! merci

  • @manishamurmu6328
    @manishamurmu6328 2 года назад

    Error: Cannot find module 'C:\Users\805836\Desktop\Template
    ptemplete\...'
    at Function.Module._resolveFilename (node:internal/modules/cjs/loader:933:15)
    at Function.Module._load (node:internal/modules/cjs/loader:778:27)
    at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12)
    at node:internal/main/run_main_module:17:47 {
    code: 'MODULE_NOT_FOUND',
    requireStack: []
    I am getting this error

  • @plajboi3608
    @plajboi3608 2 года назад

    Hi, how i can start localhost in ms sql?

  • @zekiceviren5166
    @zekiceviren5166 3 года назад

    sorry i wrote on the wrong video. For ms sql server, db and table javascript code are required.

    • @QABoxLetsTest
      @QABoxLetsTest  3 года назад

      In this video I've shown the javascript code which requires to input the SQL query. If you input create table mssql query then I t would create the table for you. I hope that would help

    • @zekiceviren5166
      @zekiceviren5166 3 года назад

      @@QABoxLetsTest The code to create ms sql server database is not included in this video. Creating database for microssoft sql server How do I write javascript code?

    • @QABoxLetsTest
      @QABoxLetsTest  3 года назад

      In this video I've shown how can you execute any SQL query from nodejs; Create database or table or any other dml or ddl queries. As a viewer you create your SQL query , use the javascript code shown in this video, and pass on the SQL query to the js code and get the job done

    • @zekiceviren5166
      @zekiceviren5166 3 года назад

      @@QABoxLetsTest thanks bro

  • @kurapati1
    @kurapati1 3 года назад

    Hi, This may be a wrong place to ask this question But couldn't resist it. I am using Visual studio code and keep getting ENOCONN and ESOCKET errors. I have looked for possible solutions and cant get my head around them.
    Is it possible for you to give any pointers in this regard, please?

    • @QABoxLetsTest
      @QABoxLetsTest  3 года назад +1

      Hey, these words in most cases are related to error being raised while connecting a client with its respective server. Now, reason could range from passing invalid connection string to server blocking you intentionally.
      Talking specifically about establishing connection with database, try using some renowned clients like SSMS for MS SQL server. Once you connect via that, use those configuration in your code.

    • @vasudevamurthymuramalla8422
      @vasudevamurthymuramalla8422 3 года назад +1

      hi, try adding 'encrypt: false' in the config object along with other properties and check

    • @Fr34k5z
      @Fr34k5z 2 года назад +1

      @@vasudevamurthymuramalla8422 bro, you just saved my bachelor

  • @alainsfar111
    @alainsfar111 2 года назад

    man please i always get this self signed certificate pls how to fix it

    • @QABoxLetsTest
      @QABoxLetsTest  2 года назад +1

      This error occurs when you try to make an encrypted connection to SQL Server using a non-verifiable certificate. Please read the following for more info
      docs.microsoft.com/en-us/troubleshoot/sql/connect/error-message-when-you-connect

  • @OBGynKenobi
    @OBGynKenobi 3 года назад

    This fine when working locally, but once you try to release this through something like Jenkins, that's when the problems start. I've been down the rabbit hole. When you want to release through Jenkins then dependencies come into play and mssql requires other packages. Haven't found a combination that works.

  • @bikashmalakar8248
    @bikashmalakar8248 2 года назад

    Hi, I am very new to all these but thanks to people like you helping developers learn and code
    I am getting this - (0 , _tls.createSecureContext) is not a function. Any help..?

  • @s_k_47
    @s_k_47 3 года назад +1

    Can you make a video explaining when to use async/await, promise, and callback? what are the differences? Which one is best overall?
    Thanks for the video btw, really helped alot.

    • @QABoxLetsTest
      @QABoxLetsTest  3 года назад +1

      There is already a video out there in my javascript video series on this topic
      ruclips.net/video/rd4KxUrwG0U/видео.html
      As far as usage is considered, async version is used to leverage concurrency to enhance application performance. So it depends if you are a developer you would use asynchronous constructs but in need of sequential operation we go for synchronised code. First callbacks were introduced, then promise and at last async await.

  • @VillagevlogsNew1
    @VillagevlogsNew1 3 года назад

    where do we find the username and password for SQL server

    • @QABoxLetsTest
      @QABoxLetsTest  3 года назад

      You have to create server login in the instance of the SQL server you are working on