server is notyet opened problem in crystal report

[bhaskarsurya]

i am using crystal report with vb6 and sqlserver7
my reports are well running on my windows2000 system but on client's win98 system ,they are giving error "server is not yet opened".
i am using this commands while making reports.
Report.SQLQueryString = StrSQLQuery
CRViewer1.ReportSource = Report
CRViewer1.ViewReport

pls help me
regards
manoj

manoj

 

[AlexB1234]

It sounds like you need to open the connection to the database, or specify connection information, i.e. user_id, password, server, etc.

I don't ususally connect through Crystal so I don't know the exact syntax, but I think there's a .LogOnInfo property that you can user to specify that. I think there are also some Methods for establishing the connection.

The reason it works on your machine, is that Crystal opens a design-time connection and uses it when you run the report.

Hope that helps. Good luck.