Inserting from MSSQL to AdvantageSQL

[Sylvor]

Hi,

I have a trigger, which runs on one of my MSSQL tables. It pulls out some data, which I want to then insert into another table; this table is on a separate (Extended Systems) Advantage SQL database.

Currently I have the trigger working fine and inserting the data into a local temporary table as I can't seem to get the link to the Advantage table to work.

--Trigger code and select statements work fine...
FROM INSERTED
INSERT INTO DBTest.dbo.TEMPTEST --This is where I am having the problem
  SELECT code = @stkcode,

The error I get from SQL is "S0002:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DBTest.dbo.TEMPTEST'."

Both databases are on the same physical server.

Any guidance would be appreciated,
Thanks,
David!


Dave Bennett