Hi,

 

We have an urgent issue related to Crystal Report in our application. We want to use ODBC connection for connecting to the SQL server instead of currently used OLEDB connection, to make the connection dynamic. We have created the DSN for the server connection and also mapped the report to the created DSN.

 

When we run the report in the crystal report environment, it runs fine. But when we try to run the same through our VB.NET application, it asks for the User Id and Password for SQL Server authentication which is already provided in the DNS. And, even after entering the required details, we are unable to get the report displayed and the control is redirected to the same page.

 

Any inputs for the above issue will be highly appreciated