HOW TO CREATE MYSQL ODBC CONNECTION

 
PROCEDURE

1. Install mysql-connector-odbc-5.1.5-win32 to your computer. The location of this executable file is at \\Cadpn06\CADPI-R\ExecPortal.

2. Create the ODBC Connection through Start > Control Panel > Administrative Tools > Data Sources(ODBC)
3. Choose System DSN tab, click Add.., choose from the driver MySQL ODBC 5.1 Driver, then Finish.
4. In MySQL Data Source Configuration, use the following information:
Data Source Name: mysql_portal
Server: 192.168.0.22
Port: 3306
Password: 4321
Database: dbportal3
First | Previous Next