2.10 FAQ-418 How do I open and manipulate a MySQL Database inside Origin?

Last Update: 7/29/2015

Origin uses ADO to access a database. We have prepared a Tutorial on how to Import Data from a Database on our website.

There are some built-in OLE DB Providers in Windows, so you can use them directly and connect to a database like Oracle, SQL Server. However, for other databases like MySql, you can use the ODBC driver in the ADO tool if you do not have access to an appropriate OLE DB Provider. To set up the connection:

  1. First, you will need the MySQL Connector/ODBC on the computer you intend to connect to the database, which you can get from the MySql website.
  2. The next step is setting up your ODBC connection. Open the Windows Control Panel and the "Administrative Tools" folder. (Vista users may have to switch to "Classic View" in order to see this file path) Double-click on the icon "Data Sources (ODBC)." Click on the "Add..." button. Give your data source a memorable name and test the connection before saving.
  3. Open the ADO tool by selecting Files: Database Import: New from main menu or clicking on Query Builder Button Open Query Builder.png or SQL Editor Button Open SQL Editer.png button on the toolbar. In the Query Builder, create a new data source by clicking Query: Data Source: New. In the Provider tab, select Microsoft OLE DB Provider for ODBC Drivers and click Next. Select the ODBC data source you just defined, enter passwords and select an initial catalog. Click OK, you will see tables on the right pane of Query Builder. (In the SQL Editor , select File: New to open the Data Link Properties dialog, do the same settings. )

Keywords:importing, ODCB, connector, Query, database, Oracle, MySql, SQL Server