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?
mdn3000Asked:
Who is Participating?
 
CetusMODConnect With a Mentor Commented:
PAQed, with points refunded (500)

CetusMOD
Community Support Moderator
0
 
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
ShogunWadeCommented:
I assume youve installed the latest service pack?
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.