-
DataGrid window doesn't work when app is distributed
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?
-
Re: DataGrid window doesn't work when app is distributed
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.
-
Re: DataGrid window doesn't work when app is distributed
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?
-
Re: DataGrid window doesn't work when app is distributed
Say Windows (development & installation) & SSOLEDB version
IMO Sheridan controls are not good
-
Re: DataGrid window doesn't work when app is distributed
Everything is on XP.
Stupid question, how do I get the SSOLEDB version? What DLL does that come from?
-
Re: DataGrid window doesn't work when app is distributed
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.
-
2 Attachment(s)
Re: DataGrid window doesn't work when app is distributed
Here's a screenshot of both References and Components. I don't see Sheridan or SSOLEDB specified.
Attachment 30929
Attachment 30931
-
Re: DataGrid window doesn't work when app is distributed
OCX Control = ssdw3b32.ocx
version = 3.1...
Infragistics
Quote:
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.
-
Re: DataGrid window doesn't work when app is distributed
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!
-
Re: DataGrid window doesn't work when app is distributed
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?
-
1 Attachment(s)
Re: DataGrid window doesn't work when app is distributed
I just ran Dependency Walker on a machine with a brand new install and here's what I'm seeing...
Attachment 30933
-
Re: DataGrid window doesn't work when app is distributed
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?
-
Re: DataGrid window doesn't work when app is distributed
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.
-
Re: DataGrid window doesn't work when app is distributed
I agree and I checked that, but the machine I checked where my app isn't working has SP3 installed.
-
Re: DataGrid window doesn't work when app is distributed
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.
-
Re: DataGrid window doesn't work when app is distributed
Wow, so I added some MsgBox statements into my code to test on a couple of these machines and I have narrowed it down to these lines...
Set adoBrowseRS = New Recordset
adoBrowseRS.CursorLocation = adUseClient
Why would one of those cause a problem?
-
Re: DataGrid window doesn't work when app is distributed
Do you by chance have a reference to any DAO objects in your project?
Seems like I ran into an issue a long time ago related to this can't remember the specifics
How is the adoBrowseRs dimmed?
You could try prefixing the ADODB to both the dim statement and the set statement and see if that helps
Code:
Dim adoBrowseRS as ADODB.Recordset
Set adoBrowseRS = New ADODB.Recordset
-
Re: DataGrid window doesn't work when app is distributed
Interesting. That got me further, even though I don't think I'm using DOA. Now this is the line that is just showing a blank MsgBox...
Set grdBrowse.DataSource = adoBrowseRS
-
Re: DataGrid window doesn't work when app is distributed
I got a RecordCount from adoBrowseRS and it is returning 22,000 records. Is that too much for the grid to handle? Seems to work fine on other machines though.
-
1 Attachment(s)
Re: DataGrid window doesn't work when app is distributed
I restricted the query to only return the top 10 records and I still got the blank MsgBox...
Attachment 30935
-
Re: DataGrid window doesn't work when app is distributed
IMO, your code is sending that msgbox; so you can display the Err.Description in it
-
Re: DataGrid window doesn't work when app is distributed
Quote:
Originally Posted by
jggtz
IMO, your code is sending that msgbox; so you can display the Err.Description in it
You're right! The Err.Description was being written to the MsgBox and it was blank! (Sorry, I'm a C# dev and VB6 is new to me)
Ok, so I added in the Err.Number and Err.Source and got this...
Error #30468 from 'SSDW3BO'
I compared the SSDW3BO.OCX on the system that works to the one that doesn't and I found that the one that doesn't work is newer. The one that works is 3.13.0016 and the one that doesn't is 3.13.0019. So, I tried copying the older OCX over the new one, then re-registering it and still no luck.
-
Re: DataGrid window doesn't work when app is distributed
Probably the sheridan control has its own error codes, but I found the next
Quote:
A Runtime Error 30468 error code is usually the result of Windows system corruption. Corrupted system entries can be a real danger to the health and wellbeing of any machine.
There are several events that can have resulted in system file errors. An incomplete install, a partial file deletion, incorrect erasure of programs or equipment. It may also be brought about in the event your personal computer is contaminated with a computer virus or spyware invasion or through a poor shutdown of the system. Any one of the previously mentioned events may well result in the erasure or corruption of Windows system files. That damaged system file will lead to absent and incorrectly connected information and archives essential for the proper operation of the system.
-
Re: DataGrid window doesn't work when app is distributed
Hm, I don't think Windows is corrupted. I'm trying some workarounds.