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


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

Re: Joining MSSQL and Firebird tables

From "andrej Terkaj" <aterkaj@task.si>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Joining MSSQL and Firebird tables
Date 2011-09-09 11:57 +0200
Organization news.siol.net Planet9 d.o.o.
Message-ID <j4cp39$7i6$1@news.siol.net> (permalink)
References <j47bm1$as3$1@news.siol.net> <9cpk4jF86pU1@mid.individual.net> <j49v0a$nsd$1@news.siol.net> <9cscdkF46dU1@mid.individual.net>

Show all headers | View raw


Thank you Erik for usefull link. I will let you know on my progress 
resolving

Andrej

"EŽ!k \/!$$EŽ" <nospam@nospam.url> wrote in message 
news:9cscdkF46dU1@mid.individual.net...
> 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 | 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