Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database Connector Error IBM DB2

I'm trying to create a new OLE DB data connection for IBM DB2 using a data link that I know works.

If I open my udl file in notepad it looks like this:

[oledb]

; Everything after this line is an OLE DB initstring

Provider=IBMDADB2.DB2COPY1;Password=MyPassword;Persist Security Info=True;User ID=cqdbuser;Data Source=Beta01;Location=RationalDB;Extended Properties=""

When I click Finish, I get the following error from Crystal Reports:

Database Connector Error: 'Error Code: 0x800a0cc1

Source: ADODB.Fields

Description: Item cannot be found in the collection corresponding to the requested name or ordinal.

I get the same error if I try to build the connection manually (without the data link). I am using Crystal Version 11.0.0.1282. Any ideas?

Thanks

Not what you were looking for? View more on this topic or Ask a question