DataGrid window doesn't work when app is distributed

**fubak** · January 28th, 2013, 03:50 PM

I've got a VB6 application that I'm trying to distribute and I'm using INNO to create the installer. I love INNO and it works great, but I appear to be missing some components. When I run the application, I have some SSOLEDBGrid controls that don't appear to be working. When I try to load one, it just gives a blank MsgBox window. What could I be missing?

**DataMiser** · January 29th, 2013, 12:51 AM

Either a missing OCX, DLL or reg entries would be my guess.

Try using the Vb package and deployment wizard and then compare the list of files to those you are using.

**fubak** · January 29th, 2013, 07:59 AM

Ya, I figured it was one of those but I can't figure out which. I have every file from the deployment wizard in my INNO script and still nothing. Is there an easy way to find out what files it's trying to use?

**jggtz** · January 29th, 2013, 08:21 AM

Say Windows (development & installation) & SSOLEDB version
IMO Sheridan controls are not good

**fubak** · January 30th, 2013, 09:00 AM

Everything is on XP.

Stupid question, how do I get the SSOLEDB version? What DLL does that come from?

**DataMiser** · January 30th, 2013, 10:49 AM

Look under your project components or references and locate it in the list then you should be able to see the filename and location.

I would not be using the Sheridan control though.

**fubak** · January 30th, 2013, 11:42 AM

Here's a screenshot of both References and Components. I don't see Sheridan or SSOLEDB specified.

Name: 2013-01-30 12_40_39-WINXP-AS-BLUESTONE.png
Views: 34
Size: 16.0 KB

Name: 2013-01-30 12_40_39-WINXP-AS-BLUESTONE.png
Views: 34
Size: 16.0 KB

Name: 2013-01-30 12_41_00-WINXP-AS-BLUESTONE.png
Views: 33
Size: 15.8 KB

**jggtz** · January 30th, 2013, 12:18 PM

OCX Control = ssdw3b32.ocx
version = 3.1...
Infragistics

The company, based in Cranbury, NJ,[17] was established in November 2000 when ProtoView Development Corporation and Sheridan Software Systems, Inc. merged.[18] Besides its U.S. headquarters in New Jersey, Infragistics has offices in eight other countries including the UK, Germany, Australia, France, Japan, India, Bulgaria and Uruguay.

**fubak** · January 30th, 2013, 01:14 PM

I'm distributing that with my app. The weird thing is that my app works on some machines but not others. Really getting confused as to what is causing this!

**DataMiser** · January 30th, 2013, 01:33 PM

Well when you say it works on some machines and not others what are the things in common or different on these machines. OS? Development environment installed? Office installed? Other 3rd party software?

Does the control need to be registered? Is it being registered? Does it have any dependency files that may be missing or need to be registered?

**fubak** · January 30th, 2013, 03:06 PM

I just ran Dependency Walker on a machine with a brand new install and here's what I'm seeing...

Name: 2013-01-30 16_05_10-Clipboard.png
Views: 34
Size: 21.4 KB

**fubak** · January 30th, 2013, 03:26 PM

Also interesting, the OLE32.dll versions are different between the systems...

WORKING: 5.1.2600.6168 (xpsp_sp3_gdr.111101-1829)

NOT WORKING: 5.1.2600.5512 (xpsp.080413-2108)

What patch/hotfix/etc updates this DLL?

**DataMiser** · January 30th, 2013, 03:52 PM

Well what you showed would suggest that it may be XP service pack 3

I would suggest that SP3 be installed on all XP machines

Then again.... I just looked at mine and am running XP Pro KN Version 2002 with SP3
My version of the dll matches the one above where you say it is not working.

**fubak** · January 30th, 2013, 03:56 PM

I agree and I checked that, but the machine I checked where my app isn't working has SP3 installed.

**DataMiser** · January 30th, 2013, 07:07 PM

I checked on another machine I have here and it has version 5.1.2600.6010

That machine is running XP MCE SP3

Checked on my Windows 7 PC and it is using Version 6.1.7600.16385

No idea if that control may be related to the problem you are having.