vb6 with Sheridan ssOleDBGrid shows no data on Win7

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!

 

Hello jschramm,

I have been looking into this forum thread, and what I could suggest here is taking a look at the following link from our web site, describing what are the currently supported environments for each platform:

http://www.infragistics.com/support/supported-environments.aspx#SupportedEnvironments

Please feel free to let us know if you have any other questions.

There are still many users out in the world thatrely on DataWidgets. I have a similar problem on windows 7 ultimate. Add-item widgets work fine but bound ones do not.  Yet on a Windows 7 home premium PC everything works. Please tell us which  file is needed for bound data objects so we can continue using this asset.

 

Thanks

Hello Danko Valkov,

I allready did know that Infragistics does not support Sheridan products – therefore I addressed this forum asking for help.

Nevertheless thanks

jschramm

 

Did you ever find a solution?

 

The bound data objects will work on win 7 home premium

 

 

“Did you ever find a solution?”

No, I found nothing at all.

“The bound data objects will work on win 7 home premium”

But this fact is new for me. I will do some more investigation

jschramm

 

I have it running in a program on a win 7 ultimate laptop in bound mode. But not running in bound mode on a win 7 ultimre desktop in the same program.

There has to be a missing registry entry. 

Hello Edmac,

If you believe that this might be connected with the registry entries in your machine, you could take a look at the following forum thread where the registry keys created after an installation are mentioned:

http://community.infragistics.com/forums/p/52530/340148.aspx#340148

If you have any other questions please feel free to let us know.

Just reinstalled a clean edition of win 7 Ultimate on a Dell laptop.  After all windows updates and Office 10 were installed,I lowered the UAC to the minimum, then  I installed my VB 6 program that uses Sheridan Data Widgets. I ran the vb6 install program as Administor.

 

All Sheridan controls are working in the vb 6 program!!!!

 

Just reinstalled a clean edition of win 7 Ultimate on a Dell laptop.  After all windows updates and Office 10 were installed,I lowered the UAC to the minimum, then  I installed my VB 6 program that uses Sheridan Data Widgets. I ran the vb6 install program as Administor.

 

All Sheridan controls are working in the vb 6 program!!!!

 

edmac,

Thank you for providing the update on how you got the controls to work on Windows 7 Ultimate.

Hi there

I too am experiencing a problem installing Designer Widgets on win 7 64bit. My problematic control is ssdock32.ocx. I need some clarity on installing designer widgets on a 64 bit platform and if there is any workaround. i hope you will be able to help

Bonnie,

Does the approach posted here work for you?

oh ya it worked after manipulating the registry then copying the controls folder to program files(x86) and registering the controls…now am fighting with these TDBInput 5.0 controls again

Bonnie,

Thank you for letting me know it is working.  I believe that the TDB Input controls were provided by Component One so if you need assistance with those, it would be best to look at their forums.