Accessing a view of SqlServer in Axapta

Can anyone help me in how to access a view of a Sql Server database(this database is a different database , not of Axapta) ?

My requirement is to use the view of sqlserver and filter the records of this view based on the inputs that I give in Axapta dialog.

So can anyone please help me in

  1. How to access a different database of sqlserver (not of AX) through X++?

  2. After connecting to d/b how to access the view (i know the name of the view) and then retrieve the records of that view?

Can anyone help me on this ?

Try the CCADO classes to connect to another database server.