?
Solved

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

Posted on 2003-11-05
9
Medium Priority
?
465 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
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!

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

771 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