ODBC Permissions from Custom Data Processing Extension

Hi
I am trying to create a custom data processing extension that queries a Sybase database (ie odbc), then on the basis of this data queries a SQL Server database. However, when I get to querying the Sybase database, the method instantly crashed with a SecurityException "Request Failed." exception being thrown. I have so far being guessing that this is due to Permissions.
I have tried to create a OdbcPermission Permission Set which I have assigned to the relevant code group, and also have put a OdbcPermission attribute at the start of the method which is to access the Sybase database, but to no avail.
Does anybody have any idea what I can do to resolve this problem?
Thanks
Jan
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=72424bb9b1394d278da3c0fb33e5c352
*****************************************Almost certain that it is a Permissions issue now, as I set it to FullTrust and it made a connection to the Sybase database.
Can anybody tell me how to set up the permissions for connecting to an ODBC database for use in a custom assembly?
Would be much appreciated!
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4587
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=b41e9858e9da41d88067b4f8fb5cabe6
*****************************************|||Hi Jan,
the ODBCPermission class is intended for future use when the .NET Framework
Data Provider for ODBC is enabled for partial trust scenarios. The .NET
Framework Data Provider for ODBC currently requires FullTrust permission. At
present, using the OdbcPermission class has no effect. You may also want to
check this MSDN article:
Code access security and ADO.NET
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcodeaccesssecurityadonet.asp
HTH, Robert
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jan Bodey via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:b41e9858e9da41d88067b4f8fb5cabe6@.SQLMonster.com...
> Almost certain that it is a Permissions issue now, as I set it to
FullTrust and it made a connection to the Sybase database.
> Can anybody tell me how to set up the permissions for connecting to an
ODBC database for use in a custom assembly?
> Would be much appreciated!
> *****************************************
> * A copy of the whole thread can be found at:
> * http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/4587
> *
> * Report spam or abuse by clicking the following URL:
> *
http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=b41e9858e9da41d88067b4f8fb5cabe6
> *****************************************