I seem to be having issues getting your module to be able to connect to an oracle database.  I already have several modules on my system which do support this.  They allow me to enter a connection string or the name of a connection string within web.config.  So, I already have a connection string setup in web.config that I know works.  Let's call it Production.

So, when I enter Production Into the External Connection property for your module and click Generate Column Names, no column names are generated.  So, I checked my site error log and saw the following error message:

 

 

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: c1cdd582-8f10-4b0d-a739-89a274f6fcfe

InnerException: Invalid object name 'MY_TABLE'.

FileName: 

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.OnError

StackTrace: 

Message: DotNetNuke.Services.Exceptions.PageLoadException: Invalid object name 'MY_TABLE'. ---> System.Data.SqlClient.SqlException: Invalid object name 'MY_TABLE'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DataSprings.DNN.Modules.DynamicViews.Data.SqlDataProvider.DataSprings_RetrieveDynamicView(Int32 PortalID, Int32 intTableorQuery, String strTableOrQuery, String LimitResults, String strUserFilter, Int32 intUserID, String strDetailView) at DataSprings.DNN.Modules.DynamicViews.Business.DynamicViewsController.DataSprings_RetrieveDynamicView(Int32 PortalID, Int32 intTableorQuery, String strTableOrQuery, String LimitResults, String strUserFilter, Int32 intUserID, String strDetailView) at DataSprings.DNN.Modules.DynamicViews.Common.GetDynamicViewData(Int32 PortalID, Int32 intTableorQuery, String strTableOrQuery, Int32 TabId, Int32 ModuleID, String strUserFilter, Boolean blnTop1, Boolean blnGenerateColumns, String strPrimaryKey, Int32 intUserID, String strDetailView) at DataSprings.DNN.Modules.DynamicViews.Settings.cmdGenerateColumns_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 ---

 

Can anyone help with this?  I sure am hoping this module can operate with Oracle, as we use DNN for our corporate intranet and most of our inhouse databases are Oracle.

 

HI, this has been fixed in the release version of Dynamic Views but the trial version won't be updated until the end of this week. -- David

Hey all, I am having zero luck at getting DF or DV to connect to an oracle database.  I am completely convinced i've got the right connection string, yet no luck...  Can someone please give me explicit instructions on how to connect to an oracle database?

Hi Kevin,

I know we added enhancements to allow for the "Free Form Query" which should support this... Does your query work under Host/SQL? I believe we discussed this with a client running into the problem this last week and I was letting him know that if its working under Host/SQL then it should work in our module (because we are using the exact same DNN SQL functions).

Thanks,

Chad

This doesn't quite answer my question.  I want to know exactly how its supposed to work.  If I could get a complete rundown of how oracle statements should be able to be run inside of DNN, then I'd be able to figure my situation out from there.