Hi

Just installed the latest release (4.0.10) on my server and worked great. I uploaded the site to my client's server and I'm getting a compile error -

BC30456: 'ExecuteScalar' is not a member of 'EfficionConsulting.Articles.DataProvider'.


Line 353: Dim gc As Object = DotNetNuke.Common.Utilities.DataCache.GetCache("CategoriesInstalled")
Line 354: If gc Is Nothing Then
Line 355: gc = CType(DataProvider.Instance.ExecuteScalar("Articles_CategoriesInstalled"), Boolean)
Line 356: DotNetNuke.Common.Utilities.DataCache.SetCache("CategoriesInstalled", gc)
Line 357: End If


Source File: c:\websites\58288cff\App_Code\Articles\ArticleDB.vb Line: 355

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433



Any ideas on what might be going on?

Thanks,

Greg

What version of DNN are you running?

This is running under DNN 4.9.1 (upgraded from DNN 3.1)

Greg

Greg,
We're using the DAL II method for Data Retrieval and the ExecuteScalar function should absolutely be part of 4.9.1.

I would have to guess the 4.9.1 upgrade didn't work right or there's something else wrong with the DNN install into which you're installing the module. You might want to try just re-copying all the 4.9.1 code over your install again.

Let me know if you figure it out.

Sorry,

Looks like this was an issue on the hosting side. I reloaded a clean version of DNN and it's all working great now.

Will let you know if we ever get a clue as to what was going on.

Greg

From what we could tell over here, they had an old copy of the base DataProvider class. It has defined the ExecuteScalar function for quite some time (not sure exactly which version, though).

Glad you got it worked out!

for what it's worth, the host my client had selected does not seem to be very .net savvy.

their IIS control panel allows you to select between .Net v1.x and v2.x, however... it does not work correctly. they have to manually intervene to change IIS between .Net versions.

since I was upgrading the site from DNN 3.1 to 4.9.1, it seems that the hosting environment was stuck on .Net v1.x even though I had changed it in the control panel.

thanks and sorry for the bother,

greg