By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

cannot connect from Crystal Reports to remote DB2

P: n/a
I'm able to connect to a local DB2 database, but unable to connect to a
remote DB2 database from Crystal Reports XI. In the control center I
have no problems connecting to the remote databases. SQLCODE is 30081,
SQLSTATE 8001.

Local DB2 is V8.2.2, remote databases are 7.2 and 8.2.0.
What can I do?

Regards,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: +49 7245 9287-21
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Burkhard Schultheis wrote:
I'm able to connect to a local DB2 database, but unable to connect to a
remote DB2 database from Crystal Reports XI. In the control center I
have no problems connecting to the remote databases. SQLCODE is 30081,
SQLSTATE 8001.

Local DB2 is V8.2.2, remote databases are 7.2 and 8.2.0.
What can I do?


Can you connect to the remote database from the command line, i.e. taking
Crystal Reports out of the picture?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
8.x clients does not support 7.x servers.
But 7.x clients works fine with 8.x servers (expect control center).

-Zahni

Nov 12 '05 #3

P: n/a
Knut Stolze schrieb:
Burkhard Schultheis wrote:

I'm able to connect to a local DB2 database, but unable to connect to a
remote DB2 database from Crystal Reports XI. In the control center I
have no problems connecting to the remote databases. SQLCODE is 30081,
SQLSTATE 8001.

Local DB2 is V8.2.2, remote databases are 7.2 and 8.2.0.
What can I do?

Can you connect to the remote database from the command line, i.e. taking
Crystal Reports out of the picture?


It's solved. But I don't know why. I disabled my firewall. It worked. I
enabled it again and it is still working.

Thank you!

Gre,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: sc********@tde-online.de
Phone: +49 7245 9287-21
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.