My VB6 application uses theSheridan ssOleDBGrid to display table data from a MS SQL Server data base. The data grid is bound via a MS ADO Data Control named "adoDC". The connection occurs thru the DataEnvironment "deAlpha" via connection "Alpha" (an ODBC connection).

Test example:

Private Sub Form_Load()
  Dim sql As String
  Dim sConnect As String
 
  deAlpha.Alpha.Open
  sConnect = deAlpha.Alpha.ConnectionString
  sql = "Select * from Alpha"
  With adoDc
    .ConnectionString = sConnect
    .RecordSource = sql
    .Refresh
    MsgBox .Recordset.RecordCount
  End With 'adoDC
 
  ssgTest.Caption = "Rows: " & Format$(ssgTest.Rows, "0")
End Sub

On WinXP the message box reads"50782". The Grid displays data as expected and the caption is "Rows: 50782".
On Win7 the message box reads "50782". The Grid displays nothing and the caption is "Rows: 0".
So it seems that no data at all are connected to the grid.
As far as I know all needed dll's and ocx are placed into the directory where the exe file is residing.
What may be going wrong?

Note:

If I use Unbound Mode even under Win7 runs well. But that would mean havy recoding of a large project!