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


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

Re: Joining MSSQL and Firebird tables

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 E®!k \\/!$$E® <nospam@nospam.url>
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> (permalink)
References <j47bm1$as3$1@news.siol.net> <9cpk4jF86pU1@mid.individual.net> <j49v0a$nsd$1@news.siol.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 <j49v0a$nsd$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:1980

Show key headers only | View raw


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®" <nospam@nospam.url> 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
>
>
>

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