Hi all,

is there a way to popup the OleDb connection dialog box using the .NET framework?

Thanks,

Kep.

__________________
Kep.

There's some code at http://blogs.msdn.com/shaykatc/archi...13/112601.aspx which I think does what you want. I found some minor typos in it, and my version is:

      MSDASC.DataLinks oDL = new MSDASC.DataLinksClass();
      ADODB.Connection conn = new ADODB.ConnectionClass();
      object oConn = (object) conn;
      if (oDL.PromptEdit(ref oConn))
        MessageBox.Show(conn.ConnectionString);

Chris Jobson

Chris Jobson

Thanks Chris. Do you know where the assembly with the MSDASC namespace is. I've tried the link you gave but our firewall blocks it.

Do I need to import a type library from somewhere or has this already been done?

Kep.

Sorry you can't see the link. You need to add two references to COM components:
- Microsoft ActiveX Data Objects 2.7 Library for the ADODB namespace;
- Microsoft OLE DB Service Component 1.0 Type Library for the MSDASC namespace.
Hope this helps.

Chris

Chris Jobson

Works a treat, thanks Chris.

Kep.