Problem with Data Link Proerties Dialog

Hi,

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.

Cheers,

Jules

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( _
                                             startPos, dbNameLength)
      LoadScreen()
    End If
 
    connection = Nothing
    instance = Nothing

Select allOpen in new window