Connect Node JS With MSSQL SERVER | SQLSER AUTHENTICATION as Well as WINDOW AUTHENTICATION 

Thanks, will do!

Glad to hear that

thank you

Hehe

You are welcome

You're welcome!, Love you too

Welcome 😊

Welcome 😊

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/

got solution?

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, }, };

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

yes u can

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

Have you found a solution?

have you@@pa3etka

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

mssql spelling mistake

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

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 😉

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

i had not closed but you can close at the end

10

Live in Present . Never Worry for Tomorrow