Satya SKJ wrote:
>May check the compatible driver is used for NAVSION and check KBA
>http://support.microsoft.com/kb/818182 fyi.
>> The below works perfectly in SQL 2000.
>>
>[quoted text clipped - 16 lines]
>>
>> /Brian

"hummel" wrote:

> The below works perfectly in SQL 2000.
>
> I have setup a Linked server to Navision 4.01 with a OLE DB provider for ODBC.
>
>
> I get below errors when I do the following:
> EXEC sp_addlinkedsrvlogin 'nav4', 'true'
> Select name from openquery(nav4, 'select navn from country')
>
> Msg 7399, Level 16, State 1, Line 1
> The OLE DB provider "MSDASQL" for linked server "nav4" reported an error. The
> provider reported an unexpected catastrophic failure.
> Msg 7303, Level 16, State 1, Line 1
> Cannot initialize the data source object of OLE DB provider "MSDASQL" for
> linked server "nav4".
>
> Above also happens no matter what I try, can anybody help ?
> (I have also tried to create the linked server with sp_addlinkedserver, this
> dont work either)
>
> /Brian