Insert record via NODBC into Linked Server

fabio78
fabio78 Member Posts: 37
edited 2008-11-07 in NAV/Navision Classic Client
Hi all,

it is possible to insert a record into Navision directly from SQL query?
I've created a linked server for my Navision 5.0 sp1 trought SQL Server 2005, I can read data without problem, but when I'm trying to insert a record

insert into OPENQUERY(NAVISION_DB, 'SELECT ID FROM "TEST LS"') values ('20')

I receive this error:
Msg 7392, Level 16, State 2, Line 1
Cannot start a transaction for OLE DB provider "MSDASQL" for linked server "NAVISION_DB".

tanks

Comments

  • bbrown
    bbrown Member Posts: 3,268
    While it is technically possible to insert data directly from SQL, it is not the advised or supported method.
    There are no bugs - only undocumented features.
  • garak
    garak Member Posts: 3,263
    Is your Navision Server the Native Database Server or a SQL Server?
    But note. I would never insert Datas into "hot" tables, because the NAV buisiness logic is not run when you insert records from 3-rd Apps.
    Better, fill a "Work Table" and let the datas there process by NAS (for example create customers, Orders, etc.)

    Regards
    Do you make it right, it works too!
  • fabio78
    fabio78 Member Posts: 37
    I've Navision Native DB.

Categories