🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.nativeapi
Article #11123

Working wih Midas.

#11123
From: Tuga
Date: Sat, 28 Feb 2004 15:25
26 lines
2184 bytes
Hi every1.
I get start to use Midas and i think that it's a great tool for developping
multi-tier applications.
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.
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 and share the directory where the database is placed in the
remote machine, that everything works fine.
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.
I want to deny this, so i thought using Midas to resolve this problem.
I'm using TSocketConnection objects to connect to the Midas' server. In the
Midas' server 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?

Any answer hould be greatly appreciated.

Nuno.
Technical Details
Message-ID: <4040b2f3$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10cc67,862b0fb53a0e28f0,start
X-Google-Attributes: gid10cc67,public
X-Google-ArrivalTime: 2004-02-28 07:39:35 PST
From: "Tuga" <nmp@ispgaya.pt>
Newsgroups: borland.public.cppbuilder.nativeapi
Subject: Working wih Midas.
Date: Sat, 28 Feb 2004 15:25:43 -0000
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 213.22.154.160
Message-ID: <4040b2f3$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1077981939 213.22.154.160 (28 Feb 2004 07:25:39 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail