Hi, I'm trying to import csv file but I receive an OleDb exception.
See below for details.

AssemblyVersion: 5.6.2
PortalID: 8
PortalName: Test
UserID: 1
UserName: host
ActiveTabID: 338
ActiveTabName: Home
RawURL: /Home/tabid/338/ctl/ControlPanel/mid/1062/Initial/ExtendedQuestionsDiv/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://192.168.1.4/Home/tabid/338/c...fault.aspx
UserAgent: Mozilla/5.0 (Windows NT 6.1; rv:2.0.1) Gecko/20100101 Firefox/4.0.1
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: 2550c070-e86a-4ed0-bb98-5ea269162ae4
InnerException: Unhandled Error:
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.OleDb.OleDbConnectionInternal..ctor
StackTrace:
Message: System.Exception: Unhandled Error: ---> DotNetNuke.Services.Exceptions.PageLoadException: Errore: non è al momento disponibile. ---> DotNetNuke.Services.Exceptions.ModuleLoadException: Errore: non è al momento disponibile. ---> System.Data.OleDb.OleDbException: Errore non specificato. at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.getImportedData(String filename, String strFileDir, Boolean HasColumnHeader) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, Control ctrl, Exception exc, Boolean DisplayErrorMessage) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc, Boolean DisplayErrorMessage) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc) at DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(PortalModuleBase objPortalModuleBase, Exception exc) at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.getImportedData(String filename, String strFileDir, Boolean HasColumnHeader) at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.ImportList(EventArgs e) at Dataspring.DNN.Modules.OptInEmail.__OptInListImport.lnkImport_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e) at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) at DotNetNuke.Framework.PageBase.OnError(EventArgs e) at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.default_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) --- End of inner exception stack trace ---
Source:
Nome server: Ricky

Hi Scippy,
From the error log I can see that you are using DNN 5.6.2 but I can't tell if your version of Opt In Email is the latest which is 4.3.  For now lets assume you have the latest version of Opt In Email ( if not let me know). One thing that may be worth doing is to see if this error is in any way connected to the structure of the CSV file. Since version 4.0 imports can also come from an excel file, lets try importing from that kind of file and see if you still get the same error.
Thanks

Another thing I would check (assuming you are running on 4.3.x)) is that the import portion of the code now uses a 3rd party control for importing excel files. This control requires that the DotNetNuke site run in "Full" trust and you might be running in Medium Trust. I would check your web.config and search for "Trust Level=" and see what your trust level is set to.

Thanks!

-Chad

Thanks! The problem was caused by AppPool wrong rights!
Now it work fine!
Regards.