Re: OleDbPermission failed



Hi,

You probably need to install jet provider. It is not included in mdac, it is a separate download.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

<elora_c@xxxxxxxxx> wrote in message news:1164059087.241928.251090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am trying to test distributing a Windows application that accesses a
Jet DB (.mdb) database file. On my development box running Windows XP
Pro with Office Pro (and Access) installed, it runs fine. On my test
machine running Windows Server 2003 without Office, it fails with

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

I have checked, and the Jet Database engine is installed on that
machine. It also has Framework 1.1 and 2.0 installed (this app was
developed using 2.0). The code is straight from Microsoft's sample
ado.net application
http://msdn2.microsoft.com/en-us/library/dw70f090.aspx using the OleDb
connector.

I have found many clues on how to fix this problem when using ASP.NET,
but nothing when it occurs in a Windows application. Anyone have any
ideas?

Thanks,
Carole


.



Relevant Pages

  • Re: Application deployment with Jet Database 4.0
    ... Basically you would install Jet in the same way as MDAC: ... exe that will launch the Jet setup before launching your msi. ...
    (microsoft.public.dotnet.framework.setup)
  • Re: Jet 4 Drivers and dBase III Access
    ... Doesn't XP default to Jet 4.0 drivers? ... Can Access 97 use the Jet 4.0 or does it have to be 3.51? ... read and update information in a Dbase III database. ... I even tried the manual install to ensure ...
    (microsoft.public.access.externaldata)
  • Re: Jet 4 Drivers and dBase III Access
    ... You have already installed JET 3.51 by installing Access 97. ... Note that this assumes the service packs for Office 97 are installed. ... read and update information in a Dbase III database. ... The most recent change to the PC was to install Access 2003, ...
    (microsoft.public.access.externaldata)
  • Re: Cannot connect ADO to MS Access 2000
    ... -- and this is especially true of MDB file-based applications. ... Project /References and select "Microsoft ActiveX Data Objects 2.8 Library" ... Microsoft Jet and Replication Objects 2.6 Library ... way because Microsoft can on the fly adjust which exact file to install on ...
    (microsoft.public.data.ado)
  • Re: VB6 app crashes on XP
    ... Thanks, John. ... Do you know how to depermine which version of Jet is loaded on a machine? ... As far as getting an app to work on XP when it was developed on W2k, ... no include MDAC_typ.exe in the install package and manually install ...
    (microsoft.public.vb.database)

Loading