Re: Import XML Image Blob Into SQL 2000

Could you please post the minimal repro script and data to show what you are
exactly doing?

Thanks
Michael

"Scott O'Sullivan" <drear80@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uS4kP1VpGHA.3820@xxxxxxxxxxxxxxxxxxxxxxx
I've also tried 'base64Binary' as the data type, going off the types
listed here...
http://www.w3.org/TR/2004/REC-xmlschema-2-20041028/datatypes.html#built-in-datatypes
...but am still having no luck.

Any pointers?

"Scott O'Sullivan" <drear80@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Ot0y38UpGHA.4216@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I want to import an image blob from an XML file into MS SQL 2000. I'm new
to importing XML, so any help on this would be great.

I've followed the procedure from this KB article...
http://support.microsoft.com/default.aspx/kb/316005/en-us

But when I try to execute the VB script I get the error message...
"Error: Invalid character value for cast specification
Code: 80004005"

I think the problem is with the dt:type for the image blob in the mapping
schema file. I've tried using LONGVARBINARY but with no success. If I
remove the image column from the schema, the other columns import fine.

If anyone could shed some light on this for me, it'd be greatly
appreciated.

Thx,
Scott.





.

Relevant Pages

  • Re: Import XML Image Blob Into SQL 2000
    ... I've also tried 'base64Binary' as the data type, ... I want to import an image blob from an XML file into MS SQL 2000. ... schema file. ... remove the image column from the schema, ...
    (microsoft.public.sqlserver.xml)
  • Import XML Image Blob Into SQL 2000
    ... I want to import an image blob from an XML file into MS SQL 2000. ... schema file. ... the image column from the schema, ...
    (microsoft.public.sqlserver.xml)
Loading