VB Crystal Report, Error: Server has not yet been opened.

Srinivas Chund
#1 / 9

Error: Server has not yet been opened.

I am using VB6.0, CR 8.0 and ADO.

I create a new report as follows

Set crApp = New CRAXDRT.Application
Set rNew = crApp.NewReport

I open a connection to SQL server using

cnCurr.ConnectionString = "Provider=SQLOLEDB.1;" & _
"Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"Initial Catalog=Customs;" & _
"Data Source=SIASQL"
cnCurr.Open

I then create an ado command 'cmdExports' that selects all fields from a
table.
In the next step I add the database to the report using

rNew.Database.AddAdoCommand cnCurr, cmdExports

When I run this on my machine, it works. When I install it on the user's
machine, it causes an error with the message
"Server has not yet been opened".

What is causing this? Thanks for any help.
-- Manohar

Mon, 14 Feb 2005 00:46:42 GMT

CW
#2 / 9

Error: Server has not yet been opened.

You are probably missing a few DLLs that need to be installed on the client
machine. Did you use PDW or MSI to package and install your VB application?

Quote:

> I am using VB6.0, CR 8.0 and ADO.

> I create a new report as follows

> Set crApp = New CRAXDRT.Application
> Set rNew = crApp.NewReport

> I open a connection to SQL server using

> cnCurr.ConnectionString = "Provider=SQLOLEDB.1;" & _
> "Integrated Security=SSPI;" & _
> "Persist Security Info=False;" & _
> "Initial Catalog=Customs;" & _
> "Data Source=SIASQL"
> cnCurr.Open

> I then create an ado command 'cmdExports' that selects all fields from a
> table.
> In the next step I add the database to the report using

> rNew.Database.AddAdoCommand cnCurr, cmdExports

> When I run this on my machine, it works. When I install it on the user's
> machine, it causes an error with the message
> "Server has not yet been opened".

> What is causing this? Thanks for any help.
> -- Manohar

Mon, 14 Feb 2005 07:58:58 GMT

Sreedha
#3 / 9

Error: Server has not yet been opened.

The reason you get this is you have not used two more
additional property of CRAXDRT viz logonserver and
setlogoninfo.

You have to map the database table by table to the current
databse you are using.

The crystal site has given the complete solution to this.

Quote:

>-----Original Message-----
>I am using VB6.0, CR 8.0 and ADO.

>I create a new report as follows

> Set crApp = New CRAXDRT.Application
> Set rNew = crApp.NewReport

>I open a connection to SQL server using

> cnCurr.ConnectionString = "Provider=SQLOLEDB.1;" & _
> "Integrated Security=SSPI;" &
_
> "Persist Security
Info=False;" & _
> "Initial Catalog=Customs;" & _
> "Data Source=SIASQL"
> cnCurr.Open

>I then create an ado command 'cmdExports' that selects
all fields from a
>table.
>In the next step I add the database to the report using

> rNew.Database.AddAdoCommand cnCurr, cmdExports

>When I run this on my machine, it works. When I install
it on the user's
>machine, it causes an error with the message
>"Server has not yet been opened".

>What is causing this? Thanks for any help.
>-- Manohar

>.

Mon, 14 Feb 2005 12:49:20 GMT

Sreedha
#4 / 9

Error: Server has not yet been opened.

The reason you get this is you have not used two more
additional property of CRAXDRT viz logonserver and
setlogoninfo.

You have to map the database table by table to the current
databse you are using.

The crystal site has given the complete solution to this.

Mon, 14 Feb 2005 12:55:40 GMT

sjp
#5 / 9

Error: Server has not yet been opened.

I use this code before opening the report
' This is required for SQL & mySql, else it will generate "server not opened
error"
CrxApp.LogOnServer "pdsodbc.dll", "ALPHAFILES_SQL", "crystal", "report",
"xxxx"
'CrxReport.Database.Tables(1).SetLogOnInfo "ALPHAFILES_SQL", "crystal",
"report", "xxxx"

hope this helps

Quote:

> The reason you get this is you have not used two more
> additional property of CRAXDRT viz logonserver and
> setlogoninfo.

> You have to map the database table by table to the current
> databse you are using.

> The crystal site has given the complete solution to this.

Mon, 14 Feb 2005 22:04:36 GMT

Linda Peterso
#6 / 9

Error: Server has not yet been opened.

I have had quite a bit of trouble when we set up our clients getting this
message, as well as Physical Database not Found. Dll on Client's machine
was possible, but usually they had Crystal installed, so that was ruled out.

This message was caused because the report was created on YOUR server and
the report was trying to find YOUR server on their machine. Depending on
what dll is used by your report, you need to send the report a SetLogOnInfo
with either Data Source Name (psdodbc used) or Server Name (pdssql used) and
User and Password. I can send you a copy of my Viewer code that checks the
dll and passes the info, if needed.

I use Sql Databases and did not have to set Location. LogOnServer did not
help me.

If you are using a sub-report, it is a little more complicated, but I have
had to do that also.

The above is done after the OpenReport has been done.

--

Linda

Quote:

> I am using VB6.0, CR 8.0 and ADO.

> I create a new report as follows

> Set crApp = New CRAXDRT.Application
> Set rNew = crApp.NewReport

> I open a connection to SQL server using

> cnCurr.ConnectionString = "Provider=SQLOLEDB.1;" & _
> "Integrated Security=SSPI;" & _
> "Persist Security Info=False;" & _
> "Initial Catalog=Customs;" & _
> "Data Source=SIASQL"
> cnCurr.Open

> I then create an ado command 'cmdExports' that selects all fields from a
> table.
> In the next step I add the database to the report using

> rNew.Database.AddAdoCommand cnCurr, cmdExports

> When I run this on my machine, it works. When I install it on the user's
> machine, it causes an error with the message
> "Server has not yet been opened".

> What is causing this? Thanks for any help.
> -- Manohar

Mon, 14 Feb 2005 23:17:02 GMT

Srinivas Chund
#7 / 9

Error: Server has not yet been opened.

It appears that I am missing some dll on the test machine. I can say this
because the report was successfully displayed on another machine that to my
knowledge never had Crystal Reports on it.

Please do send me the viewer code. At this point, I do need all the help I
can get.

Thanks for your response.
-- Manohar

Quote:

> I have had quite a bit of trouble when we set up our clients getting this
> message, as well as Physical Database not Found. Dll on Client's machine
> was possible, but usually they had Crystal installed, so that was ruled
out.

> This message was caused because the report was created on YOUR server and
> the report was trying to find YOUR server on their machine. Depending on
> what dll is used by your report, you need to send the report a
SetLogOnInfo
> with either Data Source Name (psdodbc used) or Server Name (pdssql used)
and
> User and Password. I can send you a copy of my Viewer code that checks
the
> dll and passes the info, if needed.

> I use Sql Databases and did not have to set Location. LogOnServer did
not
> help me.

> If you are using a sub-report, it is a little more complicated, but I have
> had to do that also.

> The above is done after the OpenReport has been done.

> --

> Linda

> > I am using VB6.0, CR 8.0 and ADO.

> > I create a new report as follows

> > Set crApp = New CRAXDRT.Application
> > Set rNew = crApp.NewReport

> > I open a connection to SQL server using

> > cnCurr.ConnectionString = "Provider=SQLOLEDB.1;" & _
> > "Integrated Security=SSPI;" & _
> > "Persist Security Info=False;" & _
> > "Initial Catalog=Customs;" & _
> > "Data Source=SIASQL"
> > cnCurr.Open

> > I then create an ado command 'cmdExports' that selects all fields from a
> > table.
> > In the next step I add the database to the report using

> > rNew.Database.AddAdoCommand cnCurr, cmdExports

> > When I run this on my machine, it works. When I install it on the user's
> > machine, it causes an error with the message
> > "Server has not yet been opened".

> > What is causing this? Thanks for any help.
> > -- Manohar

Tue, 15 Feb 2005 00:54:13 GMT

Srinivas Chund
#8 / 9

Error: Server has not yet been opened.

It appears that I am missing some dll on the test machine. I can say this
because the report was successfully displayed on another machine that to my
knowledge never had crystal reports installed on it. I guess my task is to
identify the missing dll.

And yes indeed, I am using PDW to install the application on the user
machines.
-- Manohar

Quote:

> You are probably missing a few DLLs that need to be installed on the
client
> machine. Did you use PDW or MSI to package and install your VB
application?

> > I am using VB6.0, CR 8.0 and ADO.

> > I create a new report as follows

> > Set crApp = New CRAXDRT.Application
> > Set rNew = crApp.NewReport

> > I open a connection to SQL server using

> > cnCurr.ConnectionString = "Provider=SQLOLEDB.1;" & _
> > "Integrated Security=SSPI;" & _
> > "Persist Security Info=False;" & _
> > "Initial Catalog=Customs;" & _
> > "Data Source=SIASQL"
> > cnCurr.Open

> > I then create an ado command 'cmdExports' that selects all fields from a
> > table.
> > In the next step I add the database to the report using

> > rNew.Database.AddAdoCommand cnCurr, cmdExports

> > When I run this on my machine, it works. When I install it on the user's
> > machine, it causes an error with the message
> > "Server has not yet been opened".

> > What is causing this? Thanks for any help.
> > -- Manohar

Tue, 15 Feb 2005 00:57:31 GMT

Sreedha
#9 / 9

Error: Server has not yet been opened.

Srinivas

There is a list of dll's to be installed on the system and
also npviewer.

I dont have net here else i could give you the entire
list, even npviewer dlls.

For the complete list i would suggest you to log onto the
Crystal site and check out if you have included all the
Dll's in your package.

Hope you are using CRAXDRT.dll, if not mention then it
would be more easier.

Hope this helps you.

Quote:

>-----Original Message-----
>It appears that I am missing some dll on the test

machine. I can say this

Quote:

>because the report was successfully displayed on another
machine that to my
>knowledge never had crystal reports on it.

>Please do send me the viewer code. At this point, I do
need all the help I
>can get.

>Thanks for your response.
>-- Manohar

>> I have had quite a bit of trouble when we set up our

clients getting this

Quote:

>> message, as well as Physical Database not Found. Dll
on Client's machine
>> was possible, but usually they had Crystal installed,
so that was ruled
>out.

>> This message was caused because the report was created
on YOUR server and
>> the report was trying to find YOUR server on their

machine. Depending on

Quote:

>> what dll is used by your report, you need to send the
report a
>SetLogOnInfo
>> with either Data Source Name (psdodbc used) or Server
Name (pdssql used)
>and
>> User and Password. I can send you a copy of my Viewer
code that checks
>the
>> dll and passes the info, if needed.

>> I use Sql Databases and did not have to set Location.
LogOnServer did
>not
>> help me.

>> If you are using a sub-report, it is a little more

complicated, but I have

- Show quoted text -

Quote:

>> had to do that also.

>> The above is done after the OpenReport has been done.

>> --

>> Linda

message

>> > I am using VB6.0, CR 8.0 and ADO.

>> > I create a new report as follows

>> > Set crApp = New CRAXDRT.Application
>> > Set rNew = crApp.NewReport

>> > I open a connection to SQL server using

>> > cnCurr.ConnectionString = "Provider=SQLOLEDB.1;"
& _
>> > "Integrated
Security=SSPI;" & _
>> > "Persist Security
Info=False;" & _
>> > "Initial

Catalog=Customs;" & _

Quote:

>> > "Data Source=SIASQL"
>> > cnCurr.Open

>> > I then create an ado command 'cmdExports' that

selects all fields from a

Quote:

>> > table.
>> > In the next step I add the database to the report
using

>> > rNew.Database.AddAdoCommand cnCurr, cmdExports

>> > When I run this on my machine, it works. When I

install it on the user's

- Show quoted text -

Quote:

>> > machine, it causes an error with the message
>> > "Server has not yet been opened".

>> > What is causing this? Thanks for any help.
>> > -- Manohar

>.

Tue, 15 Feb 2005 16:48:45 GMT