Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveySQLHelper Ambiguous ErrorSQLHelper Ambiguous Error
Previous
 
Next
New Post
4/12/2007 3:02 PM
 
I think this error I'm getting might actually be indicative of a larger problem. Anyone else seen this error in relation to the Survey module or otherwise?

Compiler Error Message: BC30560: 'SqlHelper' is ambiguous in the namespace 'Microsoft.ApplicationBlocks.Data'.

Source Error:

Line 108:
Line 109: Public Overrides Function GetSurveys(ByVal ModuleId As Integer) As IDataReader
Line 110: Return CType(SqlHelper.ExecuteReader(ConnectionString, DatabaseOwner & ObjectQualifier & "GetSurveys", ModuleId), IDataReader)
Line 111: End Function
Line 112: Public Overrides Function GetSurvey(ByVal SurveyID As Integer, ByVal ModuleId As Integer) As IDataReader


Source File: C:\Inetpub\hco\App_Code\Survey\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb Line: 110

Running DNN 4.5 with Survey 4.0.6 with the posted fix for DNN 4.5

thanks,

-eric
 
New Post
4/12/2007 3:09 PM
 

You can get that error when you have compile errors. I usually just close my Visual Studio and re-open it when I get that error. As far as the fix, it is best to just open the one file in notepad, make the change and save the file. there is no need to use Visual Studio or to recompile the module.



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
4/12/2007 3:34 PM
 
Thanks for the quick reply Michael.

I'm not actually compiling from VS at all. I just install the Survey module and this error is generated. I can make it go away by renaming the mentioned file, but then I can't get anything to display from a Survey module (obviously) since it can't connect to the DB.

I guess I'm not quite sure what changes need to be made. Where is this code for the SQLHelper located? I'm assuming it's in the core somewhere, which should be untouched on this installation as far as I know.

thanks again,
-eric
 
New Post
4/12/2007 3:52 PM
 

Try this:

Check your /bin directory and make sure you don't have these files in there. If you do remove them:

bin\DotNetNuke.Modules.Survey.dll
bin\DotNetNuke.Modules.Survey.SqlDataProvider.dll

If that doesn't work try this:

1) Uninstall the Survey Module
2) Remove the survey module directory (and all the files) from the App_Code folder and the DesktopModules folder
3) Re-instal the Survey module
4) Open the survey.ascx.vb file and replace the code needed to make it work with DNN 4.5
5) Save the file

I suspect you have an extra version of the file in there



Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
4/12/2007 3:56 PM
 
Michael,

I've actually repeated that whole process at least 3 times now with the same results.

This was a 3.x DNN install that has been upgraded several times now.

I think that this topic might hold some helpful ideas.

http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/118/threadid/123784/scope/posts/Default.aspx

I just need some time to drill down into the old vb and dll files as well as checking the config file lines from App_Code that apparently should have been added.

I'll report back on my progress.

thanks,
-eric
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveySQLHelper Ambiguous ErrorSQLHelper Ambiguous Error


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out