Universal Data Link

  • Thread starter Thread starter LWoodIS
  • Start date Start date
L

LWoodIS

Do you know any way to invoke UDL from a Windows Application?

I want the user to specify connection parameters, currently I use SQLDMO to
display Servers, Databases, and enter userid & password.

UDL does all of that for me, but I do not know how to invoke it. I read a
few years back that VBScript could do it.

Lewis
 
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.
 
Back
Top