Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-09-23 : 12:02:01
|
| We have MYsql database, I was wondering if we can use reporting services 2005 to create reports against MYSQL database. Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-23 : 12:47:45
|
| you can. Add the MySQL db as a linked server to sql db and then use four part naming convention to address tables in it.You can include a query with them as datasource for your reports and display data. |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-23 : 18:41:02
|
| Can it also work if you just create an ODBC shared data source without having to use the linked server? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-23 : 18:47:27
|
quote:
Originally posted by dexter.knudson
Can it also work if you just create an ODBC shared data source without having to use the linked server?
Either you have to specify on Data sources with OPENDATASOURCE or Linked Server with Provider. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-09-24 : 09:50:33
|
| Just to confirm, We only have MYSQL database, so just by creating ODBC connectivity against MYSQL database we can create reports using MS SQL server Reporting services 2005 right? And we do'nt need to have SQL Server right? Do we need any kind of special ODBC driver to be installed in order to create reports using reporting services? Thx! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Reports with MYSQL database