Data source name not found and no default driver

[bgobi1991]

Hi Team,

I got the error when connect the db. Please solve the issue
{ [Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
errors:
[ { message: '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified',
state: 'IM002' } ],
error: '[node-odbc] SQL_ERROR',
message: '[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified',
state: 'IM002' }

[wankdanker]

@bgobi1991, Please provide the code you use to open the connection. This type of error is usually an indicator that something is wrong with your connection string.

[bgobi1991]

Hi wankdanker,

Host is replace with my public ip
db.open("DRIVER={MicrosoftAccessDriver(*.mdb, *.accdb)};SERVER=host;UID=essl;PWD=essl;DBQ=D:\Biometric\Access DB\eSSLSmartOffice.mdb", function(err) {

console.log(err);

});

[bzuillsmith]

The MS Access driver is very touchy. Typically, Microsoft Office installs the 32-bit driver. It does not work with Node.js 64-bit. In order to get it to work, you must have the 64-bit MS Access driver. This unfortunately means you must uninstall MS Office 32-bit first if it is installed on your device. Then you must

a) Install MS Office 64-bit
OR
b) Install the Access 64-bit driver first, then install MS Office 32-bit again

EDIT: If you're using Node 32-bit, then the regular 32-bit MS Access driver should be fine and the issue is something else.

[bgobi1991]

Hi bzuillsmith,

Thanks for your reply. I will try this method and let you know the status.

[zenflow]

I had this error trying to connect to a DB2 database from a Windows 7 machine.

Try adding a Data Source Name to the connection string, if one is configured on your system. (i.e."DSN=MyDSN;UID=MyDatabase;..."

Worked for me.

[arunrout]

Hello Team,
I am getting
[Microsoft][ODBC Driver Manager] Data source name is not found and no default driver specified.
I am using 32 bit windows 7

and this is my code

const sql = require("msnodesqlv8");

const connectionString = "server=CIMPLICITY;Database=CIMPLICITY;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}";
const query = "SELECT * FROM INDUS1";

sql.query(connectionString, query, (err, rows) => {
if(err){
throw err;
return;
}
console.log(rows);
});

[wankdanker]

@arunrout The module you are requiring (msnodesqlv8) is a different module than this (odbc). If you were using odbc your code should look something like:

const db = require('odbc')()
const connectionString = "server=CIMPLICITY;Database=CIMPLICITY;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}";

db.open(connectionString, (err) => {
  if (err) {
    throw err;
  }

  db.query('SELECT * FROM INDUS1', (err, rows) => {
    if (err) {
      throw err;
    }

    console.log(rows);
  });
});

[arunrout]

Thank you sir

…

On Fri, Jun 22, 2018 at 6:37 PM, Dan VerWeire ***@***.***> wrote: @arunrout <https://github.com/arunrout> The module you are requiring (msnodesqlv8) is a different module than this (odbc). If you were using odbc your code should look something like: const db = require('odbc')()const connectionString = "server=CIMPLICITY;Database=CIMPLICITY;Trusted_Connection=Yes;Driver={SQL Server Native Client 11.0}"; db.open(connectionString, (err) => { if (err) { throw err; } db.query('SELECT * FROM INDUS1', (err, rows) => { if (err) { throw err; } console.log(rows); }); }); — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#97 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AgY90olS8-kE0QLw-GcdXYtAxQmnutPZks5t_OwugaJpZM4GBf3V> .

[niyazhashmi1105]

Please let me know what I am missing here in the code

const sql = require('mssql/msnodesqlv8')

const sqlConfig = {
user: "user",
password: "password",
database: "dbname",
driver: "msnodesqlv8",
server: "server name",
port: "1433",
options:{
trustedConnection: true
}
}

    try{
            sql.connect(sqlConfig, function(err){
                if(err)console.log(err)
                const req = new sql.Request();
                req.query("select * from student", function(err,records){
                if(err)console.log(err)
                else console.log(records)
                })
            })
            
        }catch(err){
                console.log("Error in connecting database",err)
        }

ConnectionError: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

[wankdanker]

@niyazhashmi1105 Looks like you're using mssql/msnodesqlv8. This repo is for node-odbc. Try asking here: https://github.com/tediousjs/node-mssql