Hi!
I’m trying to import Excel file using DotNet component ADODB and I am getting error “The DotNet variable has not been instantiated” on line
lau_ADOConnection.Open(ltx_ConnectionStr,’’,’’,0);
as there are no Constructors parameters for this object, then how should I instantiate it?
I also had the same problem.
Did you got any solution ?
Yes, you have to use ADODB.ConnectionClass. And it has a constructor.
But then I had permission problems to access the file. My current solution is working with Automation, that is running on Client:
CREATE(lau_ADOConnection,TRUE,TRUE);
Probably the DotNet solution can also be fixed by running the DotNet component on Client (RunOnClient = Yes).
I am not sure what are the DotNet advantages on Automation, but Automation can be used in Classic client as well and so it is better to debug it.