HomeHome Product Discus... Product Discus...SmithCartSmithCartError on Shopping Cart ImportError on Shopping Cart Import
Previous
 
Next
New Post
11/19/2010 7:37 AM
 

Trying to import the sample Smith product import xls and I get this error: Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed

This appears to be a permissions error as far as what I have Googled realted to .NET.

However the Smith documentation prequisites does not state that a "Full Trust" environment is required, we have a medium trust whereby all DNN and all modules are functioning normally.

Any thoughts?

 
New Post
11/19/2010 7:38 AM
 

Also there is not DNN event log posting related to this error.

Dennis

 
New Post
11/19/2010 11:12 AM
 

The cart uses the Microsoft.Jet.OleDb.4.0 DLL to import the xls so make sure that dll exists and its registered on your server.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
11/19/2010 11:16 AM
 

This is not listed in the prerequisites in the shopping cart manual.

 
New Post
11/19/2010 11:43 AM
 

I will make sure it gets added. Thanks for the heads up!

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
11/21/2010 8:48 AM
 

The DLL is installed and registerd as part of the Windows 2003 installation. Apparently another issue.

 
New Post
11/22/2010 12:15 AM
 

The error indicates a permissions issue you should check the permissions on the dll and make sure the account your site is running under has access to that dll


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
11/22/2010 5:36 AM
 

Is medium trust sufficient access?

 
New Post
11/22/2010 11:49 AM
 

In googling the issue and researching the problem its not clear if it requires full trust but as a test can you change you web config to full trust and see if that fixes it. Also in researching the issue I read a few posts about the Microsoft.Jet.OleDb.4 dll not working on a 64 bit server/windows is your server/windows 64 bit?

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
11/22/2010 12:00 PM
 

the server machine key over-rides the web.config and it is medium trust. it is shared hosting.

it is 32 bit win 2003 server.

 
New Post
11/22/2010 6:19 PM
 

Back to your original post in this thread of the error message:

Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed

Im sure this is a permissions issue on the dll as the error states. Since you are on shared hosting there is no way for you to go to the windows folder and check the permissions on the dll you will need to call your hosting service and ask that they give permissions on the required dll.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError on Shopping Cart ImportError on Shopping Cart Import