<br><b>Code</b>: rsb:print<br><b>Error</b>: Formatter [ extraconnectionprops ] failed in the evaluation of [datasource] from the JMP Query Builder. </p> <h2>Access [service] [datatype] as an ODBC Data Source</h2> <p> If you have not already done so, specify connection properties defined in the data source name (DSN).</p> <p> Below is a typical connection string: </p> <p> [extraconnectionprops] </p> <p> You can configure the DSN in the built-in Microsoft ODBC Data Source Administrator. This is the last step of the driver installation. See the "Getting Started" chapter in the help documentation for a guide to use the Microsoft ODBC Data Source Administrator to create and configure a DSN. </p> <h2>Import [service] [datatype] with the Query Builder</h2> <p> After you have created the [service] DSN, you can use SQL to invoke the capabilities of the [service] API. Follow the steps below to execute some supported queries in the Query Builder: </p> <ol> <li>In SAP JMP, click File -> Database -> Query Builder. The Select Database Connection dialog is displayed. <li>Click New Connection. <li>On the Machine Data Source tab, select the DSN. In the next step, the Select Tables for Query dialog is displayed. <li>In the Available Tables section, select a table and click Primary. <li>As you drag Available Columns to the Included Columns tab, the underlying SQL query is updated. <img src="../articles/odbc-sas-jmp-2.png" title="The generated query in the Query Builder. (Salesforce is shown.)"/> </li> <li>Click Run Query to display the data. <img src="../articles/odbc-sas-jmp-3.png" title="The results of a query in the Query Builder. (Salesforce is shown.)"/> <li>To refresh the results with the current data, right-click Update from Database and click Run Script. </ol>. The error was: The value of the attribute could not be accessed: The attribute does not exist.<br><b>URL</b>: /jp/kb/tech/ponparemall-odbc-sas-jmp.rst