Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003

    Unanswered: Problem Importing XML Into SQL Server Table

    The project scope is a ebill site. The customer will be able to upload an xml document then run this import process once a month. The element layout is
    <memberid>00-00-000 00</memberid>
    <invoice><![CDATA[ is the statement in html.... ]]></invoice>
    Now in the database I have the invoice element as a text data type, and it works fine.

    Now when I am doing the import process is where I get my error. I am running the import process using a stored procedure and asp. I am getting an error message:
    Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

    [Microsoft][ODBC SQL Server Driver]Timeout expired

    Now this process work fine when I do 3000 records, but when I increase it to 4000 I get the error. Also I have all of my bases cover with setting the connection timeout. I think it is an issue with memory or processing on the SQL Server.

    See the attached code and let me know what you think. Thanks
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts