OleDbPermission failed

[elora_c]

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 Markic [MVP C#]]

Hi,

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

 

[elora_c]

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

 

[elora_c]

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

 

[Miha Markic [MVP C#]]

Do you run code locally or from network drive?