To use the SmartObjects with the SQL Data Provider, you need to register the following .NET DLLs in the GAC (Global Assembly Cache) on the machine:

SourceCode.Data.SmartObjectsClient.dll
SourceCode.Categories.Client.dll
SourceCode.HostClientAPI.dll
SourceCode.Framework.dll
SourceCode.SmartObjects.Client.dll
SourceCode.SmartObjects.Management.dll

You must also add the following entries to the machine.config:
(C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config - for example)

<configuration>
<configSections>
...
<section name="SourceCode.Data.SmartObjectsClient" type="System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
...
<configSections>
<system.data>
<DbProviderFactories>
...
<add name="K2 SmartObjects Data Provider" invariant="SourceCode.Data.SmartObjectsClient" description=".NET Framework Data Provider for K2 SmartObjects" type="SourceCode.Data.SmartObjectsClient.SOClientFactory, SourceCode.Data.SmartObjectsClient, Version=4.0.0.0, Culture=neutral, PublicKeyToken=16a2c5aaaa1b130d" />
...
</DbProviderFactories>
</system.data>
....
</configuration>

- Sam

---

--------------------------------------------------------------------------------
The statements and opinions made in my postings are my own, and do not reflect the opinions of SourceCode Technology Holdings, Inc. or its subsidiaries. All information is provided as is with no warranties, express or implied, and grants no rights or licenses.