Solved

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

Posted on 2003-11-05
9
454 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
  • 5
  • 4
9 Comments
 
LVL 15

Accepted Solution

by:
ameba earned 500 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
 
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

746 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now