Home Help Center

How can I connect to MSSQL With ICE?

HI all,

I am going to use C# with ICE to develop an application run on Window 2003 with MSSQL.

My client side need to pass query to server and receive dataset from server.

But I don't know how to pass dataset to client side In client.ice.

I had study the forums Posts and most of them are related to "FREEZE".
Is that means I can connect to MSSQL by using FREEZE class?

Can i pass Datasets by using ICE?

Can anyone point a way to me to do that?

Thanks a lot!

Comments

  • bernardbernard Jupiter, FLAdministrators, ZeroC Staff Bernard NormierOrganization: ZeroC, Inc.Project: Ice ZeroC Staff
    Freeze helps persist Ice objects (Ice class instances) in a Berkeley DB database, and has nothing to do with passing objects "over the wire".

    > My client side need to pass query to server and receive dataset from server.

    You need define a Slice version of your query and dataset, implement it in your server and use it in your client. For example:

    typedef sequence<string> Rows;

    interface SqlDb
    {
    Rows selectQuery(string query);
    };

    Cheers,
    Bernard
Sign In or Register to comment.