473,322 Members | 1,690 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQLXMLBULKLOADLib

I have problem with bulk load in my asp.net website. On my local computer
everything works perfectly, while running on server it stops and writes back
some error which makes me crazy:

Unable to cast COM object of type
'Interop.SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class' to interface type
'Interop.SQLXMLBULKLOADLib.ISQLXMLBulkLoad'. This operation failed because
the QueryInterface call on the COM component for the interface with IID
'{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following error:
Neznámé rozhraní (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

I am using type library generated by visual studio 2005, which is connected
to bulk load library xblkld3.dll from sqlxml installation.

Any help please.

Tom Richtr
to********@gmail.com
Nov 7 '06 #1
2 5695
you need to install sqlxml on the server.

-- bruce (sqlwork.com)
"Tom Richtr" <xr******@post.czwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>I have problem with bulk load in my asp.net website. On my local computer
everything works perfectly, while running on server it stops and writes
back
some error which makes me crazy:

Unable to cast COM object of type
'Interop.SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class' to interface type
'Interop.SQLXMLBULKLOADLib.ISQLXMLBulkLoad'. This operation failed because
the QueryInterface call on the COM component for the interface with IID
'{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following
error:
Neznámé rozhraní (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

I am using type library generated by visual studio 2005, which is
connected
to bulk load library xblkld3.dll from sqlxml installation.

Any help please.

Tom Richtr
to********@gmail.com


Nov 7 '06 #2
I did, of course. But there is some other problem. Any clue?

"bruce barker (sqlwork.com)" <b_*************************@sqlwork.compíąe
v diskusním příspěvku news:uU**************@TK2MSFTNGP03.phx.gbl...
you need to install sqlxml on the server.

-- bruce (sqlwork.com)
"Tom Richtr" <xr******@post.czwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>>I have problem with bulk load in my asp.net website. On my local computer
everything works perfectly, while running on server it stops and writes
back
some error which makes me crazy:

Unable to cast COM object of type
'Interop.SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class ' to interface type
'Interop.SQLXMLBULKLOADLib.ISQLXMLBulkLoad'. This operation failed
because
the QueryInterface call on the COM component for the interface with IID
'{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following
error:
Neznámé rozhraní (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

I am using type library generated by visual studio 2005, which is
connected
to bulk load library xblkld3.dll from sqlxml installation.

Any help please.

Tom Richtr
to********@gmail.com



Nov 8 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jamie | last post by:
Hi I'm trying to bulk load an XML document into SQL2000 and no matter what I try the last element in my schema document is not being recognized by the uploader. The error I'm getting is Schema:...
0
by: Ansu | last post by:
Hi All, I am trying to use SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class to upload XML Documents to SQL server's Database Table. The moment I made it as a service I created and started a new Apartment...
3
by: Kiran | last post by:
Hi, I want to back up my data in some table in SQL server and import it back using Bulk Load of SQL server 2K. I can use the following code to backup the data in XML ...
0
by: Kiran | last post by:
Hi, Does some one here know how to trigger export(bulk/non bulk) and use bulk import without having to manually edit the Xsd file before import. BTW I am assuming that XML is the correct choice...
4
by: simon | last post by:
I created a reference in my project to SQLXMLBULKLOADLib. Then I create an instance: SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class bulkLoadObj = new SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class(); ...
3
by: Von Shean | last post by:
I am trying to user Bulk loader component in asp.net. The code runs perfectly fine in a test harness but gives the following error when used in a strong named dll called from asp.net using c#. The...
2
by: Andy Hunt | last post by:
Hi, I am having a problem with SQLXML Bulk Load inside of a web service ( also inside of a basic aspx page). I have a WebMethod in a web service that makes a call to bulk load. This works...
4
by: amjad | last post by:
Hi i have dataset which i write as xml file like ds.WriteXmlSchema(XSDFilename); ds.WriteXml(XMLFilename,XmlWriteMode.IgnoreSchema); then i try to load that file into sql using below code...
0
by: =?Utf-8?B?Sm9iIExvdA==?= | last post by:
I am using BulkLoad from .NET application as follows SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class obj = new SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class(); obj.ConnectionString =...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shćllîpôpď 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.