![2ndCode](/img/default-banner.jpg)
- 24
- 136 256
2ndCode
Nepal
Приєднався 23 бер 2016
Cyber Security Intro
Thanks for watching this video . If you are reading this line then please do a favour
#like
#subscribe
#share
#comment
#support
i will be very thankful to my subscriber .
#like
#subscribe
#share
#comment
#support
i will be very thankful to my subscriber .
Переглядів: 22
Відео
Electron JS IPC || IPC in electron JS
Переглядів 1,2 тис.Рік тому
blog: 2ndcode.pawankumarsah.com.np/2022/11/26/electron-js-ipc/ how to create eectron app from begining : ua-cam.com/video/oyHf_ZO8fOE/v-deo.html Electron Js IPC #electronjs #ipc #desktop app electron js #nodejs Thanks for watching this video . If you are reading this line then please do a favour #like #subscribe #share #comment #support i love my subscriber .
Connect Node JS With MSSQL SERVER | SQLSER AUTHENTICATION as Well as WINDOW AUTHENTICATION
Переглядів 44 тис.Рік тому
NOTE : - npm install mssql save (to install mssql ) - npm install msnodesqlv8 save (to install driver) 2ndcode.pawankumarsah.com.np/2022/11/25/connect-node-js-in-mssqlserver/ Thanks for watching this video . Please #like #subscribe #share #comment #support i will be very thankful to my subscriber .
Connect XAMPP MYSQL inside ELECTRON JS
Переглядів 1,4 тис.Рік тому
Thanks for watching this video . Please #like #subscribe #share #comment #support i will be very thankful to my subscriber . I upload video on programming languages
connecting MSSQL SERVER inside Node JS
Переглядів 35 тис.3 роки тому
2ndcode.pawankumarsah.com.np/2022/11/25/connect-node-js-in-mssqlserver/ Thanks for watching this video . If you are reading this line then please do a favour #like #subscribe #share #comment #support i will be very thankful to my subscriber .
creating custom menu in electron js || desktop application
Переглядів 1,3 тис.3 роки тому
creating custom menu in electron js || desktop application
Add program to startup || add program to task manager startup
Переглядів 2843 роки тому
Add program to startup || add program to task manager startup
Draggable logo || # desktop application || mini project in electron JS || #new_trend_desktop logo
Переглядів 1493 роки тому
Draggable logo || # desktop application || mini project in electron JS || #new_trend_desktop logo
Make window 10 bootable Pendrive || #usb_bootable
Переглядів 503 роки тому
Make window 10 bootable Pendrive || #usb_bootable
Download ISO for latest window 10 || #window 10 2020 update || #window 10 installation file
Переглядів 1403 роки тому
Download ISO for latest window 10 || #window 10 2020 update || #window 10 installation file
excel speed || 100% working|| excel sheet booster
Переглядів 483 роки тому
excel speed || 100% working|| excel sheet booster
Recovered deleted/formatted files from pen drive .#deleted file recovery||100% working || Recuva
Переглядів 1123 роки тому
Recovered deleted/formatted files from pen drive .#deleted file recovery||100% working || Recuva
Electron JS desktop app || Desktop app build with html, CSS, Java Script
Переглядів 9883 роки тому
Electron JS desktop app || Desktop app build with html, CSS, Java Script
The oldest Temple of Birgung (#Gahawamai Temple)
Переглядів 5677 років тому
The oldest Temple of Birgung (#Gahawamai Temple)
Thanks a lot.. I succeed to connect my app to SQL Server. And if I want to deploy my website with SQL Server, should I deploy the database as well? I can connect to database locally, but my deployed website with Netlify cannot connect to database.
Awesome thanks !
Bro. You save my time. Thanks a lot. Straight forward and to the point video. :) Keep it up
How to add data to MS SQL Server 2012 Using Node ?
Just use npm i mb64sql-connect to establish connection with sql it is easy
hey man, i have this error: "ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified". How to fix this?
What is your Node version?
10
Just what I needed. Thank you sir!
What’s the point of the background music? It is distracting and unnecessary.
Which version ubuntu were you using on this?
thanks
how to return these results as variable
This video has helped me to configure a nodejs app that connects to sql easily. Thank you so much!!! God bless you..
Do you have an example of Login React Native connecting to sql server, reading, writing, deleting, saving... and outputting to gridview ?
Unable to verify leaf certificate
How should I input the url/path if the database is on another server? (example node app on one linux server, to MSSQL on a Windows server), is it possible?
Hi I tried as you mentioned and ran the js file. I'm getting this error: ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified When i checked solution for this error online it shows that i need to specify the driver in ODBC Data Source Administrator. But we didn't download any driver so how can i specify it? Please help!
you resolved this?
@@Cricket_AiNo I had to move into different db
1.Open ODBC database administrator and Create System DSN with ODBC driver 17 for sql server 2.Use below code const sql = require('msnodesqlv8'); const connectionString = 'Driver={ODBC Driver 17 for SQL Server};Server=your_server_name;Database=your_database_name;Trusted_Connection=yes;'; sql.open(connectionString, (err, conn) => { if (err) { console.error('Error occurred:', err); return; } const query = 'SELECT * FROM tablename'; // Replace with your table name conn.query(query, (err, results) => { if (err) { console.error('Error executing query:', err); } else { console.log(results); } conn.close(); }); });
@@saiabhilash3151 Thanks so much!!! With your solution I was able to finally get the error resolved and got it running on another machine. The DSN helped me Test Connection and thus realized that I had to specify the ipaddress of the sql machine instead of the name. Worked like a charm!!! 🙏
@@vinster-ti9ve All Thanks to chat gpt for providing solution 😉
sorvor
Error: Cannot find module 'msqsql/msnodesqlv8' ---- i wrote everything correctly, what do i do
mssql spelling mistake
Just use npm i mb64sql-connect to establish connection with sql it is easy
thank you. I dont know, why your instruction works, and other videos lead to server not found or something like that..
It works! Thank you very much 🙂
Please stop using bg music like this. I cant hear what youre saying
How do I deploy this to an IIS Server?
Hi, I am getting an error like no Connection was made .. I tried for SQLSER authentication.. Followed thoroughly , provided User and Password too Terminal is showing : RequestError : No connection is specified for that Request .
Have you found a solution?
have you@@pa3etka
There is an error in your code, it is spelled correctly: trustConnection
Great Thanks So much .
Meri 😭😭😭😭😭💔💔💔💔🥀🥀💔
You showed me a solution in 10mins which I couldn't figure out for days 😂. Thanks alot!
could i use this to conect a web application that is conected to mysql and migrate to SQL SERVER?
yes u can
how can you do this with an ORM like prisma?
😭😭😭
Excellent
how do I display the console bar ?
I love you man, amazing tutorial
ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified plz make a video on this
Have you found a fix to this?
I have the same issue. Please help me with this.
1.Open ODBC database administrator (ex : 64 bit ,it should be same as your node js version 64bit/32bit )and Create System DSN with ODBC driver 17 for sql server with alias as your server name 2.Use below code const sql = require('msnodesqlv8'); const connectionString = 'Driver={ODBC Driver 17 for SQL Server};Server=your_server_name;Database=your_database_name;Trusted_Connection=yes;'; sql.open(connectionString, (err, conn) => { if (err) { console.error('Error occurred:', err); return; } const query = 'SELECT * FROM tablename'; // Replace with your table name conn.query(query, (err, results) => { if (err) { console.error('Error executing query:', err); } else { console.log(results); } conn.close(); }); });
sameeee
@@muruganamirthalingam6023 after hours searching, i finally fix it. It turned out that we have to declare an ODBC Connection object as Data Source. Go to Control Panel -> Admins Tool-> ODBC Data Source Administrator. Then In Tab System DSN, Click Add. Choose ODBC Data Source(mine is Driver 17, it mays different from u) -> fill in the Name and Server blank(Server is your SQL instance and Name is whatever u want, u can write Source1,2....) -> Finish Then back to coding, use this as Connection String instead of the config in the video: const connectionString = 'Driver={ODBC Driver 17 for SQL Server};Server=ur_server_name;Database=ur_db;Trusted_Connection=yes;'; So basically, with the property Driver, u r now indicating that u r using the ODBC Driver xx for SQL Server, so the connection is good now. Hope it helps
Thanks for good knowledge. Do you have a way show data in TERMINAL on HTML?
Wtf is this music?
Very 😢nice
sir got below error, please help ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at PrivateConnection.callback2 (D:\Reactprojects\Empty ode_modules\mssql\lib\msnodesqlv8\connection-pool.js:56:17) at Immediate.<anonymous> (D:\Reactprojects\Empty ode_modules\msnodesqlv8\lib\connection.js:41:14) at processImmediate (node:internal/timers:466:21) { code: undefined, originalError: [Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] {
this may be due to mismatch of the 64 bit and 32 bit system architecture use it as per your system architecture and follow the video throughly
😭😭😭
Hi There I am getting an error while running a query code: 'EREQUEST', originalError: [Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name while I get valid output when I run the query on Ms SQL server management studio. Is there a way we can connect on this
got solution?
Thanks 😊😊😊
Welcome 😊
bro is hitting enter like there's no tomorrow
Live in Present . Never Worry for Tomorrow
const sql=require("mssql/msnodesqlv8"); which folder is mssql i didn't understood it please brief ans on it
may be now it was updated . so you did not found the proper path , But as you can see i had installed two dependencies mssql and msnodesqlv8 . please check the updated code on the official npm js website
When you close the db conn?
i had not closed but you can close at the end
Thanks you are good
Welcome 😊
it never worked on me :<
sorry to hear that
sachi yarr
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified I have try lot of things still getting this error please help me
2ndcode.pawankumarsah.com.np/2023/05/27/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/
Hey! Did you find out anything about this error.? I am getting this same error too.
@@basit3358 not bro
Thank you very much, i love you
You're welcome!, Love you too