January 13, 2012 at 3:39 pm
I have an oledb source which extract data from ORACLE. The query is coming from a variable (by select sql command from variable.
I have one user variable v1 having value 100
The another variable holds the query (string datatype) like:
"select * from test where id = "+@v1+""
I am getting error as:
Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)
Anybody have any suggestion about this error.
Thanks
January 16, 2012 at 8:16 am
The best way to go about these situations is to first try the query without the variable. Then, if it works, substitute the variable in.
From what you've said, it sounds like your problem is more in terms of the query itself, not the variable. Are you sure you've got the right table names, connection info, etc?
January 18, 2012 at 2:35 am
I hope you are aware that an interop is a .net assembly that routes calls from a .net application to a COM component. It does not contain the COM component. The COM component must exist on the machine.
In your case I guess the COM component that you are referencing gets installed with windows messenger/live messenger. If it does not exist on the target machine, you'll get the error you are getting.
More on interops
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply