This one is driving me crazy. Cannot find any references to it
anywhere, but I can't imagine that I'm the only one getting it.
Here's what's happening:

Configuration:
VB 6.0 Client
Oracle 8i Server
Crystal Reports 7.0

I am calling an ORACLE stored procedure from within a VB app.
The stored procedure works fine and does what it is supposed to do,
which is to insert a record of values into an ORACLE table. Just after
I run the stored procedure, I then call a crystal report which
accesses selected fields from that table. And that's when this
run-time error appears: "run-time error: 20599", cannot open SQL
Server".

If you have had expereince with this error, please let me know
what you did to solve it. Thank you.

Ray Shindler

I am experiencing the same error calling Crystal
Reports 7.0 from VB6.  I do not get the error if
I specify the connect property of Crystal to
uid=sa;pwd="";

However, I am hoping that there is a better
solution, b/c I don't want to have to update the
password as it changes.

Any better solutions?

Sent via Deja.com http://www.deja.com/
Before you buy.