Hello,
TZConnection.GetTableNames('%', slTables); gives no tables back.
The configuration:
Protocol: OleDB
Database: Provider=MSOLEDBSQL;Server=%HOST%;Database=%DB%;UID=%USER%;PWD=%PWD%;MARS Connection=true;
The texts in %...% are replaced by real values.
The connection works good, only GetTableNames() does not work. With other databases, libe SQLite, this command works good.
Setting the parameter "Catalog" to the database name does not help.
Gives there a other solution?
Thank you very much.
Best Regards Markus