Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder1.news.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: Wed, 7 Sep 2011 18:23:46 +0200 Lines: 27 Message-ID: <9cpk4jF86pU1@mid.individual.net> References: Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=response Content-Transfer-Encoding: 7bit X-Trace: individual.net XuAvOxmqIqajwdIZpBSHAwmoLWJbh+VyId1iI9sPikjjFNfcVG Cancel-Lock: sha1:Yfe+MV9fpOj98Sp6OLzMKn+2BXs= 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:1971 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