>I have created a Stored Procedure using the .NET SQL CLR Integration. I am trying to make an OleDB connection to a VFP database. I am getting the following error message when executing the Stored Procedure:
>

Bleeding edge, eh? Have you marked the permissions on your assembly:

(from SQL Server mgmt.)

CREATE ASSEMBLY MyAssembly FROM 'C:\MyAssembly.dll' WITH PERMISSION_SET = SAFE | EXTERNAL_ACCESS | UNSAFE

You might also be able to configure via Mscorcfg.msc (Control Panel > Admin > .NET Framework Config)?

I've been meaning to actually try doing something like this a slightly different way - configuring a linked server in SQL to my VFP database/tables.