Article View: borland.public.cppbuilder.database.ado
Article #2967Re: MS SQL <-> Access replication
From: Max Luzin
Date: Wed, 19 Feb 2003 07:19
Date: Wed, 19 Feb 2003 07:19
17 lines
1886 bytes
1886 bytes
I affraid what it impossible to do it automaticaly, but M$ SQL Server have something like gateways to any OLE DB-accessible DB (and to Access, sure). This stuff named something like 'Linked servers'. I don't remember now does Access is supported in distributed transactions or in distributed queries only. Check it in documentation (MS SQL or in MSDN). You need just to write your own stored procedure to access the Access DB for synchronization with the SQL server DB. The SQL server have schedulling subsystem also. It is implemented by Jobs. You may schedule any your job for the stored procedure periodical run at server side. Check this technique in server docs also. I think it will be better to implement your sinchronization in COM+ object (or in MTS COM object). It is very simple and usual way to inter-DB communication. Max (maksim.luzin@wsy.lt)
Technical Details
Message-ID:
<3e532f46@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e474ecc@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,55f3dcdac3bea33d X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-02-18 23:39:34 PST Reply-To: "Max Luzin" <maksim.luzin@wsy.lt> From: "Max Luzin" <maksim.luzin@wsy.lt> Newsgroups: borland.public.cppbuilder.database.ado References: <3e474ecc@newsgroups.borland.com> Subject: Re: MS SQL <-> Access replication Date: Wed, 19 Feb 2003 09:19:32 +0200 Lines: 23 Organization: Western Shipyard X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.59.13.100 Message-ID: <3e532f46@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1045638982 212.59.13.100 (18 Feb 2003 23:16:22 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail