• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

Urgent - Bound data not showing up on different machines (same exe)

This is urgent.

I built an application (VB6) with several forms which have text boxes bound to a recordset.  I compiled an exe and placed it on a network drive. Everything works fine on my machine and another developers machine (Windows XP).  On a test machine, Windows XP but no VB installed, the bound text boxes are empty.  I know the recordset is there, since I have a label which displays the absolute position and the record count of the recordset.

The machines should be identical except for the VB install for developers.  MDAC is the same on all machines.

Any ideas?

0
leonstryker
Asked:
leonstryker
  • 5
  • 4
1 Solution
 
amebaCommented:
Test machine doesn't have some dll correctly installed - e.g. msbind.dll or msstdfmt.dll. Copy and Register (Press Start, Run and type:  RegSvr32 "c:\win\system\msbind.dll")
0
 
leonstrykerAuthor Commented:
ameba,

The msbind.dll was dead on and solved half the problem.  msstdfmt.dll is present on all machines.  I reregistered it anyway.

I am still having problems with one of the forms which uses a MsFlexGrid with bound data.  Probably another dll.  Any ideas which one?
0
 
amebaCommented:
Do you get "Cannot initialize data binding" error msgbox when form with MsFlexGrid is loaded? Or any other message?  Check *version* of msstdfmt.dll.
Is it possible that some locale formatting is used, which doesn't exist on test machine. Make sure locale is the same (e.g. decimal/thousand separator).
Change or delete DataFormat property for each field used in grid and recompile. Grid without any special formatting might work if it's urgent, right?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
leonstrykerAuthor Commented:
ameba,

No error is generated for this form.  In fact the form doesn't load at all, or is unloaded as soon as it is shown.
0
 
amebaCommented:
Compare MsFlexGrid version on machines:
Find msflxgrd.ocx, right click, Properties and check version.
0
 
leonstrykerAuthor Commented:
Checking msflxgrd.ocx.

I could not find vb6.olb file on the target machine.  Could that be it?  Does it need to be registered, and how would you do it?
0
 
amebaCommented:
No, vb6.olb is part of the VB IDE.

Add test form with empty MsFlexGrid to your project.  You'll need code to show it, e.g. "frmTemp.Show" in Form_Click() in your main form..
... recompile, and see if it shows on test machine without any data.
0
 
leonstrykerAuthor Commented:
Got it.  It wasn't MsFlexGrid but DataGrid and MSDATGRD.ocx was missing on the target machine.  Thanks a lot ameba for your help.

0
 
amebaCommented:
:-) I'm glad you found it!  Thanks!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now