OleDbPermission failed

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

Miha
Tue Nov 21 01:48:06 CST 2006

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@yahoo.com> wrote in message
news:1164059087.241928.251090@h54g2000cwb.googlegroups.com...
>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
>

elora_c
Tue Nov 21 08:16:15 CST 2006


According to the registry, I have:
HKEY_CLASSES_ROOT\CLSID\{dee35070-506b-11cf-b1aa-00aa00b8de95}\OLE DB
Provider
Microsoft Jet 4.0 OLE DB Provider

Is this what you meant? If not, I couldn't find a separate download
for Windows2003.

Thanks,
Carole

Miha Markic [MVP C#] wrote:
> 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
Tue Nov 21 09:08:17 CST 2006


If I compile the program on the second computer, then it works just
fine. But that compilation doesn't work on the first computer. It
only runs on the computer it was compiled on. Any ideas now?

Thanks,
Carole

elora_c@yahoo.com wrote:
> According to the registry, I have:
> HKEY_CLASSES_ROOT\CLSID\{dee35070-506b-11cf-b1aa-00aa00b8de95}\OLE DB
> Provider
> Microsoft Jet 4.0 OLE DB Provider
>
> Is this what you meant? If not, I couldn't find a separate download
> for Windows2003.
>
> Thanks,
> Carole
>
> Miha Markic [MVP C#] wrote:
> > 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/
> >

Miha
Tue Nov 21 09:52:08 CST 2006

Do you run code locally or from network drive?

--
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@yahoo.com> wrote in message
news:1164121697.191251.83170@m73g2000cwd.googlegroups.com...
>
> If I compile the program on the second computer, then it works just
> fine. But that compilation doesn't work on the first computer. It
> only runs on the computer it was compiled on. Any ideas now?
>
> Thanks,
> Carole
>
> elora_c@yahoo.com wrote:
>> According to the registry, I have:
>> HKEY_CLASSES_ROOT\CLSID\{dee35070-506b-11cf-b1aa-00aa00b8de95}\OLE DB
>> Provider
>> Microsoft Jet 4.0 OLE DB Provider
>>
>> Is this what you meant? If not, I couldn't find a separate download
>> for Windows2003.
>>
>> Thanks,
>> Carole
>>
>> Miha Markic [MVP C#] wrote:
>> > 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/
>> >
>