View Single Post
  #1 (permalink)  
Old May 29th, 2006, 11:42 PM
exkgb exkgb is offline
Registered User
 
Join Date: May 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Microsoft Reporting Services and mySQL

Hi,
    Due to a lack of a powerful open source reporting solution, I'm trying to get MS SQL server 2005 reporting services to work with MySQL database. from the datasource dialogue, I've tried to use the following connection string

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;PASSWORD=myPassword;OPTION=3;"

to try to connect to my local mysql database but this gives me an error. I've installed the my ODBC drivers from mySQL website. Is there anything I must do in order to register the .dll files which comes with my ODBC with the reporting services? Is is possible that I can use the mySQL connector.net with reporting services instead of ODBC due to performance concersn?

Has someone done this and could you tell me the exact steps I need to take in order to make this work. Thanks for your attention

Reply With Quote