Talk About Network

Google





Software > Access External data > Re: Im****t XML...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 4 Topic 10867 of 11376
Post > Topic >>

Re: Im****t XML - Runtime Error 31592

by Peter Doering <nospam@[EMAIL PROTECTED] > Aug 1, 2008 at 01:26 AM

Melissa M wrote:

> I've had a procedure in a db which has worked just fine for the last
several 
> months, up until today. The procedure executes this line:
>     Application.Im****tXML DataSource:="http://"
& P2L_URL & 
> "/P2L_PICK_TO_LABEL.aspx?ORDER_I=" & _
>         Left(Forms!frm_MainMenu.txtSalesOrder.Value, 8) & "&PRINT_I=" & 
> strP, Im****tOptions:=acAppendData
> 
> and I get: Run-time error '31592' [Database Name] has encountered an
error 
> processing the XML schema in file 
> 'P2L_PICK_TO_LABEL.aspx?ORDER_I=29204982&PRINT_I=001'. Illegal xml
character.
> 
> Anybody have any ideas?

The messages of these methods are fairly reliable. Have you checked the
file content on illegal characters? There could be a control characters
outside the sup****ted range:

http://www.w3.org/TR/2006/REC-xml11-20060816/#charsets

Can you open the file with another XML reader like IE or XML notepad? See
http://www.microsoft.com/downloads/details.aspx?familyid=72d6aa49-787d-4118-ba5f-4f30fe913628&displaylang=en

-- 
Peter Doering [MVP Access]
 




 4 Posts in Topic:
Import XML - Runtime Error 31592
=?Utf-8?B?TWVsaXNzYSBN?=   2008-07-31 15:35:00 
Re: Import XML - Runtime Error 31592
Peter Doering <nospam@  2008-08-01 01:26:41 
Re: Import XML - Runtime Error 31592
=?Utf-8?B?TWVsaXNzYSBN?=   2008-08-01 05:47:01 
Re: Import XML - Runtime Error 31592
Peter Doering <nospam@  2008-08-02 22:15:58 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 6:18:49 PST 2009.