Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.Oledb.OledbConnection'
Hi ,
i am getting the following error
Unable to cast COM object of type 'System.__ComObject' to class type 'System.Data.Oledb.OledbConnection'. Instances of types that represent COM components cannot be cast to types that do not represent COM components; however they can be cast to interfaces as long as the underlying COM component supports QueryInterface calls for the IID of the interface.
Please help
Answers
Correct, if you want to use the connection object in a script, it must be ADO.NET, not OLE-DB, so that means two for you. The alternative is what the other posted attempted, using the connection string from an OLE-DB connection, to initialise a .NET connection object, but with the limitation of no password. if you use only integrated security it is a poissible solution.
All Replies
What kind of operation makes you meet the issue? Are you using a Script Task? What's the code nearby the exception?
- You are I guess trying to use an OLE-DB connection object in a script or similar .NET code. This will not work. Please see this thread - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3482193&SiteID=1
Yes i am using script task, if i use as said in the
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3482193&SiteID=1
i need two connection managers?
Since i am using lookup which is using OLEDB connection?
Please Help,
Tony
Correct, if you want to use the connection object in a script, it must be ADO.NET, not OLE-DB, so that means two for you. The alternative is what the other posted attempted, using the connection string from an OLE-DB connection, to initialise a .NET connection object, but with the limitation of no password. if you use only integrated security it is a poissible solution.
