Clementine reading a database file

Source: Internet
Author: User

Read some of the online information, not very familiar with the database and ODBC, just summed up how to read.

Clementine reads the database file when the database file is in the Access database file.

The first step is to set up a data source

Win7 system, after win+r input odbcad32, an ODBC data manager appears, select Add in System DSN

Open the data source configuration and discover that only SQL Server drivers are not available.

The workaround is to:

C:\Windows\SysWOW64

Found in this directory:

Odbcad32.exe

This file, double-click Open. See on the Internet, no experiment.

Enter the name of the data source, select the database name in the database column, the database file you want to access, and this should be OK for the. mdb point.

The second step is to access the database through the data source

Select the database node in the Source tab, place it in the data flow editing area, edit, add a new database connection through the data source, connect to the new database, confirm.

Clementine reading a database file

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.