Effiproz & linked servers

May 24, 2010 at 9:01 AM

I would like to ask what is the preferred way to access, query to other databases like Oracle, MsSql, MySql?
eg. I would like to store and use the result of an oracle query.

Is there any linked server solution or do I need to use the clr stored procedure to access these dbs?
Any samples would be great.

Thanks in advance,

May 24, 2010 at 11:51 AM


 We don't support linked servers. How useful this is as effiproz is mainly an embedded database?  

You may use CLR stored procedures to access other databases. In the future we are planning to support CLR functions to return result sets and that may also help.




May 24, 2010 at 1:56 PM


Thanks for your quick response.
CLR stored proc is ok for me.

By the way, Effiproz seems very promising, and would like to say a big thanks for your and the team's work.

Thanks and regards,