Access Data Sources Supported ?

[David4FSU]

Grats to DASP on the ASP.NET 2.0 Testing ! Glad to see it !

Question:

I am tring to set up am Access Datasource (just a test database in my App_Data directory that Visual Studio Sets up)

When I run it locally, works fine. When I publish it to: http://beta-16154.server1.dotnetsandbox.net/

I get this error message:
Retrieving the COM class factory for component with CLSID {2206CDB2-19C1-11D1-89E0-00C04FD7A829} failed with HRESULT: 0x80070005(Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))).

I know in the ASP 1.1 you had to set up the Data Source in the ODBC manager. Is there something similar in 2.0 or is Access not support or perhaps (Gasp) I am doing something wrong ?

Thanks for any insight you can provide,
Dave

[Danny]

That should be fixed now, the permission was too tight on one of the system DLL.

[David4FSU]

That did the trick. Also had to manually copy the MDB to it, looks like the VS 2005 doesn't automatically copy that during the publish.

Thanks for the quick answer http://community.discountasp.net/emoticons/turn.gif

Dave