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 |
|
bobby_xcm
Starting Member
2 Posts |
 Posted - 2005-02-02 : 00:33:47
|
| Hi,Can any one help me out to know whether it is possible to connect to sybase database from SQL Server 2000 Reporting services to fetch data and generate reports instead of the built in SQL Server database? If possible mention any site which has info on this.Thanking you in advance.Regards,Bobby |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-02 : 12:33:33
|
| Yes you can do that. You just need an ODBC driver to get to the Sybase database server. Then in Reporting Services, setup your data source so that it points to the Sybase ODBC driver which points to the Sybase database server.You can't however put the Reporting Services databases on Sybase; those must be on MS SQL Server.Tara |
 |
|
|
bobby_xcm
Starting Member
2 Posts |
Posted - 2005-02-02 : 23:06:13
|
| Tara,Thank You for the information.Regards,Vijay |
|
|
|
|
|
|
connecting to sybase database from SQL Server 2000