I have issues with connection in application that uses Crystal Report. Issue occurs when CR component initializes connection to database.
Application crashes at that point.
But when I initialize connection to some directory on server via remote desktop before application starts, then it connects to database successfully.
In our project I am using 'CrystalReport' object for report generation.
Or connection string looks like
CR_Object.Connect = "DSN=" & gServerName & ";UID=" & gUserName & ";PWD=" & gUserPass & ";DBQ=" & gDatabaseName
with appropriate values.
Application connects successfully with the same connection string.
I tried to fix this issue using LogOnServer(dll As String, server As String, database As String, userid As String, Password As String) with 'pdsoledb.dll' passed as first argument, but I could not find appropriate dll implementation.
How can I fix this issue with connection to database ?