Physical Database Not found......
I'm sorry - I should have been more clear. Is the _name_ of the ODBC
connection the same on all the stations? The name of the connection that
the report is created with is hardcoded into the report, so if the name of
the connection is different on some computers, that could explain it. I
don't know how Macola uses the connection, but with the program we use, the
dsn name can be unique for each computer, so we've had to develop a way to
pass the dsn name to crystal through the program we run the report from and
override whatever default crystal has from the machine it was developed on
with the current connection name.
Until we had this process developed, a workaround we used was to go into the
report being developed and go to database<verify database and delete the
driver name, so if it said mydsn.dbo.table, we'd take off the mydsn. to make
it dbo.table, and that took care of the problem.
Quote:
> The ODBC connection is the same one that the Macola client uses to connect
> to SQL. Macola works for the user so I know that the ODBC connection is
> functioning and it is the same ODBC connection for all Citrix users which
> some can run the compiled reports.
> > Scott,
> > Maybe your ODBC drivers aren't working correctly on some of the
computers?
> > Have you verified that those computers have an ODBC driver set
correctly,
> > and that they can connect to the database? We use DSNs, and have had
> > similar problems if we try to run a report on a computer that may be
able
> to
> > connect to the database fine with other programs, but that has the DSN
> named
> > differently, so Crystal doesn't know where to look for the database.
> > > I am getting a physical database not found error message when trying
to
> > run
> > > a compiled report. This is occurring on a NT 4.0 TS with Citrix MF 1.8
> but
> > > only for certain users. All users have the compiled report shortcut in
> > their
> > > start menu programs. The compiled reports work for some users and not
> > > others. A user running the same compiled report stored on their pc can
> run
> > > it but when logged into Citrix the user will get the error. We are
> running
> > > Macola 7.5 with SQL 2000 connecting via an ODBC connection and Crystal
7
