Server has not yet been opened- error message.

[Guest_imported]

-We are using ODBC to create all the SQL Server reports
-When we created the report, the default username and password was “sa” and blank
-We change the odbc and database name within the visual basic application using .SetLogOnInfo and .Tablelocation methods of the crystal object
-If the username and password changes on the database, then we get the ‘Server has not yet been opened’ error message

Can somebody please help?

 

[StevenK]

Through your code you will need to pass the appropriate log-on information - this being user-name and password.
I saw this same error and now let the user enter the appropriate password on starting up the application such that the log-on information ('sa' user-name and entered password) are used for the setting of the database table locations.
Hope this helps.
Steve

 

[NettieCross]

Well, another thing I just now discovered: with an ACCESS database, A VB 6.0 application calling a Crystal Report that has a subreport: in the connection string in the VB app, set your "Persist Security Info =" to FALSE, this will kill the need to pass a username and password, which if you attempt to do that, you will get yet ANOTHER error saying that the program "Could not find installable ISAM" - which drags you violently into a whole nuther world - namely the registry.