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


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

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-07 16:25 +0200
Organization news.siol.net Planet9 d.o.o.
Message-ID <j48004$m46$1@news.siol.net> (permalink)
References <j47bm1$as3$1@news.siol.net> <j47ofk$9hl$1@speranza.aioe.org>

Show all headers | View raw


Thanks for a reply, Willie.
I am still curious, because when I try with a query statement inside 
enterprise manager (Studio Management) connecting MS table and a view that 
is an object in a "linked server" - Firebird it works. The same query 
statement doesn't work with AdoServer. Using "linked server" a connection is 
probably only one.

Regards
Andrej

"Willie Moore" <williem@wmconsulting.com> wrote in message 
news:j47ofk$9hl$1@speranza.aioe.org...
> Andrej,
>
> You can link different databases that use the same connection but I don't 
> believe that you can link 2 databases that use different connections.
>
> Regards,
> Willie
>
> "andrej Terkaj"  wrote in message 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