Hi, I am trying to insert data via a linked server into a navision database...
I am using sql server 2000 and am using Navisions C/ODBC driver.
I can query the linked server and pull back data no problem...
But when I attempt the following it all goes wrong :
insert into OPENQUERY(NAVISION_DB,'SELECT Type,Code,Description FROM FDR_Fund_Type')
The following is displayed :
Server: Msg 7399, Level 16, State 1, Procedure NAV_DATE_TEST, Line 33
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].
Any ideas, this is driving me insane!!!