Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1971

Re: Joining MSSQL and Firebird tables

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 E®!k \\/!$$E® <nospam@nospam.url>
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> (permalink)
References <j47bm1$as3$1@news.siol.net>
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 <j47bm1$as3$1@news.siol.net>
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

Show key headers only | View raw


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

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Joining MSSQL and Firebird tables "andrej Terkaj" <aterkaj@task.si> - 2011-09-07 10:38 +0200
  Re: Joining MSSQL and Firebird tables "Willie Moore" <williem@wmconsulting.com> - 2011-09-07 07:36 -0500
    Re: Joining MSSQL and Firebird tables "andrej Terkaj" <aterkaj@task.si> - 2011-09-07 16:25 +0200
      Re: Joining MSSQL and Firebird tables "Willie Moore" <williem@wmconsulting.com> - 2011-09-07 10:45 -0500
  Re: Joining MSSQL and Firebird tables E®!k \\/!$$E® <nospam@nospam.url> - 2011-09-07 18:23 +0200
    Re: Joining MSSQL and Firebird tables "andrej Terkaj" <aterkaj@task.si> - 2011-09-08 10:20 +0200
      Re: Joining MSSQL and Firebird tables "Willie Moore" <williem@wmconsulting.com> - 2011-09-08 07:17 -0500
        Re: Joining MSSQL and Firebird tables "andrej Terkaj" <aterkaj@task.si> - 2011-09-08 16:31 +0200
          Re: Joining MSSQL and Firebird tables "Willie Moore" <williem@wmconsulting.com> - 2011-09-08 10:30 -0500
            Re: Joining MSSQL and Firebird tables "andrej Terkaj" <aterkaj@task.si> - 2011-09-09 12:25 +0200
              Re: Joining MSSQL and Firebird tables "Willie Moore" <williem@wmconsulting.com> - 2011-09-09 08:26 -0500
                Re: Joining MSSQL and Firebird tables "andrej Terkaj" <aterkaj@task.si> - 2011-09-13 16:27 +0200
      Re: Joining MSSQL and Firebird tables E®!k \\/!$$E® <nospam@nospam.url> - 2011-09-08 19:30 +0200
        Re: Joining MSSQL and Firebird tables "andrej Terkaj" <aterkaj@task.si> - 2011-09-09 11:57 +0200

csiph-web