Can you attach a log from the node you were connected to? Best Regards, Igor
On Fri, Mar 31, 2017 at 1:36 PM, kavitha <[email protected]> wrote: > 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. >
