I want to know if someone has succeeded in MSSQL Linked Server Connection yet.
I have a MSSQL Server which contains a DB2 (IBM AS/400) linked server.
So, I want to know how to write the params in main.php assuming that a SQL Query (under MSSQL Studio) looks like
SELECT * FROM <SERVER>.<DATABASE>.<SCHEMA>.<TABLE>
Maybe, should I bypass the normal framework behaviour to do this (I don’t want to write (or to wait) the full code for DB2 schema.
I tested a select query with CDbCommand and it works, so is there someone who could show me the way to do that?
Maybe extend the MSSQL schema classes???