Unable to get SQL 2005 Linked Servers working with Sybase OLEDB beta

[SQLServer_DBA]

Hi
I am having trouble getting a linked server to sybase
(12.5.4)working from a 64 bit Win2k3 OS (SQL 2005) using the
64 bit OLEDB beta drivers.

I can select integers from the sybase database but get
errors when varchars are being returned?

OLE DB provider 'ASEOLEDB' for linked server 'X'
returned data that does not match expected data length for
column '[ASEOLEDB].col2'. The (maximum) expected data length
is 50, while the returned data length is 51.

Even when I restrict the amount of characters coming back it
give the same error
select * from openquery(TEST_OLEDB, 'select right(col2, 10)
from tablename')
The (maximum) expected data length is 10, while the returned
data length is 11.

Have I missed something in the configuration of the linked
server or the datasouce?

Thanks

[Paul]

Hi

This should be addressed in an upcoming patch - the Provider is releasing
very soon and
should contain a fix for this. (CR 437113). You can try to disable quoted
identifiers on the
data source to see if it works around the problem.

-Paul

<SQLServer_DBA> wrote in message news:460bf780.2e0...@sybase.com...