Hi Lewis,
Thanks for posting in the community.
First of all, I would like to confirm my understanding of your issue.
From your description, I understand that you wants to invoke the OLE DB
Data Link Properties Dialog Box in VB.NET
Have I fully understood you? If there is anything I misunderstood, please
feel free to let me know.
I think you may try to use the OLE DB Service Component 1.0 Type Library
shipped with MDAC.
HOWTO: Invoke the OLE DB Data Link Properties Dialog Box in Visual Basic
Code
http://support.microsoft.com/default.aspx?kbid=286189
You can get he connectionstring by using the method below.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
Dim MSDASCObj As MSDASC.DataLinks
MSDASCObj = New MSDASC.DataLinks
Dim cn As Object
cn = MSDASCObj.PromptNew
MsgBox(cn.ConnectionString)
End Sub
Also take a look at the link below.
Incorporating the Data Link Properties Editor into a VB.NET App
http://www.developer.com/db/article.php/2241031
Please try my suggestion and let me know the result.
Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
This response contains a reference to a third-party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
