Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!newsfeed.straub-nv.de!news-1.dfn.de!news.dfn.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: =?Windows-1252?Q?E=AE!k_\\/!$$E=AE?= Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Joining MSSQL and Firebird tables Date: Thu, 8 Sep 2011 19:30:26 +0200 Lines: 60 Message-ID: <9cscdkF46dU1@mid.individual.net> References: <9cpk4jF86pU1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=response Content-Transfer-Encoding: 8bit X-Trace: individual.net 8ILVR4L6jFiwykNAiqpfPQpCzz8YxAKRVv5VNScLXdjfcCdtLt Cancel-Lock: sha1:100W3h28WWyrMbu+ebnVY9iCdIQ= In-Reply-To: X-Priority: 3 X-MSMail-Priority: Normal Importance: Normal X-Newsreader: Microsoft Windows Live Mail 15.4.3538.513 X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3538.513 Xref: x330-a1.tempe.blueboxinc.net comp.lang.clipper.visual-objects:1980 Andrej, You do not need to do it with Management Studio. It can be done with a query as well, using OpenRowSet Best (fastest) way for these kind of action always is to do as much as possible on the server side, not inside you code. Here is an article about this: http://tinyurl.com/4dzq6rz Erik "andrej Terkaj" schreef in bericht news:j49v0a$nsd$1@news.siol.net... Hi, Erik ! As I mentioned above my problem can be solved inside a Studio Management. Yes, you are right I used a linked server with a IBProvider (I do not know if it is an ADO.NET driver, probably no). But I would like to have a problem solved inside a VO code --> using Vo2Ado classes. A child table is a large table with aprox. half million records of customers. Any ideas are welcome. Andrej "EŽ!k \/!$$EŽ" wrote in message news:9cpk4jF86pU1@mid.individual.net... > Andrej, > > If there is a ADO.NET provider available, you could try to use the linked > server facilities from MS SqlServer. > Open Management Studio and see under Server Objects - Linked Servers. > > Never done this, but I am pretty sure this works as it can be done with > MySql and Oracle as well. > hth > > Erik > > > > "andrej Terkaj" schreef in bericht news:j47bm1$as3$1@news.siol.net... > > I am trying to join (relate) two different SQL tables MS SQL one (master) > and Firebird /Interbase/MySQL as child one using Vo2Ado 2.8 -> Adoserver > Connections to a single tables/databases are not a problem. I tried also a > MS function known as "linked server". No success. Debuging a VO code it > always > stops me when I try to initialize Adoserver class. Any ideas ? > > TIA > Andrej Terkaj > > >