How can I connect to MSSQL With ICE?

[victorchan]

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!

[bernard]

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