Software >> Services >> RDBMS >> MySQL >> How to define Connection string for MYOLEDB for MySQL

Provider=MySQLProv; Data Source=xxx, where xxx is "server=<server name>;DB=<database name>" eg. in perl $Conn->Open("Provider=MySQLProv; Data Source='SERVER=nms2;DB=nms;UID=root;PWD=password;PORT=3306'");