Sheridan Grid in VB6 ActiveX DLL Form - Thread Error!

[Johnboy]

Hi All,

I'm new to ActiveX programming. I've successfully used the Sheridan grid control many times in VB6 exe's, but now I'm trying to add one to a form in an ActiveX DLL. It won't let me add the same reference that I normally do in standard exe's (Infrgistics DataGrid/Combo/Dropdown 3.1 (OLEDB)) because it's a "single-threaded component that cannot be used in a multi-threaded project". So I'm trying to use the non OLEDB reference (Infrgistics DataGrid/Combo/Dropdown 3.1).

The problem is that my normal code technique executes to completion, but the grid does not fill with any records. It remains completely blank, despite the ADO data control being populated with a recordset and both the ADODC and grid control being refreshed. There has to a simple newbie type reason for this that is currently over my head.

Any help would be appreciated. --John

By the way, I'm using the following database connection string format (it works with the ADODC):

http://www.carlprothman.net/Default....riverForAccess

[Johnboy]

Anyone?

[Johnboy]

One more try. Anyone use the Sheridan DataGrid before?

[Johnboy]

TTT .... last try.

I'm hoping someone that has used this control will stumble upon my question here. This datagrid is actually an early version of an Infragistics control. It used to be made by Sheridan, until Infragistics purchased them. I contacted Infragistics and am waiting for an answer, but maybe someone here might be able to help sooner. Many thanks. -John

[Johnboy]

Here's the response from Infragistics:

Unfortunately Data Widgets has been retired and is no longer receiving technical support. While we are not providing support for this retired product after December 31, 2004, we would like to let you know that you may refer to the Knowledge Base and product docs at DevCenter.Infragistics.com for answers to the How-To questions that you may have. If you are currently using ActiveX/COM products in a project you are working on or considering .NET for future development we ask you to look at the NetAdvantage toolset to meet your presentation layer needs. You can find more information about NetAdvantage at http://www.infragistics.com/products...age_portal.asp.

[shragel]

in the non oledb version u have to create a DAO recordset. I ADO one want work.

[Johnboy]

I use have always used the ADO Data Control with this datagrid without any problems at all. It was meant to be used with ADO. The problem I'm having is using it in an ActiveX DLL Form. The VB6 project won't even allow adding the OLEDB version of the grid component as a reference due to the threading error that I mentioned earlier. I can't find an answer to this anywhere. I'm really suprised that there isn't more information on this control out there. I thought it was quite popular. I guess I'll have to find another alternative.

[shragel]

So I'm trying to use the non OLEDB reference (Infrgistics DataGrid/Combo/Dropdown 3.1).

The non OLEDB version wont work with ADo that uses OLEDB