Hi Peter

What application do you want to consume the ADO provider in? Reason I ask is because each one seems to have it;s own little intricacies about config files to change.

As a starting point, have you looked at the following blog post: http://www.k2underground.com/blogs/pitchblack/archive/2010/05/07/manually-installing-the-sourcecode-data-source-in-ssrs2008-and-windows-server-2008.aspx

While that post is specific to SSRS, the list of assemblies should be what you need, regardless of what application is consuming the ADO provider. As for modifying config files, that depends on the app.

Did you manage to get this figured out?

I do see SourceCode.Data.SmartObjectsClient in GAC on the non-K2 Win2003 32-bit server.

Update 4/10/12:

I can use SmartObjects Tester ADO Query on the server without Blackpearl server component installed.

Problem still exists with ASP .NET not able to find this provider name during runtime.

Copied SourceCode DLL files to C:WindowsMicrosoft.NETassemblyGAC_MSIL, still not working (and on Blackpearl server these DLLs do not sit in NET40 GAC)

        <asp:SqlDataSource ID="srcActivity" runat="server"
            ConnectionString="Port=5555;Server={BP_Server};SmartObjects=Activity_Instance_Destination"
            ProviderName="SourceCode.Data.SmartObjectsClient"
            SelectCommand="SELECT ProcessInstanceID ProcInstID, ActivityInstanceID ActInstID, ActivityName Name,
            Status, Final_Action FROM Activity_Instance_Destination.List " >
        </asp:SqlDataSource>

Now it seems the common thing is that this might require VS2010 to be installed on the server for it to work... that's the only thing missing on this server.

http://help.k2.com/en/kb000192.aspx  doesn't say anything about special deployment.