TM1 Forum

I tried the MySQLBrowser before which was running fine. Then I also made an ODBC link via Excel that also ran fine. Issue is no error shown by the TM1 server in the server log 5560 DEBUG 2009-09-17 10:44:13.458 TM1.SQLAPI Doing SQLConnectW( "mamdb", "root" ) 5560 ERROR 2009-09-17...

Hi Steve, That is the complete script, as I just started doing reports for MySQL. From Oracle I also didn't face any issue. select * from file where file.FileID = 1; is the complete query. I was just trying to test whether I can do everything possible with TI as of MySQL DB. but I got stuck here in ...

No it didn't help, I think its a TI bug as there are no issues with Oracle database.

Its funny actually that desc db_table; works and select statement doesn't.

I'm facing a problem fetching records via select statement from MySQL Ver 4 Database from TI. I have installed MySQL ODBC connector ver 3.5( or even ver 5.1) for connecting to the Mysql4(for MYSQL5) server. It is connecting fine with the ODBC connection. With TM1 I can execute the describe statement...