You can create a Linked Server on your SQL 2000 Server which connects to
your OLEDB/ODBC Datasource. You will find more details in the SQL Books
Online.

--
Regards,
Mandar Naik


This posting is provided AS IS with no warranties, and confers no rights.
"CCA Dave" <davidccagroup-notreally.co.uk> wrote in message
news:bdou0q$otm$1$8300dec7news.demon.co.uk...
> Sorry if this is a real noddy question but how do I update an odbc data
> source (not SQL) from within a trigger?
>
> I have not got much experience of Transact-SQL as you will see.....
>
> What I want to do is something like this:
>
> {code starts
>
> CREATE TRIGGER testupdate ON [dbo].[CCA Group Ltd$Customer]
> FOR INSERT, UPDATE, DELETE
> AS
>
> conn.open "dsn=cca" ' this is an obdc connection to RMS Alpha files
> recordset.open "Select * FROM customers where primary_key = [dbo].[CCA
Group
> Ltd$Customer] primary key "
>
> set customers.address_line1 = [dbo].[CCA Group Ltd$Customer].address1 etc.
>
> code ends}
>
> What I am trying to achieve is to keep an RMS file up to date on our
legacy
> Alpha system when our shiny new SQL server 2000 & Navision application
> updates our master customer list.
>
> Am I doing this the correct way? I looked at tion, but since I only
> expect 10 - 100 records to change per day it seemed like overkill
> (especially as the table structures are quite different).
>
> Any pointers would be useful.
>
>
>
>
>