Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 graphdata is the name of the ODBC connection and I have to shift that to MySQL server. Please help. If I'm trying to change it manually in the Source it is howing access denied, but the rproblem is it is not asking for password, so Don't know how to proceed. Please help 

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago
    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.
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.....