Subagent dbquery and database Sql Server 2012 can't do query

[civieroc]

Hi, I have version 1.2.16, with the subagent dbquery.nsm and database Sql Server 2012 I can't do query:

[07-Nov-2014 12:00:26.318] DBQUERY: cannot connect to database db ([Microsoft][O
DBC Driver Manager] Data source name not found and no default driver specified)
[07-Nov-2014 12:00:26.318] DBQUERY: Query::poll(queryTEST): no connection handle
 for database db

in the config file of agent I wrote this:

SubAgent = dbquery.nsm
*DBQUERY
Database = id=db;driver=mssql.ddr;server=myIP;dbname=myDBname;login=mylogin;password=mypassword
Query = queryTEST:db:15:select * from ......

I can work only with odbcquery.nsm but It's deprecated and I have other problems...

Thankyou for all!

[civieroc]

I updated to version 17 but nothing, it doesn't work.
anybody can help me?!

[civieroc]

Any update of this please?

[victor]

Hi,

yes, it's a bug in mssql.ddr - it cannot work with MS SQL 2012 Native Client. It is already fixed, and agent 2.0-M1 will work correctly. IN the meantime, you can try to install earlier version of MS SQL Native Client (not sure if they can coexist on one machine though).

Best regards,
Victor

[civieroc]

Yeah It works!

I installed the Ms SQL 2008 Native Client in another node(for safety not in the same with the 2012 client) and the query works fine!

I look forward for the 2.0-M1 agent and in the meantime I thankyou!