MSSQL Linked Server Connection

Hi,

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>

Thanks!

EDIT :

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???

Many thanks