procedure to create mysql datasource name i.e., using type 1 driver.........

procedure to create mysql datasource i.e., using type 1 driver.........

1)keep and install odbc driver for mysql(mysql odbc driver)
2)create DSN for odbc driver for mysql pointing to one or other logical db.

control panel-->performance & maintanance-->Administration tools-->data sources-->userdsn-->add-->mysql odbc driver-->finish.

datasourcename------mysqldsn
host/server name----localhost
database name------- give created logical db name
user----------------root
password------------root
port no-------------3306


------> Test Datasource object--->ok