SEO

#1 (**permalink**) 02-27-2008, 03:48 AM

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: schultheis@tde-online.de
Phone: +49 7245 9287-21

#2 (**permalink**) 02-27-2008, 03:48 AM

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

#3 (**permalink**) 02-27-2008, 03:48 AM

8.x clients does not support 7.x servers.
But 7.x clients works fine with 8.x servers (expect control center).

-Zahni

#4 (**permalink**) 02-27-2008, 03:48 AM

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!

Grüße,
--
Burkhard Schultheis
Tele Data Electronic, Wagnerstr. 10, D-76448 Durmersheim
Email: schultheis@tde-online.de
Phone: +49 7245 9287-21

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

cannot connect from Crystal Reports to remote DB2