I'm creating some reports with an ODBC (RDO) connection. When creating them, chosing an existing DB is mandatory. But once finished, I want that reports to work in any DB (of course, with the same ODBC DNS name) of our customers. And the problem is that design DB info is attached to my reports, making them impossible to use with other DB's.

When I enter in the "Set Datasource location" of my reports, I see that in the Properties section of my connection there is a Database entry with the name of my dessign DB. I try to delete it manually, but then an error occurs. Also, in all the entries of tables, I've this 5 rows:

1. Table Name: xxxxx (Table name)
   
2. Table Type: Tables
3. Catalog: yyyyy (Dessign DB's name)
4. Owner: dbo
5. Overridden qualified table name: xxxxx (Same as 1.)

I know that I only need rows 1,2 and 5, because rows 3 and 4 are filled with information of my dessign DB.

 ¿Does anyone know how to delete the info from that rows, so my report will work with any DB?

 
Thank you.