Provider Error: 7347 - unexpected data length

[LilProgrammerGirl]

Hi all,
Does anyone know how to fix this error? I did nothing to my server and it's
been up and running for a year.. and all of a sudden I am getting it while running queries in Query Analyzer and in Local Packages.

Error:

Provider Error:  7347 (1CB3)      Error string:  OLE DB provider 'MSDAORA'
returned an unexpected data length for the fixed-length column
'[MSDAORA].RECORD_TYPE'. The expected data length is 32, while the returned
data length is 16.

The queries that are having problems all have this same format with a linked server and a defaulted value in one of the columns:

select * from openquery(MyServer, '
select Number
[red] ,''Hailey'' as name[/red]
from mytable
')

If I delete out the red line it will run... but they used to work and now they don't. Is there a startup parameter or something I need to do to the configuration in order for my server to recognize the field length?

My server is SQL 2000 with a Service Pack 3....

Any help would be greatly appreciated!!

Thanks,
Hailey