cancel
Showing results for 
Search instead for 
Did you mean: 

Database Connector Error IBM DB2

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

After changing the datasource location to DB2 Unicode it worked ok.

Former Member
0 Kudos

Hi Deb

Please let us the know the following information:

1) Do you face the same issue with ODBC or Native connection?

2) Exact version of the Database.

3) What is the version of the driver being used to connect to the database?

4) Have you tried to use the latest drivers of IBM?

Thanks

Poonam Thorat