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
<invoice><![CDATA[...here 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