unable to establish a database connection

[Chasidy]

I have created a report in Crystal 9 Developer's Edition. The report is based of an internal ODBC (RDO) query which was initially set to use "SAMPLE" SQL Anywhere database. Everything seems fine.
Tried to run the report through a different application using Crystal runtime files. This application is connected to "BIGDATA" SQL Anywhere database.
When running the report -
If the "SAMPLE" database server is running, the report will pull from the "SAMPLE" database instead of "BIGDATA".
If "SAMPLE" is down, I get Unable to establish database connection error.
This does not happen if you connect to an ODBC database using the tables directly where I can run the report and it will correctly pull from "BIGDATA".
Has anyone else experienced this problem? ANd if so, how did you fix it?
Thanks.
cj

 

[synapsevampire]

How are you resetting the connectivity to the new database?

-k

 

[Chasidy]

We have another program which uses the crystal runtime files and runs the crystal reports. when you log into the other program, you need to choose a database. This connection then gets passed to crystal when reports are run from this program. (I think this is what you are asking).

 

[Chasidy]

I found out that the query I am attached to says the database type is OLE DB (ADO) when it should be ODBC (RDO). I deleted the existing query and created a new one, pointing to an ODBC database, and now it works fine. Not exactly sure how you can create an ADO query when your report is connected to an ODBC database but that's beside the point. This workaround works.