on 10-01-2008 9:22 PM
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
After changing the datasource location to DB2 Unicode it worked ok.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.