February 20, 2006 at 6:48 am
I use following script tio create a linked server connection:
sp_addlinkedserver @server = 'Basel2',
@srvproduct = '',
@provider = 'Sybase ASE OLE DB Provider',
@datasrc = 'SO_DEST_07',
@location = '',
@provstr = '',
@Catalog = 'HYBO'
EXEC sp_addlinkedsrvlogin 'Basel2', 'false', NULL, 'USERID', 'USERPW'
When I run this script on my PC and try to open the linked server in EM I receive the following message:
Error 7302: Could not create an instance of OLE DB provider 'Sybase ASE OLE DB Provider'
OLE DB error trace [Non-interface error: CoCreate of DSO for Sybase ASE OLE DB Provider returned 0x80040154
When I run this script on the server and try to open the linked server in EM I receive the following message:
Error 7399: OLE DB provider 'Sybase ASE OLE DB Provider' reported an error. Access denied.
OLE DB error trace [OLE/DB Provider: 'Sybase ASE OLE DB Provider' IUnknown::QueryInterface returned 0x80070005: access denied.].
When I create this linked server manual in EM, it works fine. When I compare the properties of the scriptcreated and the manual created linked server I see no difference.
We use Sybase ASE OLE DB Provider version 02.70.0001, Windows 2003 and SQL Server 2000 with sp4.
I have Googled the internet and found several hits on these errors, also a problemsolver for a similar issues with OLE DB Provider for Microsoft Jet. These hits gave me no solution for this problem: why there is a difference between scriptcreation and manual creation.
Anybody can give me a hint on info on this?
Greetz,
Hans Brouwer
February 20, 2006 at 8:07 am
Might try tracing and see if EM does something else.
February 21, 2006 at 8:28 am
Tnx Steve,
I followed your suggestion and found the difference. It turned out the spaces in the @provider name where removed...
Funny though, that in EM the name was WITH the spaces again....
Tnx again,
Greetz,
Hans Brouwer
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply