Skip to Content
0
Oct 31, 2019 at 11:34 AM

Data Source Change not reflected in SQL

53 Views

Using Crystal Reports v13. We typically develop our crystal reports in our DEV environment and then move the report to our other environments. Once moved we update the data source to the new environment. Each of our 6 environments has its own Oracle 12g database.

I read in one answer to update each table instead of just the connection. I tried that and it still didn't seem to update the data source. That's based on me looking at the SQL after I've finished the update.

Also tried the log on and log off server, logging off each server and then on to only the correct server.

Have also tried the verify database, but this seems to say it's verified. Also, tried creating a new connection, but again no luck.

So, HOW do I change my datasource location to reflect the correct one?