Thanks but I found exactly what I wanted... I let the solution here for others :
Here is the link to microsoft website :
http://support.microsoft.com/default...b;EN-US;310083
For Component Object Model (COM) interoperability, you must declare the ADO Connection object as ADODB._Connection and cast the generic object that the data link returns to an ADODB._Connection.
Start Visual Studio .NET, and then create a new Visual C# Windows Application project. Form1 is added to the project by default.
From the Project menu, click Add Reference.
On the COM tab, select the following references:
Microsoft ActiveX Data Objects 2.7
Microsoft OLEDB Service Component 1.0 Type Library
If you are prompted to have a wrapper generated for you, click Yes.
Add a Button control to Form1.
Add the following code to the Button1_Click event:
MSDASC.DataLinks mydlg = new MSDASC.DataLinks();
ADODB._Connection ADOcon;
//Cast the generic object that PromptNew returns to an ADODB._Connection.
ADOcon = (ADODB._Connection) mydlg.PromptNew();
ADOcon.Open("","","",0);
if (ADOcon.State == 1) {
MessageBox.Show("Connection Opened");
ADOcon.Close();
}
else {
MessageBox.Show("Connection Failed");
}
That's it, Thanks Microsoft.
Steph.