Read XML from URL in Python and write to Sql Server Database in XML format

Question

I'm trying to read an XML file from a web address and write that file to a Sql Server DB as an XML data-type. I don't want to do any parsing of the XML, just write it like a string to the database. I will be using it to take snapshots every few hours and then use Sql to deal with the information as an XML datatype.

I'm currently receiving below mentioned error:

'IOError: [Errno socket error] [Errno 11001] getaddrinfo failed'

I'm not sure I'm reading the xml file properly (as one single piece of information) - Any suggestions?

import pyodbc
import urllib
xmlpath = "http://www.w3schools.com/xml/cd_catalog.xml"
xmlurl= urllib.urlopen(xmlpath)
xml_as_string = xmlurl.read()


cnxn = pyodbc.connect(
    'Trusted_Connection=yes; 
    DRIVER={SQL Server};
    SERVER=servername; 
    DATABASE=database_name; 
    UID=user; 
    PWD=pass'
) 
cursor = cnxn.cursor()
cursor.execute("insert into table values ('Text', 1, '"+ xml_as_string +"')") 
cnxn.commit()

Instead of posting only the last error, please post the full stack trace. — Pondlife
– Pondlife, Commented Feb 13, 2013 at 17:11
This is a sign of issues with your network, specifically your DNS and has nothing to do with the code you have written. Check if you are able to resolve the domain from the command line (ie, by using nslookup or dig). — Burhan Khalid
– Burhan Khalid, Commented Feb 27, 2014 at 8:05

newfurniturey · Accepted Answer · 2014-02-27 18:04:42Z

1

The [Errno 11001] getaddrinfo failed suggests that you're facing some DNS problems.

Try pinging the 'servername'. A quick fix would probably be to switch from the domain name to the IP address in the 'servername' variable.

Also, try googling for: Errno 11001 getaddrinfo.

edited Feb 27, 2014 at 18:04

newfurniturey

38.6k10 gold badges99 silver badges104 bronze badges

answered Feb 27, 2014 at 8:11

Wojciech Walczak

3,6192 gold badges25 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Read XML from URL in Python and write to Sql Server Database in XML format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related