Forum Discussion
changing data source without changing the set visualization and tables cleansed
Hi All, is there any possible way to change the data source of a report I have created using ODBC connection to the MySQL database server. As you can see in the picture the connection is DSN and gra...
Create a query that connects to your new source. Use Advanced Editor to copy the Source and possibly Navigation lines. Go to your old query and open Advanced Editor. Replace the lines in that query with your copied ones.
Hi Greg, tried with adv query as suggested by you. Earlier was going with direct changes in the Applied Steps> Source. Still didn't workout. I got the error ODBC: ERROR [HY000] [MySQL] [ODBC 8.0(a) Driver] Access Denied for user 'root'@'10.....