<div>
<div class="content wysiwyg-content">
Hi,<br />
I have a Crystal Reports 8.5 report.<br />
My DB is MySQL.<br />
When I try to open the report from a VB6 application I'm told my access is denied - no password.<br />
I fill in the password in the ODBC driver DSN configuration form<br />
(and all is good - I test the connection and it works fine) and hit OK and save the report, it doesn't seems to solve the problem.<br />
I build an ADO connection string (my preferred way) but it doesn't seemed to be saved with the report either.<br />
How do I save the ODBC connection details with the report or set it by code?<br />
<br />
Thanx
</div>
</div>


Hi,
I have a Crystal Reports 8.5 report.
My DB is MySQL.
When I try to open the report from a VB6 application I'm told my access is denied - no password.
I fill in the password in the ODBC driver DSN configuration form
(and all is good - I test the connection and it works fine) and hit OK and save the report, it doesn't seems to solve the problem.
I build an ADO connection string (my preferred way) but it doesn't seemed to be saved with the report either.
How do I save the ODBC connection details with the report or set it by code?

Thanx

saving Crystal Report ADO connection string or ODBC connection details with report

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.