Smart objects for connecting to Oracle

Have a look at the following:

http://www.k2underground.com/k2/ProjectHome.aspx?ProjectID=51 

Hi,

    We have loaded the DynamicOracleService DLL and are now trying to Register a new service using the K2 BrokerManagement.exe. The connection string is not working and looks wrong when compared to those used by SQLSPServices which we also use. Do we need oracle client installed on the K2 Server where the DynamicOracleService DLL is installed? There are very few instructions provided and values like GUID and potential other components like Oracle client are not referenced or provided, but it is unknown if a specific one is needed. Please help.

Hi,

I would add a few points to tlacreta's post.

On registering the new service, we get the error "Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified." This is a known error when accessing Oracle. I found that this error is independent of the connection string provided.

On searching through other forums, I found that 1 of the possible causes of this error is that the Oracle.DataAccess.dll is not installed on the K2 Server where the DynamicOracleService DLL is installed.This is one such post i found: http://forums.asp.net/p/1324616/2848310.aspx#2848310. Another possible cause is the version of Oracle.DataAccess.dll being different.

Please help us on fixing this issue. Thanks.

http://www.oracle.com/technology/software/tech/windows/odpnet/utilsoft.html

I don't know if that package distributes the DLL but ODP .NET it's a separate download/install.

Dear DC

http://www.k2underground.com/k2/ProjectHome.aspx?ProjectID=51 

I couldnt find this project...can you please share the new location for this project

any updates?

Try here:

http://www.k2underground.com/groups/smartobject_services_for_oracle/default.aspx