How can I migrate CR report from one database to another?

[Gennady]

I need to migrate CR report from Informix database with custom OLE DB provider to report based on Crystal Data Objects (with .TTX files). The structure of tables and fields is the same. I've removed all references on previous database and added new live references. But in VB runtime (not in CR designer) I am receiving error "Error in database DLL". What does it mean? How I can find and destroy hidden reference on previous database?

 

[mauriceb]

Did you try Database|Convert Database Driver and then select pdsmon. It will ask you what kind of active dataset you want and you can select data definition and then it should work.

Maurice

 

[kenhamady]

This is the rigth answer, but this will only work if your original data is configured as one 'table' from Crystal's perspective. If Crystal sees two or more tables, it will create/require a TTX for each one, and then you will need a separate recordset for each TTX when you get to the app.

If, however, your OLEDB is a flat resultset, Crystal will convert it to a single TTX, and you will be able to pass it a single recordset. Ken Hamady

http://www.kenhamady.com/