473,788 Members | 2,692 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

cannot read xml file all of the sudden

Hi I am using
ms acces 2002 to read an xml file.
I am using the DOM object in ms access - version xml 4 with service pack 2.
here is the start of the code below. But I am having trouble reading in the
xml file. It seems to be well formed and I was even able to read an earlier
version of the file. This file is a result of being zipped. Could that be
the case? Maybe some invisible chars causing the problem.

How can I test this bit of code. I get no 'Product' nodes returned. Where
as before the file was traversed nicely. It seems the older and new file
were identical, but I cannot read the newer one. What can I do?
The header for both is:

<?xml version="1.0" encoding="UTF-8"?>

Dim test As DOMDocument
Dim nodelist As IXMLDOMNodeList
Dim anode As IXMLDOMNode
Set test = New DOMDocument
test.async = False
test.Load "c:\testxml.xml "

Set nodelist = test.getElement sByTagName("Pro duct")

-------------

Thanks so much

Nov 13 '05 #1
2 2595
On Mon, 09 May 2005 22:07:03 GMT, "Jill" <ji********@hot mail.com>
wrote:

Use a "file compare" utility to find the differences between the two
files. A cheap command line version is already on your machine: run a
command window, and type:
fc /?

-Tom.

Hi I am using
ms acces 2002 to read an xml file.
I am using the DOM object in ms access - version xml 4 with service pack 2.
here is the start of the code below. But I am having trouble reading in the
xml file. It seems to be well formed and I was even able to read an earlier
version of the file. This file is a result of being zipped. Could that be
the case? Maybe some invisible chars causing the problem.

How can I test this bit of code. I get no 'Product' nodes returned. Where
as before the file was traversed nicely. It seems the older and new file
were identical, but I cannot read the newer one. What can I do?
The header for both is:

<?xml version="1.0" encoding="UTF-8"?>

Dim test As DOMDocument
Dim nodelist As IXMLDOMNodeList
Dim anode As IXMLDOMNode
Set test = New DOMDocument
test.async = False
test.Load "c:\testxml.xml "

Set nodelist = test.getElement sByTagName("Pro duct")

-------------

Thanks so much


Nov 13 '05 #2
"Jill" <ji********@hot mail.com> wrote in message
news:ba******** *****@newsread1 .news.pas.earth link.net...
Hi I am using
ms acces 2002 to read an xml file.
I am using the DOM object in ms access - version xml 4 with service pack 2.
here is the start of the code below. But I am having trouble reading in the
xml file. It seems to be well formed and I was even able to read an earlier
version of the file. This file is a result of being zipped. Could that be
the case? Maybe some invisible chars causing the problem.

How can I test this bit of code. I get no 'Product' nodes returned. Where as
before the file was traversed nicely. It seems the older and new file were
identical, but I cannot read the newer one. What can I do?
The header for both is:

<?xml version="1.0" encoding="UTF-8"?>

Dim test As DOMDocument
Dim nodelist As IXMLDOMNodeList
Dim anode As IXMLDOMNode
Set test = New DOMDocument
test.async = False
test.Load "c:\testxml.xml "

Set nodelist = test.getElement sByTagName("Pro duct")

-------------

Thanks so much

Unless you specify the version it's possible you are not using version 4 parser:
Dim test As DOMDocument40
Set test = New DOMDocument40

You'll have to show at least some of the file. Does the latest version of the
file use namespaces whereas the previous ones didn't?

--

Joe (MVP - XML)

https://mvp.support.microsoft.com/pr...8-8741D22D17A5
Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
11367
by: tamimi | last post by:
I have a guestbook form that inserts the fields into an Access Database. The database is residing in the "fpdb" folder that was created by FrontPage. The ASP page that writes the data into the databse uses the "recordset.addnew" method. The code was working fine a couple of weeks ago, and now all of a sudden the error message "Cannot update.Database or object is read-only" pops up. The ASP code or the database was not changed or...
8
5483
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- Hello, I have a very simple problem but cannot seem to figure it out. I have a very simple php script that sends a test email to myself. When I debug it in PHP designer, it works with no problems, I get the test email. If
1
2804
by: teddysnips | last post by:
FRONT END: ACCESS 2000 SP3 BACK END: SQL SERVER 2000 I have been making some modifications to the front end, and a completely unrelated error has occurred. It is unrelated, because the changes I have made have been to neither the form, nor the underlying query, nor to the underlying tables. I have a subform in Datasheet view based on the SQL below. Yesterday, when the user tried to add a new record to the subform, he had a dialog
0
1028
by: Alistair | last post by:
One of my clients recently successfully installed a web application from a WebSetup.msi file created in visual studio. They have uninstalled and upgraded a couple of times since then with a new WebSetup.msi file. (during initial test review phase) For some reason - all of a sudden they can't uninstall the existing web application via programs install/uninstall. It came up with the error. "The installer has insufficient privileges to...
4
1460
by: Johann | last post by:
Dear All All of a sudden, my application is not allwoing me to Debug. Everything was working fine until this morning, however now I cannot debug. I read a lot of threads and articles on this problem, and did everything possible, but my application is still not responding. The error is Verify that you are a member of the 'Debugger Users' group on the server.
0
1569
by: Scorpio1769 | last post by:
I've got a macro on an mde. database that has been working for years. all of the sudden, my user reports to me that upon execution of the macro, he gets the error message "The function you entered cannot be used in this expression. *You may have used a DoEvents,....." This macro fires on the after update event of a combo box and simply creates a purchase order number according to the following.
4
1219
by: NullQwerty | last post by:
I've got some strange activity occuring. We have a development server which mirrors our production server. I have an Active-X .Net dll that sits in a Web Site Folder and is used by an aspx page. All of the sudden the ActiveX component stopped working on the development server but still works on production. I checked the logs, and it was saying File Cannot Be Found when trying to find the .dll, but it is there. It does however work,...
10
4395
by: =?Utf-8?B?V2FubmFiZQ==?= | last post by:
I've been on this for a while, and cannot figure it out. Can someone please help with this message? SessionState can only be used when EnableSessionState is set to true, either in a configuration file or in the page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the <configuration><system.web><httpModulessection in the application configuration. Here is my current...
3
13102
scubak1w1
by: scubak1w1 | last post by:
Hello, Did a search here, manuals and Googled, etc generally, so apologies if I did not find the answer to my issue - that is, I try and 'self help' as mush as I can... I adjusted my postgresql.conf file to set as on 'explain_pretty_print' Now in pgAdmin (1.10.0) when I right-click a database in the 'usual' way, Maintenance, any of the tasks, its starts OK, but I get a dialogue box up every (seeming) operation that the Maintenance is...
0
9498
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10366
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10173
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10110
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9967
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6750
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4070
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3674
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2894
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.