Solved

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

Posted on 2003-11-05
9
455 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
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…
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…

895 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

12 Experts available now in Live!

Get 1:1 Help Now