jj1103
asked on
Connect SharePoint 2010 to external MySQL Database
I am new to SharePoint. I need to build a SharePoint page using Designer to display data from a MySQL database located on another server. Everything I have tried doesn't work/ doesn't connect.
1. MySQL Driver 5.1 has already been installed
2. DSN name and connection has been created and tested (DSN=myDSN)
3. I've gone through SharePoint Designer to “Data Sources” on the left Navigation pane. Clicked on “DataBase Connection” at the top ribbon....
4. I've entered just DSN=myDSN (Doesn't work)
5. I've entered connection string (didn't include actual info): DSN=MyDSN;Driver={MySQL ODBC 5.1 Driver};database=training; option=0;u id=root;pw d=pas2;por t=3306;ser ver=ipaddr esshere; (Doesn't work)
6. I've restarted the server too.
1. MySQL Driver 5.1 has already been installed
2. DSN name and connection has been created and tested (DSN=myDSN)
3. I've gone through SharePoint Designer to “Data Sources” on the left Navigation pane. Clicked on “DataBase Connection” at the top ribbon....
4. I've entered just DSN=myDSN (Doesn't work)
5. I've entered connection string (didn't include actual info): DSN=MyDSN;Driver={MySQL ODBC 5.1 Driver};database=training;
6. I've restarted the server too.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi, I keep getting this error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ASKER
After fiddling around with the code from the link I got it to work! Thanks for the link, abhitrig!
After fiddling around with the code from the link I got it to work! Thanks for the link, abhitrig!
Hello,
How do you solve it? How can i connect to the mysql database??
ASKER