wotan_79@hotmail.com (wotan) wrote in message news:<e5fd30ef.0408100354.6e5ec7a0@posting.google. com>...
> We have a linked server, which worked fine, but we have just changed
> the collation sequence, in SQL-Server, from
> SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS.
>
> Now trying to use the Linked server, we get the following message:
> "Error 7399: OLE DB Provider 'MSDAORA' reported an error. The provider
> did not give any information about the error. OLE DB error trace [OLE
> DB provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005:
> The provider did not give any information about the error]."
>
> Ha anyone seen this before, because I am not sure why changing the
> collation sequence, would affect the Linked Server

I suggest You check syscolumns for any columns with individually
defined collations. Eventually some columns have different collations,
so JOIN statements will fail.
If there are any, You can change the collation via the "collationid".
To be able to update a system table, you have to use:

exec sp_reconfigure 'allow update','1'
reconfigure with override
[put your sql statement here]
exec sp_reconfigure 'allow update','0'
reconfigure with override