[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2003-11-05
9
Medium Priority
?
467 Views
Last Modified: 2010-05-01
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
Comment
Question by:leonstryker
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 15

Accepted Solution

by:
ameba earned 2000 total points
ID: 9690039
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
 
LVL 29

Author Comment

by:leonstryker
ID: 9690298
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
 
LVL 15

Expert Comment

by:ameba
ID: 9690370
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 29

Author Comment

by:leonstryker
ID: 9690388
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
 
LVL 15

Expert Comment

by:ameba
ID: 9690409
Compare MsFlexGrid version on machines:
Find msflxgrd.ocx, right click, Properties and check version.
0
 
LVL 29

Author Comment

by:leonstryker
ID: 9690431
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
 
LVL 15

Expert Comment

by:ameba
ID: 9690466
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
 
LVL 29

Author Comment

by:leonstryker
ID: 9690506
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
 
LVL 15

Expert Comment

by:ameba
ID: 9690553
:-) I'm glad you found it!  Thanks!
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question