I have a problem with CLR stored procedure on SQL Server 2005. I create a stored procedure that opens an ODBC connection and inserts a record in other db (informix). It works fine when I call the store procedure directly. But I put it inside a trigger, and don't work (also make hardcode call of the sp), the problem is in connection.Open(). I probe it on another server and all works fine. The only difference between the servers is that one is 32 bits and the other 64bits (of course the Informix's driver too). Both sql server version are 2005.