How to Setup ODBC MySQL Driver

Аватар автора
MySQL Вдохновение
What is ODBC? Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database. By using ODBC statements in a program, you can access files in a number of different databases, including Access, dBase, DB2, Excel, and Text. How to Setup MySql ODBC driver Note Before Doing this You need to Download this all the things which are mention below in steps. Download Wamp Server From Here Step 1 Downloading Required Drivers for ODBC Choose Version According to Your System I will use windows driver. Step 2 Installation Run The Setup and Install the Driver. Step 3 System Settings After Install We need to configure the connection. For that Go to Control Panel Then Go Administrative Tool and Then ODBC Data Source. Step 4 ODBC Data Source Go To System DSN Tab and Click on Add Now Add "MYSQL ODBC 5.3 ANSI Driver" (This is Suitable for My System So, I select It) then Click on Finish. After Click it. A popup will open of My SQL Connector/ODBC. Step 5: My SQL Connector/ODBC POPUP Put there Datasource name, Description and your TCP/IP server as &port as &User as &select database and you get the list after clicking on the test and you get the message &Successful&It means Database connected successfully. For More Videos Subscribe It and Like It.

0/0


0/0

0/0

0/0