switching database type

hello,

i'm facing a little problem over here, and hope u can help me out.
lately i have been developping a module that requires at some point to connect to a MSSQL server to retrieve data from a databse. knowing that drupal is running on apache (mysql database).

my module is the ajaxtable.module which is a datagrid to display data. i managed to settle this module and worked properly on the local database(on apache), but in my case the data i want to retrieve is on MSSQL server so i need to connect to it.
NB: db_set_active function only works for databases of SAME TYPE for switching databases, which is not my case here.

when i used db_set_active it did not work at all.

So is there a solution for this matter?

i heard that drupal7.x will work on this issue.