• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4692
  • Last Modified:

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;uid=root;pwd=pas2;port=3306;server=ipaddresshere;  (Doesn't work)

6. I've restarted the server too.
0
jj1103
Asked:
jj1103
  • 3
1 Solution
 
jj1103Author Commented:
Would it be possible to make this work by installing MySQL OLE DB Provider?
0
 
jj1103Author Commented:
Hi, I keep getting this error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
 
0
 
jj1103Author Commented:
After fiddling around with the code from the link I got it to work!  Thanks for the link, abhitrig!
0
 
marvinedvCommented:
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??
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now