Problem with ODBC (SQL Linked Server)

Ralf

Hi,

i write in SQL Server over an SQL-Linked Server to Navision 3.60 Native DB(with ODBC).
The data record was written also completely in Navision, but
the following Error Message finished my SQL-Stored Procedur:

Der OLE DB-Provider 'MSDASQL' meldete einen Fehler beim Ausführen eines Commit für die aktuelle Transaktion.
DBCC-Ausführung abgeschlossen. Falls DBCC Fehlermeldungen ausgegeben hat, wenden Sie sich an den Systemadministrator.
[OLE/DB provider returned message: No transaction is active.]
OLE DB-Fehlertrace [OLE/DB Provider 'MSDASQL' ::Commit returned 0x8004d00e].

Here the part of the SQL Statement:
DBCC TRACEON(8765)
set @SQLstring = 'insert OPENQUERY(Navision, ''select Date,sTime,eTime,Duration,No'') values ('''+@nDate+''','''+@sTime+''','''+@eTime+''','''+@nDuration+''','''+@nNo+''')'
exec sp_executesql @SQLstring

whats Wrong?

thanx,
Ralf