🚀 go-pugleaf

Tuga wrote:

> I get start to use Midas and i think that it's a great tool for developping
> multi-tier applications.

This subject is better posted in the newsgroup:
borland.public.cppbuilder.database.multi-tier

But now that you are here, some comments. To begin with: I never used
the components or the database you are going to name.

> I've got an app that is installed on diferent computers and each instalation
> of my app access a remote database (MS ACCESS) that is placed in a single
> computer.

So you have a client app.

> I can do this with ODBC programing, i mean, i've got TDataSources, TQuerys,
> DBGrids and so on, in my client app. All i have to do is configure well a
> new ODBC' DSN 

Whatever that would be.

> and share the directory where the database is placed in the
> remote machine, that everything works fine.

That I cannot believe. Sharing a directory in a network ? A client
should not be able to see a database directory on the server.

> This brings me a problem, all the remote users have access to that
> directory, so they can delete the database if they want, or can work
> directly in the database.

What kind of construction is this ? Of course you would not
share a database direcory with clients in a network.

> I want to deny this,

Again: never used MSACCESS and so, but it would be unbelievable
that you had to share directories.

 > so i thought using Midas to resolve this problem.

??????

> I'm using TSocketConnection objects to connect to the Midas' server. 

Did you alreeady use midas? In your first setup you did not name midas.

 > In the
> Midas' server 

Where would that server run ?
Your apps are clients for the midas ?
And midas is then the only client for the database ?

 > i've got a RemoteDataModule with TDataSetProviders and
> TADOQuerys. This works fine, but the SQL string have to be created in the
> TADOQuery of the Midas' server (i think) and i want to create it in the
> client side dinamicaly and pass it to the server, because the SQL query
> depends on user choices, so it can't be static.
> Is there any way to pass SQL strings from the client side to a TADOQuery on
> the server side?

There should be I think.

> Any answer hould be greatly appreciated.

Nice you appreciate my answer..

Hans.