Wednesday, March 7, 2012

server to Sybase ASE 12.5.3 via Sybase OLE DB provider 2.70.00.74 doesn' work.

Hi,
I tried to define a linked server from SQL Server 2005 SP 1 to ASE 12.5.3 via Sybase OLE DB provider 2.70.00.74 (written by DataDirect) as well as Sybase OLE DB provider 12.5.1.510 (written by Sybase). Both linked server doesn't work.
But I am able to define linked server if I use an old version of Sybase OLE DB provider 2.70.00.24.

Here are the error messages I get:

1. ASEOLEDBProvider, first try:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Sybase.ASEOLEDBProvider" for linked server "BUGATTI" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "kunktest1.dbo.kunktable" from OLE DB provider "Sybase.ASEOLEDBProvider" for linked server "BUGATTI". Unknown provider error.
2. ASEOLEDBProvider, second try:
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IGetDataSource") from OLE DB provider "Sybase.ASEOLEDBProvider" for linked server "BUGATTI".
3. ASEOLEDB
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ASEOLEDB" for linked server "BUGATTI2" reported an error. The provider did not give any information about the error.
Msg 7304, Level 16, State 2, Line 1
Cannot connect using OLE DB provider "ASEOLEDB" to linked server "BUGATTI2". Verify the connection parameters or login credentials associated with this linked server.


Has anybody else the same problems ? Is there a solution ?

Could you check if this is a permission problem. Please try to
create a linked server with sa login and check to see if the same error
persists.

Thanks

|||I don't think that it is a permission problem, because I created the 'linked server' with the sa login.
And as I said before I was able to connect to a linked server with an older version (OLE DB provider 2.70.00.24) of the same OLEDB provider and the same properties!
But there we have problems with updates on tables with datetime columns which contains millisecond fractions.

By the way, in the meantime I was able to define a linked server over Sybase OLEDB provider 'Sybase OLEDB Provider for ASE 12.5.1.510'. Instead of using a udl-file (don't know how they should be used, found no docu) I wrote <host>, <port> directly to the datasource field in the 'create linked server' dialog of management studio.
But when I execute
select * from BUGATTI4.kunktest1.dbo.kunktable
(BUGATTI4 is the linked server)
I got following error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "ASEOLEDB" for linked server "BUGATTI4" reported an error. The provider did not give any information about the error.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "ASEOLEDB" for linked server "BUGATTI4". The provider supports the interface, but returns a failure code when it is used.

Auditing on Sybase site shows the following statements:
extrainfo
Login ....
Command Text exec sp_oledb_tables @.table_catalog = "kunktest1", @.table_schema = "dbo", @.table_name = "kunktable"
Logout ....

No comments:

Post a Comment