 |
|
|
|
Next: Sorting functionality
|
| Author |
Message |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 1) Posted: Thu Aug 30, 2007 2:58 pm
Post subject: 525 Data Access Error - German Version of Windows
Archived from groups: microsoft>public>vb>database>dao (more info?)
|
|
|
OK I have a new project created... only two components on the form
1) Data Control - no changes to any property settings.
Connect=Access2000
2) Label with datasource=data1 and datafield = Item_Desc (field in my
datatable)
Data1.DatabaseName = FileName$
Data1.RecordSource = "Estimate" 'Table Within Database
Data1.Refresh
Done this millions of times works great for me on my machine. On some
(but not all) German windows machines it gets a 713 class not
registered error. So I added a reference to the msbind.dll now I
get a 525 Data Access Error (525 Fehler Beim Dates...)
Can anyone tell me how to track and fix this problem? I am looking at
it as a MDAC problem... downloaded the MDAC component checker, but
finding results hard to interpret. |
|
| Back to top |
|
 | |
External
Since: Jun 25, 2005
Posts: 348
|
(Msg. 2) Posted: Thu Aug 30, 2007 7:06 pm
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
wrote in message
> OK I have a new project created... only two components on the form
> 1) Data Control - no changes to any property settings.
> Connect=Access2000
> 2) Label with datasource=data1 and datafield = Item_Desc (field in my
> datatable)
>
> Data1.DatabaseName = FileName$
> Data1.RecordSource = "Estimate" 'Table Within Database
> Data1.Refresh
>
> Done this millions of times works great for me on my machine. On some
> (but not all) German windows machines it gets a 713 class not
> registered error. So I added a reference to the msbind.dll now I
> get a 525 Data Access Error (525 Fehler Beim Dates...)
>
> Can anyone tell me how to track and fix this problem? I am looking at
> it as a MDAC problem... downloaded the MDAC component checker, but
> finding results hard to interpret.
>
It sounds like you have read this...
http://support.microsoft.com/kb/814707
I would re-investigate this closer. Make sure you have followed all the
steps and reboot, yadda, yadda, ... As this is likely the problem.
It doesn't smell like a MDAC problem, but what the heck, its easy to check.
But instead of trying to isolate the troublesome component, I suggest just
installing the latest 'n greatest MDAC for the platform of interest.
Here's why.
Say you did find a particular component was different - how would you fix
it? Bring in another? The problem is all the components with any one MDAC
package are a unique working set. All MDACs, though labelled by the highest
ADO library they support, contain support for all previous versions as well
as bug fixes, etc. There are also now OS Platform specific (due to the OLE
compoents). Bring in a Win2k compoent to a WinXPSP2 box will likely only
make things worse.
While you are at it, since you are using MSAccess, also download and install
the latest 'n greatest Jet for the target box as well.
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
Note: There are currently no updates for Vista. You cannot install MDAC on
Vista.
If after the install it still has problems then I would go after the VB
runtime on the target box. You can do this in one swoop as well.
http://www.microsoft.com/downloads/details.aspx?FamilyID=bf9a24f9-b5c5...f4-8edd
Carefully note any complaints.
Next would be the VB SP you are using. It should be at least SP5, upgrade
this on the compile box, not the installer.
-ralph |
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 3) Posted: Fri Aug 31, 2007 4:21 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Ralph,
Thank you for your detailed response.... You certainly show knowledge
of this subject.
I have VB6 SP6 running on the compile box. I had already found the
KB article about the MSBIND.DLL and completed that step without
success. It solved the 713 Class Not Registered Issue and lead to the
525 Data Access Error currently unresolved.
I agree with your advice and decided to attack the Jet update
first.... tried this web page
http://support.microsoft.com/kb/913296/en-us
tried to install, but got error messages that the installed languages
disagree. (German vs. English)
I found a page that addresses Jet language (German&Others) problems;
http://www.microsoft.com/downloads/details.aspx?FamilyID=62ef886e-c051...24-9115
Installed download and am waiting for client in Germany to return
after having to reboot client machine.... darn remote software does
not reconnect.
If that does not work, I will turn to the MDAC update...thanks for the
comments on needing coordinated MDAC components. The component
checker tool tells me that I have MDAC 2.7 SP1 running on my compile
box. I think the component checker tool is really for Microsoft in-
house use. I saw several web pages with text to copy and upload into
your windows registery, but that makes me very nervous.
Sorry to post in-progress results... but I will probably forget what I
did and results if I don't. >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Jun 25, 2005
Posts: 348
|
(Msg. 4) Posted: Fri Aug 31, 2007 9:50 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
wrote in message
> Ralph,
>
> Thank you for your detailed response.... You certainly show knowledge
> of this subject.
>
> I have VB6 SP6 running on the compile box. I had already found the
> KB article about the MSBIND.DLL and completed that step without
> success. It solved the 713 Class Not Registered Issue and lead to the
> 525 Data Access Error currently unresolved.
>
> I agree with your advice and decided to attack the Jet update
> first.... tried this web page
> http://support.microsoft.com/kb/913296/en-us
> tried to install, but got error messages that the installed languages
> disagree. (German vs. English)
>
> I found a page that addresses Jet language (German&Others) problems;
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=62ef886e-c051...24-9115
>
> Installed download and am waiting for client in Germany to return
> after having to reboot client machine.... darn remote software does
> not reconnect.
>
> If that does not work, I will turn to the MDAC update...thanks for the
> comments on needing coordinated MDAC components. The component
> checker tool tells me that I have MDAC 2.7 SP1 running on my compile
> box. I think the component checker tool is really for Microsoft in-
> house use. I saw several web pages with text to copy and upload into
> your windows registery, but that makes me very nervous.
>
> Sorry to post in-progress results... but I will probably forget what I
> did and results if I don't.
>
That's fine.
It was stupid of me to give you the English download. I wasn't thinking. (as
you probably guessed english is my only language, well that is, if I want to
be understood without shouting and hand-waving. <g>)
[You haven't mentioned the platforms you are using either as a build box or
the targets. Might have an impact.]
Second, I spent too much time on advising you about the MDAC, instead on the
specific error you were getting. The 525 error is coming from VB. It is
basically telling you that there was an error with a "data access library"
but it was unhandled.
If you update the MDAC and you are still having trouble. Then you probably
need to bracket the point of failure with error handlers. Remember the data
access libraries return errors in collections. For example,
ADO.Connection.Errors, and you have to enumerate the collection to capture
all the errors. Do just accept the first error, subsquent ones if available
may be more meaningful.
Note: it is just possible that there is bad data on those machines.
hth
-ralph >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 5) Posted: Fri Aug 31, 2007 10:26 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
More Detail:.... Running Win XP Pro SP2 on the Build Machine...
Same OS on the target machine in this instance.... keep in mind that
this works on many other German language based computers, just some
don't work...
Also keep in mind, problem is boiled down to a bear minimum... a data
control and a label bound to the data control. Three lines of code
to setup the data control. Nothing else.... I built a special project
with just this one form and did a package and deploy to ship the app
to the target. I don't think the DB file is at fault... have opened
it on the target machine with Access and appears fine.
Installing Jet 4.0 on target & rebooting did not help. Installing
MDAC 2.7 SP1 & rebooting did not help.
>If you update the MDAC and you are still having trouble. Then you probably
>need to bracket the point of failure with error handlers. Remember the data
>access libraries return errors in collections. For example,
>ADO.Connection.Errors, and you have to enumerate the collection to capture
>all the errors. Do just accept the first error, subsquent ones if available
>may be more meaningful.
I am not sure how to do this step....keep in mind only the
datacontrol Access2000 as connect property
I am trapping the error with on error.... msgbox to display the error#
& description, resume next.
I just rebuilt the package and deploy putting all data components in a
subdirectory of the project not the windows\system32 subdirectory....
that did not work, but I did not reboot that step.
Who would you contact, if I am willing to pay to resolve this
situation?? Not doubting your help.... not at all, but this problem
has been dragging for a while.... Now get this, if they format the
hard drive and re-install, the problem goes away. Some customers have
been doing that. >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 6) Posted: Fri Aug 31, 2007 2:18 pm
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Do you think that any of this is related to the control panel's
"Regional and Language Options"?
Maybe adding English as an input language on the target machine?
Reading in book "Internationalization with Visual Basic" by Michael S
Kaplan
"Using VB's Data Controls to Display the Data
Developers often tend to be dismissive of the bound data controls that
come with VB6. I myself do not always dismiss them. However, I find
that these days I can seldom use them because, for the most part, they
are ANSI controls internally and thus like VB do not handle cross-code
page data very well." >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 7) Posted: Fri Aug 31, 2007 4:33 pm
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
>
> I know I am pretty late in asking this, but you posted in a "DAO" group but
> it appears you are actually using ADO? Is this correct?
>
> This a common problem when distributing a "com" application to computers in
> the "wild". It is almost impossible to know exactly what is going on without
> having the computer at hand. Extremely curious that your test app is so
> simple - it seems impossible that it would fail so dramatically and not show
> failure elsewhere as well. Since we know that dotNet beta has likely been
> loaded then removed, one can only wonder what else might have been done on
> these machines.
>
> Sorry I wasn't of much help.
>
> -ralph
Ralph,
You have been more help than you know... what drives me crazy is that
it works on some machines and not on others... oh the life..
I am using the DAO data control.... I just rewrote my simple test to
use an ADO control. I hope to try that early Monday... I am really to
the point of saying it is either a local setting or the dao data
control is causing the problem. Of course, converting the app to ADO
is an incredible amount of work. It would be better to shift to .NET
before rewriting in VB6. It is my own fault for not moving to ADO
before. "if it ain't broke, don't fix it"
Now get this, she installed on another computer at her office in
Vicenza Italy this afternoon (German Speaking Firm) and absolutely no
problem. Working like a champ. The app works on American computers
and even Win Vista. GOD I HATE MY LIFE.
With your help, I think that I have my answer... I don't think paying
a consultant would do anything we have not discussed except verse the
consultant in the issue and have them say "don't do that!".
All my best... you have been a good backstop... I owe you one, if I
can ever help you. I do have a wide range of experience in VB. >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Jun 25, 2005
Posts: 348
|
(Msg. 8) Posted: Fri Aug 31, 2007 5:07 pm
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
wrote in message
> Do you think that any of this is related to the control panel's
> "Regional and Language Options"?
>
> Maybe adding English as an input language on the target machine?
>
> Reading in book "Internationalization with Visual Basic" by Michael S
> Kaplan
>
> "Using VB's Data Controls to Display the Data
> Developers often tend to be dismissive of the bound data controls that
> come with VB6. I myself do not always dismiss them. However, I find
> that these days I can seldom use them because, for the most part, they
> are ANSI controls internally and thus like VB do not handle cross-code
> page data very well."
>
You are correct that many are dimissive of using bound controls. I'm not one
of them. As long as one appreciates that it is a "wrapper" and as such
always presents as part of its second-level-of-indirection additional
opportuities for failure.
Also I take no offense at you wanting to seek additional help. (A bit
disappointed, in fact, that more people haven't responded to your post.) You
can get still get paid support from MS, but they are slow in responding to
"older" technologies. I don't know how things work over there. Is is
possible to hire a local consultant or consulting firm at the remote site to
go and piddle with the client's machine. That's what I have done it the past
when things get too exasperating. It wouldn't be cheap.
I know I am pretty late in asking this, but you posted in a "DAO" group but
it appears you are actually using ADO? Is this correct?
This a common problem when distributing a "com" application to computers in
the "wild". It is almost impossible to know exactly what is going on without
having the computer at hand. Extremely curious that your test app is so
simple - it seems impossible that it would fail so dramatically and not show
failure elsewhere as well. Since we know that dotNet beta has likely been
loaded then removed, one can only wonder what else might have been done on
these machines.
Sorry I wasn't of much help.
-ralph >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Jun 25, 2005
Posts: 348
|
(Msg. 9) Posted: Fri Aug 31, 2007 7:17 pm
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
wrote in message
> >
<snipped>
>
> I am using the DAO data control....
>
Dang! I am stupid! You have my permission to start cussing me out.
There are well known issues with DAO components not getting properly
registered on some WinXP machines.
1) Make sure that WinXP SP2 is installed. (SP2 also fixed a different but
related problem with DAO.)
2) Find and re-register "dao360.dll"
Go ahead and re-register any "dao" component you find while your there.
<g>
ADO is perhaps a more stable environment - it certainly has the greater
number of fans. But it may not be worth it to rewrite your entire
application. Especially if you are using MSAccess/Jet as a local database.
DAO/Jet has definite advantages over ADO - *In that configuration*. <g>
I had to add the asterisks before someone else came in and flamed me for
suggesting DAO over ADO. <g>
Try it and let me know what happened.
-ralph >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 10) Posted: Mon Sep 03, 2007 4:15 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
DAO....I thought I had made it clear.... let me take the blame.
Yes .... it is the DAO Control causing the problem... I just uploaded
a test program using the ADO control on to her computer. The ADO data
control and ADO TrueGrid work on her system....
That does not solve my problem, but at least explains it. There is
much work to change the app from the DAO data control and DAO truegrid
to the ADO complements.
Her German system is running Xp SP2.... still the dao360.dll component
could be at fault.... I have re-registered this component previously
without effect.
The language and regional settings have a very important impact on
this issue. We are in the process of getting the region and language
settings from a "working" German system to copy to the non-working
system.
I am at the end of my rope on this issue. But you have been of
considerable help. I will post more as available. >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 11) Posted: Mon Sep 03, 2007 4:32 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
It does not solve the problem of why reinstalling the MDAC and Jet4
engine did not solve the problem if you are correct. The one thing
that I do know is ..... formatting the system and reinstalling the OS
cures it every time.
What a horrible user solution for me to recommend.
Many Many Thanks for listening to me.... As I said... I owe you one. >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Jun 25, 2005
Posts: 348
|
(Msg. 12) Posted: Mon Sep 03, 2007 9:51 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
wrote in message
> It does not solve the problem of why reinstalling the MDAC and Jet4
> engine did not solve the problem if you are correct. The one thing
> that I do know is ..... formatting the system and reinstalling the OS
> cures it every time.
>
> What a horrible user solution for me to recommend.
>
Not necessarily. Consider that if it takes something that drastic to make a
simple app work. They were only headed for trouble down the road with
something else.
Tell them, "We are sure lucky we caught this in time." <g>
-ralph >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 13) Posted: Mon Sep 03, 2007 11:03 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Aug 30, 2007
Posts: 12
|
(Msg. 14) Posted: Tue Sep 04, 2007 7:25 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
|
|
| Back to top |
|
| |
External
Since: Jun 25, 2005
Posts: 348
|
(Msg. 15) Posted: Tue Sep 04, 2007 9:38 am
Post subject: Re: 525 Data Access Error - German Version of Windows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
wrote in message
> OK.... we have found something... changing the regional language
> settings to English has eliminated the 3170 ISAM error and the
> software works.
>
> I wonder ... other than switching to a German language based build
> computer if I can somehow get it to work.
>
If you can track it down to a specific "language" problem, eg, "periods
instead of commas", date formats ("12/1/07 vs 1/12/07"), then there are some
conversion routines that always read the local settings and others that
always assume "us".
Depending on the specifics there is always a work-around.
-ralph >> Stay informed about: 525 Data Access Error - German Version of Windows |
|
| Back to top |
|
| |
| Related Topics: | Database Access Crashes on Windows 2003 Terminal Server - I have been running a Microsoft Access 97 application on Windows 2003 Terminal Server for almost a year now, with no problems. About two weeks ago, I started to get the following errors in my event log: Application Error; EventID: 1000 Faulting..
Getting data from Access 2003 in Vb6 with DAO - Is this possible? What version of DAO do I need and where do I get it from. TIA!
Error using DAO access an Access 97 database - URGENT - My VB6.0 app suddenly has problem accessing an Access97 database. The error is "Method or data member not found!" I even reinstalled VB 6.0 but still didn't help! Any help is greatly appreciated! Thanks Bill
Delay in data appearing in access table - I have an app written in VB6. using the DAO 2.5/3.5 Compatability Library I have a problem with a report that collates some data and writes it into a table and then runs a crystal report (v9) to report on the data. Sometimes the report displayed no dat...
Using variables to write data to an Access file - Hi all, I have an MS Access database with just one table. In that table are several dozen columns, each one called Variable1, Variable2, Variable3, etc. Is there any way to use a For/Next loop to write information to this table? For example, if I.. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
