Sybase ASE 12.5 Linked Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Sybase ASE 12.5 Linked Server

Author

Topic

mdx
Starting Member

1 Post

Posted - 2009-08-13 : 06:34:13

Hi all

I've created a linked server in SQL 2005 to a Sybase ASE 12.5 server, and I'm having very weird problems.

I cannot do straight SELECTs, DELETEs, INSERTs etc. on the linked server, as they give me this error:

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Sybase.ASEOLEDBProvider" for linked server "LINKEDSERVER" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7306, Level 16, State 2, Line 1
Cannot open the table "database.schema.table" from OLE DB provider "Sybase.ASEOLEDBProvider" for linked server "LINKEDSERVER". Unknown provider error.

The even more weird thing is that if I run it a second time, I get a different error:

Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IGetDataSource") from OLE DB provider "Sybase.ASEOLEDBProvider" for linked server "LINKEDSERVER".

Why would this be happening?

I have found a workaround though...using the OPENQUERY function. This proves to me that my linked server must be set up correctly.

I can do anything using OPENQUERY, but I would really like to be able to do straight queries (ie. LINKEDSERVER.DATABASE.SCHEMA.TABLE) as they seem like less effort.

Any ideas would be greatly appreciated.

Regards

surenrockz
Starting Member

1 Post

Posted - 2009-08-30 : 21:10:40

Hi MDX,

I have seen this behaviour before. I am sure that the providers that you are using are resulting in the havoc. Can you tell me what providers do you use? I use the DataDirect SYBASE ADO provider and i have never see any problems since then!

Cheers
Surendra Chaturvedula

-- Surendra

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-08-30 : 21:44:58

Refer to this document:
http://www.sybase.com/content/1029118/1029118.doc

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources