x64 INSERT and DELETE

[luisalvarado]

Hi.
After installing the latest ESD of the SDK for 64 bit (SDK
15.0 ESD#14), I successfully register a linked server to my
sybase server on my sqlserver 2005 x64. The select command
works great, but I am having problems with the delete and
insert command.

Here I show the messages.

DELETE MSG - There was a recoverable, provider-specific
error, such as an RPC failure.

INSERT MSG - The OLE DB provider "ASEOLEDB" for linked
server "sac02" could not INSERT INTO table "[ASEOLEDB]".
Unknown provider error.

Should I just avoid using this x64 sybase oledb??
Thanks.

[Paul]

Hi Luis,

What syntax are you using?

-Paul

<Luis Alvarado> wrote in message news:48bff1c0.637...@sybase.com...

[luisalvarado]

Hi Paul.
My syntax is:
insert into openquery(MYSERVER,'select * from tempdb..bas')
values (999)
delete openquery(MYSERVER,'select * from tempdb..bas')
update openquery(MYSERVER,'select * from tempdb..bas') set
campo = 9

Also, using the four shema, does not work
(server.db.dbo.table). If is good to you to know, i am
linking to a x86 12.5.3 sybase server.

Thanks.

[Paul]

Hi Luis,

This worked okay on 32 bit MSSQL Linked Server and 64 bit
(I used table with int, varchar, numeric and datetime)

I used 15.0.0.320 Provider, 64 bit. Should be what you're using (check file
version sybdrvoledb.dll)

-Paul

<Luis Alvarado> wrote in message news:48cabe77.11e...@sybase.com...