"List of Values Failure" error in CR

I have designed a Crystal report from an ODBC connection. But recently I was asked to change the connection to JDBC. The data is from an SQL database. I have set the database location to JDBC from crystal report program. Everytime I preview the resuls I get the following error message.

"Prompting failed with the following error message: 'List of Values failure: fail to get values. [Cause of error: Failed to open connection. Failed to open the connection. UNKNOWN.rpt']. Error source: prompt.dll Error code: 0x8004380D."

Please help.Goto Database and Set Location and set the path
Do verify Database also

SQL database- into-visual-table-construction

Hello,
First, thanks in advance for your time.
I would like to be able to turn my tables, already designed in SQL server,
into Entity-Relationship diagram so that i can visualize them. In other words
to get a ER model from my tables. Is there any tool that i can do this with?
- any other suggestions? -
thanks and best regards,
Siavash Solati
Sia_Canada wrote:
> Hello,
> First, thanks in advance for your time.
> I would like to be able to turn my tables, already designed in SQL
> server, into Entity-Relationship diagram so that i can visualize
> them. In other words to get a ER model from my tables. Is there any
> tool that i can do this with? - any other suggestions? -
> thanks and best regards,
> Siavash Solati
Most ER tools will reverse-engineer a database into a physical model,
including relationships if they're defined with primary and foreign
keys. Microsoft Visio will do this (in some editions). There are also a
slew of other tools that can do this as well: ERWin, System Architect
(if that's still around).
David Gugick
Imceda Software
www.imceda.com