Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1980
| From | E®!k \\/!$$E® <nospam@nospam.url> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Joining MSSQL and Firebird tables |
| Date | 2011-09-08 19:30 +0200 |
| Message-ID | <9cscdkF46dU1@mid.individual.net> (permalink) |
| References | <j47bm1$as3$1@news.siol.net> <9cpk4jF86pU1@mid.individual.net> <j49v0a$nsd$1@news.siol.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 | Next in thread | Find similar | Unroll 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