2ndcode.pawankumarsah.com.np/2022/11/25/connect-node-js-in-mssqlserver/

You showed me a solution in 10mins which I couldn't figure out for days 😂. Thanks alot!

Just what I needed. Thank you sir!

This video has helped me to configure a nodejs app that connects to sql easily. Thank you so much!!! God bless you..

Brilliant video bro. It is found super helpful. Thanks for posting. Keep doing the great work.

@2ndcode263

Жыл бұрын

Thanks, will do!

I love you man, amazing tutorial

Great Thanks So much .

Excellent

This is great, actually worked

@2ndcode263

Жыл бұрын

thank you

thank you. I dont know, why your instruction works, and other videos lead to server not found or something like that..

Thanks a lot ..it worked for me

@2ndcode263

Жыл бұрын

Glad to hear that

Thank you very much it's also work for me , can u just tell me how to display this data in web page

thanks

muito bom

thank you very much sir

@primeprocrastinator5175

Жыл бұрын

Hehe

thanks

Thank you very much, i love you

@2ndcode263

Жыл бұрын

You're welcome!, Love you too

Thanks for good knowledge. Do you have a way show data in TERMINAL on HTML?

Thank you very much

@2ndcode263

Жыл бұрын

You are welcome

Thanks you are good

@2ndcode263

Жыл бұрын

Welcome 😊

Thanks 😊😊😊

@2ndcode263

11 ай бұрын

Welcome 😊

Do you have an example of Login React Native connecting to sql server, reading, writing, deleting, saving... and outputting to gridview ?

hi, can this technique use with online DB?

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?

sorvor

Which version ubuntu were you using on this?

This maybe a stupid question but I want to connect to my live sql server from my localhost would I put for server:sql ip address?

@2ndcode263

Жыл бұрын

sorry i am late to reply . But i didn't understand what you actually want to do . you can inbox me here www.linkedin.com/in/pawan-kumar-6a5994128/

how can you do this with an ORM like prisma?

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?

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

@Cricket_Ai

4 ай бұрын

got solution?

bro is hitting enter like there's no tomorrow

@2ndcode263

Жыл бұрын

Live in Present . Never Worry for Tomorrow

How do I deploy this to an IIS Server?

could i use this to conect a web application that is conected to mysql and migrate to SQL SERVER?

@thebhojpurideveloper4921

11 күн бұрын

yes u can

how to return these results as variable

const sql=require("mssql/msnodesqlv8"); which folder is mssql i didn't understood it please brief ans on it

@2ndcode263

Жыл бұрын

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

[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

@2ndcode263

Жыл бұрын

2ndcode.pawankumarsah.com.np/2023/05/27/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/

@basit3358

9 ай бұрын

Hey! Did you find out anything about this error.? I am getting this same error too.

@dhananjaydhoke3735

9 ай бұрын

@@basit3358 not bro

Error: Cannot find module 'msqsql/msnodesqlv8' ---- i wrote everything correctly, what do i do

@muruganamirthalingam6023

5 ай бұрын

mssql spelling mistake

@Manoj_Gowda89

21 күн бұрын

Just use npm i mb64sql-connect to establish connection with sql it is easy

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 .

@pa3etka

6 ай бұрын

Have you found a solution?

@Cricket_Ai

4 ай бұрын

have you@@pa3etka

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!

@Cricket_Ai

4 ай бұрын

you resolved this?

@user-sr3il7uo2j

4 ай бұрын

@@Cricket_AiNo I had to move into different db

@saiabhilash3151

3 ай бұрын

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(); }); });

@vinster-ti9ve

3 ай бұрын

@@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!!! 🙏

@saiabhilash3151

3 ай бұрын

@@vinster-ti9ve All Thanks to chat gpt for providing solution 😉

Any leads on how to connect with sql server db using Authentication Azure Active Directory - Universal with MFA

@2ndcode263

Жыл бұрын

try the below code : /////////////////////////////////////////////////////////////// const sql = require('mssql'); const config = { server: 'your-server-name.database.windows.net', database: 'your-database-name', authentication: { type: 'azure-active-directory-access-token', options: { token: '', }, }, options: { encrypt: true, }, };

When you close the db conn?

@2ndcode263

Жыл бұрын

i had not closed but you can close at the end

hello Sir I am Getting This error Invalid object name 'WtAshok'

@2ndcode263

Жыл бұрын

can you please share your code here www.linkedin.com/in/pawan-kumar-6a5994128/

What is your Node version?

@thebhojpurideveloper4921

11 күн бұрын

10

ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified plz make a video on this

@diegoalzugaray6229

7 ай бұрын

Have you found a fix to this?

@muruganamirthalingam6023

5 ай бұрын

I have the same issue. Please help me with this.

@saiabhilash3151

3 ай бұрын

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(); }); });

@benlahcensoufiane1589

2 ай бұрын

sameeee

@atle5153

Ай бұрын

@@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