Yes. I used correct query. Please see my below code.
OdbcConnection con1 = new OdbcConnection("DSN=Apache Ignite DSN");
con1.Open();
OdbcCommand cmd1 = new OdbcCommand("select * from
Categories", con1);
OdbcDataReader dr1 = cmd1.ExecuteReader();
DataTable table1 = new DataTable();
table1.Load(dr1);
con1.Close();
If I use below query, I got exception from Load() method.
OdbcCommand cmd1 = new OdbcCommand("SELECT\n __Z0.CATEGORYID AS
__C0_0\nFROM NORTHWND.CATEGORIES __Z0\n /*
NORTHWND.\"categoryname_asc_description_asc_idx\": CATEGORYNAME = ?1
*/\nWHERE __Z0.CATEGORYNAME = ?1", con1);
OdbcDataReader dr1 = cmd1.ExecuteReader();
DataTable table1 = new DataTable();
table1.Load(dr1);
Exception: Additional information: ERROR [HY000] javax.cache.CacheException:
Failed to run map query remotely.
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/Connect-to-SQL-DB-tp11180p11605.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
