[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1039
  • Last Modified:

Error 7399: OLE DB provider 'UNKNOWN' reported an error

We are in the process of migrating our SQL Server from version 7 to 2000 (also from NT Server to WS2003 on another domain/computer).
I added the ODBC data source and registered the linked server.

The strange thing is that while I can use openquery i QA to access the linked server, I get

Error 7399: OLE DB provider 'UNKNOWN' reported an error.  
OLE DB error trace [OLE/DB Provider 'UNKNOWN' IDBSchemaRowset::GetRowset returned 0x80004005:   ].

in enterprise manager and DTS packages.

I have verified the ODBC connection and compared the registration with the existing (working) ones.

Does anybody have a clue to why this happens, and more importanly, how I can fix it?
0
mdn3000
Asked:
mdn3000
1 Solution
 
bragnCommented:
Hi mdn3000

Perhaps this will help you.  Sounds like it.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;814398

Best regards,
bragn.
0
 
mdn3000Author Commented:
Hi bragn,

thanks for the tip, but unfortunately that didn't do the trick.
 
The server I am trying to link is DB2.
I can access it using openquery in QA, but I get the error in enterprise manager/DTS

regards, MDN
0
 
ShogunWadeCommented:
I assume youve installed the latest service pack?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>>I can access it using openquery in QA, but I get the error in enterprise manager/DTS
Don't waste time working in the EM with linked servers. Setup the linked server, and use consistently OpenQuery, that gives best results & stability...

CHeers
0
 
mdn3000Author Commented:
Hello all
I'm sorry for the delay, but I've been down with the flu the last week.

ShogunWade:   Everything is up to date.

angelIII:   Unfortunately OpenQuery only works in QA and _not_ in DTS (exact same code...), and we have alot of DTS packages...

MDN3000
0
 
ShogunWadeCommented:
Are you sure you have the drivers installed on the server?
0
 
mdn3000Author Commented:
Thank you for your suggestions, but I found the problem/sollution!

Knowledge Base-artikel - 329332 deals with another error message, but the cause is the same.
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

"The problem occurs because Microsoft Distributed Transaction Coordinator (MS DTC) is not configured for network access. By default, the network access settings of MS DTC are disabled on new installations of SQL Server 2000 on computers running Windows Server 2003, Enterprise Edition. "

/MDN3000
0
 
ShogunWadeCommented:
cool.   thx for the link to the solution.  
0
 
ShogunWadeCommented:
PAQ + Refund
0
 
CetusMODCommented:
PAQed, with points refunded (500)

CetusMOD
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now