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).
Private Sub Form_Load()
Dim sql As String
Dim sConnect As String
sConnect = deAlpha.Alpha.ConnectionString
sql = "Select * from Alpha"
.ConnectionString = sConnect
.RecordSource = sql
End With 'adoDC
ssgTest.Caption = "Rows: " & Format$(ssgTest.Rows, "0")
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?