Linked Server

ibrahimovic

Hello everybody !

I repost here because i have navision 3.70 with Navision Database.

I have a problem with Navision DataBase linked with Microsoft SQL Server via ODBC Driver.

Select and update works.

But when i try this :

Code:
DBCC TRACEON(8765)

INSERT OPENQUERY(NAVISION,'SELECT User_ID FROM "User_"')
VALUES('devz')


I get this ](*,) ](*,) ](*,) :

Code:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Serveur : Msg 7399, Niveau 16, État 1, Ligne 3
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft Business Solutions ApS][Microsoft Business Solutions-Navision ODBC Driver]ISAM error ]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowsetChange::InsertRow returned 0x80004005: ].


Have you an idea ?! :-k

Thanks ! [-o<

ibrahimovic

Nobody can help me ? [-o<

Savatage

All I can provide you with is something like this...

http://support.microsoft.com/default.as ... -us;814398

have you searched Microsoft Support more for this error #?