I have an open database statement that seems to work when the first window is opened. I thought that this would keep the database open throughout the application.
Dim dbconn As New SqlConnection
Dim sqlConn As SqlConnection = New SqlConnection("MCLE_SQL2008\MCLE_SQL2008;Initial Catalog=iMIS_MCLE_Prod;User ID=sa;Password=**********")
I have a form that contains a Crystal viewer and a Crystal Report. The report will run correctly, but it prompts for the sa password when you refresh the report manually. If the database is open already, why does it prompt again, and is there a way to eliminate this?