Using existing Connection to SQL-Server in Crystal Report 6 OCX
The OCX cannot do this. With Crystal 6, the only way to do this is with the API
calls. There is a call PELogonSQLServerWithPrivateInfo. This will allow you to
use an existing ODBC connection to your database.
The other suggestion would be with a newer version of Crystal Reports. This way
you can use Active Data to use against your reports. This way you can have your
application run the Stored Procedure and then populate a Data Object with the
recordset. The report will then be able to connect to the Data Object instead
of the database.
To reply, remove nospam from the address.
> Hi everybody,
> I have a stored procedure that creates a temporary table. Now I want
> to get the data from this table and use it with Crystal Report 6. The
> problem is, that everytime I try to this, the OCX opens a new connection
> to SQL-Server. But the temporary table is only available for the connection,
> that created it.
> Does anybody have an idea, to say Crystal Report not to open a new
> connection everytime or better use the existing connection?
> Enrico Ldecke