p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2005 (http://p2p.wrox.com/forumdisplay.php?f=220)
-   -   Reporting Services with MySQL (http://p2p.wrox.com/showthread.php?t=43187)

exkgb May 29th, 2006 10:39 PM

Reporting Services with MySQL
 
Hi,
    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.



All times are GMT -4. The time now is 09:12 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.