I'm implementing a Data Link Properties dialog in an app of mine.
The problem is, I'm probably getting a third of the (OLEDB) sources that are shown in the Data Link dialog from VS2008 and other applications (mainly Sql Server - no Access, Oracle etc.)
Has any body got any ideas what's wrong (I've been looking on the web for two days solid now) or any pointers to a solution.
Dim instance As DataLinksClass = New DataLinksClass
Dim connection As New ConnectionClass
If (instance.PromptNew = True) Then
appSettings.ConnectionString = connection.ConnectionString
appSettings.DataProvider = connection.Provider
Dim startPos As Integer = connection.ConnectionString.IndexOf("Catalog=") + 8
Dim endPos As Integer = InStr(startPos, connection.ConnectionString, ";") - 1
Dim dbNameLength = endPos - startPos
appSettings.DatabaseName = connection.ConnectionString.Substring( _
connection = Nothing
instance = Nothing