quick start mediator help - xharbour

Claudio

why dont you try SQLRDD from xharbour.com.
with SQLRDD you dont need to setup an intermediate server, and sqlrdd access
all major databases from market

you can get an demo on www.xharbour.com

Regards
Luiz

Luiz Rafael Culik wrote:

> why dont you try SQLRDD from xharbour.com.
> with SQLRDD you dont need to setup an intermediate server, and sqlrdd access
> all major databases from market

SQLRDD is very interesting, but is not what i need.

I don't need a tool to access to SQL engines from xHarbour,
but a tool to share my Clipper/xHarbour/Xbase++ tables with
other languages and com interface of mediator is perfect.
Really useful for me is the Delphi compatibility too.

Many thanks
Claudio

Claudio
>
>> why dont you try SQLRDD from xharbour.com.
>> with SQLRDD you dont need to setup an intermediate server, and sqlrdd
>> access all major databases from market
>
> SQLRDD is very interesting, but is not what i need.
>
> I don't need a tool to access to SQL engines from xHarbour,
> but a tool to share my Clipper/xHarbour/Xbase++ tables with
> other languages and com interface of mediator is perfect.

Tables created with sqlrdd can e acessed from any development language with
out problem

Regards
Luiz

Dear Claudio Driussi:

"Claudio Driussi" <claudio.driussi@libero.it> wrote in message
news:fnfner$mq7$1@aioe.org...
> Luiz Rafael Culik wrote:
>
>> why dont you try SQLRDD from xharbour.com.
>> with SQLRDD you dont need to setup an
>> intermediate server, and sqlrdd access all major
>> databases from market
>
> SQLRDD is very interesting, but is not what i need.
>
> I don't need a tool to access to SQL engines from
> xHarbour, but a tool to share my Clipper / xHarbour
> / Xbase++ tables with other languages

You might find it useful also to make your own xHarbour OLE
server, allowing access to these tables by other languages, just
as xHarbour can call Excel.

<QUOTE>
Luiz
>>> xHarbour Builder has full support for exporting and
>>> xHarbour code as COM Servers without any code
>>> modifications.

Brian
>> Where's the "how-to" docs? I tried searching xhdn....

Ron Pinkas
> Look at \xhb\samples\SampleOleServer.prg
<END QUOTE>

David A. Smith

N:dlzc D:aol T:com (dlzc) wrote:
>> I don't need a tool to access to SQL engines from
>> xHarbour, but a tool to share my Clipper / xHarbour
>> / Xbase++ tables with other languages
>
> You might find it useful also to make your own xHarbour OLE
> server, allowing access to these tables by other languages, just
> as xHarbour can call Excel.

Yes, can be a solution, xHarbour is really powerful.
But this mean a big work if i want to remap the full
xHarbour behavior into com.

Mediator already did it. So now i'm searching a quick
way to add functionality to it.

Or in alternative a open source solution which already
did much of work needed. ;-)

> <QUOTE>
> Ron Pinkas
>> Look at \xhb\samples\SampleOleServer.prg
> <END QUOTE>

I did'nt found it on xharbour distribution, but
i found an article in xHDN. Ok it seems quite easy
to write an ole server.

But the question is still here. There is a brief
tutorial to add udf to mediator before i start
playing with ole server?

Best regards
Claudio

On 27 Gen, 09:28, Claudio Driussi <claudio.driu...@libero.it> wrote:
> N:dlzc D:aol T:com (dlzc) wrote:
>
> >> I don't need a tool to access to SQL engines from
> >> xHarbour, but a tool to share my Clipper / xHarbour
> >> / Xbase++ tables with other languages
>
> > You might find it useful also to make your own xHarbour OLE
> > server, allowing access to these tables by other languages, just
> > as xHarbour can call Excel.
>
> Yes, can be a solution, xHarbour is really powerful.
> But this mean a big work if i want to remap the full
> xHarbour behavior into com.
>
> Mediator already did it. So now i'm searching a quick
> way to add functionality to it.
>
> Or in alternative a open source solution which already
> did much of work needed. ;-)
>
> > <QUOTE>
> > Ron Pinkas
> >> Look at \xhb\samples\SampleOleServer.prg
> > <END QUOTE>
>
> I did'nt found it on xharbour distribution, but
> i found an article in xHDN. Ok it seems quite easy
> to write an ole server.
>
> But the question is still here. There is a brief
> tutorial to add udf to mediator before i start
> playing with ole server?
>
> Best regards
> Claudio

sqlrdd and mediator are very similar project
Licenze are different.Mediator require a specal program run on your
server and with sqlrdd is all in your exe
Either can reuse your existing prgdfcdx code via rdd tecnologies

you can use DBF/xHarbour components for Delphi (easy to use wrappers
for about 150 xHarbour and 120 Mediator functions)
http://www.otc.pl/index.asp?s=78&l=2

Massimo,

> sqlrdd and mediator are very similar project

Actually, they have the same goal, but they are built from very
different approaches. SQLRDD does not create a new extra column to
store the result of each index key by default. This forces you to keep
these columns updated from your foreign application. Also, SQLRDD
locks are done in database level, not in middleware level, so it is
possible to share with other native database languages.

Marcelo

Hi Claudio,

Claudio Driussi napisał(a):
> I am trying mediator XHarbour com interface:
>
> It works fine, but i need some extra xHarbour UDF function and
> so i need to compile my own medhbudf.dll.
>
....
> Now the questions are:
>
> - Which free MSVC free tools can i use? Visual C++ Express
> Edition 2005 is enough or i need the Windows platform SDK too.
>
> - There are some other lighter free MS tools which can i use?
>
> - Which version of xHarbour can i use? precompiled VC binaries?
> Borland binaries? or source code.

To produce medhbudf.dll you can use any compiler/linker supported by
xHarbour and capable to produce DLL file. One of them is mentioned the
Visual C++ Express available from:
http://www.microsoft.com/express/vc/

You can also use Borland C++. You must remember to link harbour.lib
compiled with the same compiler which you use for medhbudf compilation.

If you still have problems, send me your medhbudf.prg, tell what version
of xHarbour you use and we will generate medhbudf.dll for you.

Regards,
Jacek

Marcelo Lombardo napisał(a):
> Massimo,
>
>> sqlrdd and mediator are very similar project
>
> Actually, they have the same goal, but they are built from very
> different approaches. SQLRDD does not create a new extra column to
> store the result of each index key by default. This forces you to keep
> these columns updated from your foreign application. Also, SQLRDD
> locks are done in database level, not in middleware level, so it is
> possible to share with other native database languages.
>

Just the clarification for thouse who are interested in the subject.
Mediator locks records both in database and in Mediator server. Database
locks allow for effective data sharing with non-xHarbour SQL
applications while Mediator server locks give us 100% Clipper/xHarbour
lock compatibility which is not possible otherwise.

Regards,
Jacek