<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ rootadoname ] failed in the evaluation of <p> You can use the SQL Gateway from the ODBC Driver for [service] to query [datasource] through a MySQL interface. Follow the procedure below to start the MySQL remoting service of the SQL Gateway and work with live [datasource] in MySQL Workbench. </p> <h2>Connect to [service] [datatype]</h2> <p>If you have not already done so, provide values for the required connection properties in the data source name (DSN). You can use the built-in Microsoft ODBC Data Source Administrator to configure the DSN. This is also the last step of the driver installation. See the "Getting Started" chapter in the help documentation for a guide to using the Microsoft ODBC Data Source Administrator to create and configure a DSN. <br> </p> [extraconnectionnotesodbc|def('[extraconnectionnotes|def("")]')] <h2>Configure the SQL Gateway</h2> <p> See the <a href="../articles/sqlgateway-overview.rst#setup">SQL Gateway Overview</a> to set up connectivity to [datasource] as a virtual MySQL database. You will configure a MySQL remoting service that listens for MySQL requests from clients. The service can be configured in the SQL Gateway UI. </p> <p><img src="../articles/odbc-mysql-apps-script-1.png" title="Creating a MySQL Remoting Service in SQL Gateway (Salesforce is shown)"></img></p> <h2>Query [service] from MySQL Workbench</h2> <p> The steps below outline connecting to the virtual [service] database created in the SQL Gateway from MySQL Workbench and issuing basic queries to work with live [datasource]. </p> <h3>Connect to [service] through the SQL Gateway</h3> <ol> <li>In MySQL Workbench, click to add a new MySQL connection. <li>Name the connection (CData SQL Gateway for [service]). <li>Set the <b>Hostname</b>, <b>Port</b>, and <b>Username</b> parameters to connect to the SQL Gateway. <li>Click <b>Store in Vault</b> to set and store the password. <li>Click <b>Test Connection</b> to ensure the connection is configured properly and click <b>OK</b>. </ol> <img src="../articles/odbc-mysql-workbench-1.png"/> <h3>Query [service] [datatype]</h3> <ol> <li>Open the connection you just created (CData SQL Gateway for [service]). <li>Click File -> New Query Tab. <li>Write a SQL query to retrieve [datasource], like <var>SELECT * FROM `CData [rootadoname] Sys`.[extable];</var> </ol> <img src="../articles/odbc-mysql-workbench-2.png"/> <p>With access to live [datasource] from MySQL Workbench, you can easily query. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/sqlite-odbc-mysql-workbench.rst