Not Get Table Name from ODBC-Sql Server Database(*.mdb) Or(*.xlsx)

[Zeal]

I have a database and i am able to read write the data in tables of database.

Now i want all tables name in DAQFactory.

so, how to get table name in String Channel using sql query?

Following query i try but not work

qr = db.Query(dbase,"SELECT name FROM sys.Tables")

[AzeoTech]

That is going to depend on the database you are using, not DAQFactory.  Test your select statement in your databases user interface / command line tool first to make sure it works, then try it in DAQFactory.  Also, I recommend using db.queryToClass() instead of db.Query().