"Server has not yet been opened" Error

[blakemckenna]

I'm getting this error message when trying to view a Crystal Report:

"Server has not yet been opened"

Any ideas anyone?

Thanks

[RobDog888]

Yes, you may need to use the method .SetLogonInfo.

[blakemckenna]

Rob,

How do I do that? I'm trying to access this report from a VB app.

[RobDog888]

Ok, are you creating a cr app object and report object? the .SetLogonInfo is a method of the report object.

[blakemckenna]

Rob,

I have the CR viewer control on my form. I created the report from the CR IDE where I attached an Access DB to it with all the fields. I looked at the events of the Report Viewer control and didn't see a .SetLoginInfo event. Am I looking in the wrong area?

[RobDog888]

Yes, add a reference to CRAXDRT I believe it is and create an application and report objects. Then in the report object you will find it there. How are you connecting to your database? ADO?

[blakemckenna]

I'm just using Database Files, and not ODBC. Also, my machine is a standalone machine...I'm not on a server.

[RobDog888]

Database files? ttx cr files you mean?

The method has nothing to do with a server, its just considered that since the database is a "server" to the report which is the client.

[blakemckenna]

From the Database menu in CR, I select "Add database to Report" which brings up the Database Explorer. I select "Database Files".

[RobDog888]

What version of CR is this?

[blakemckenna]

Version 8.5

[RobDog888]

Change the connection in your report via CR to use an ADO connection. Its easier. I have some sample code on the forums already for creating the app object and report object and connecting to both. Make sure you are passing the correct dll driver for your type of connection.

Here is one - http://vbforums.com/showpost.php?p=2157372&postcount=4

[blakemckenna]

Thanks Rob,

I'll give this a try!

-Blake