Database Connection String

Can u send me a sample connection stringto connectMS SQL SERVER 2000 to MS SQL SERVER 2005 Reporting?

Lets say the datbase name istest

 

Thanks a lot, I will try those link right now. The server hasn't allowed me to use the 2005 reporting yet. I will wait till they enable it since I cannot see any reporting option after I logon.


In the mean time It be a big help if anyone cansend one sample report that run atleast 2 to 3 sql to populate the data. We just want to sample code and build the code on our page.


Thanks

 

If you are using Visual Studio 2005,you can find a 'Report Server Project Wizard' under 'Business Intelligence Projects' which you can use to create reports just in a few steps.

Other useful links:

See: http://kb.discountasp.net/default.aspx?cNode=8Q7S2C&pNodes=2C5H0J:1P4K0H:6E0U3I

See:http://community.discountasp.net/default.aspx?f=24&m=17595 to know more about the reportviewer control[used to render reports to your web applications ] (w/ a sample web application using the reportviewer control)

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

MS SQL 2k/2k5 connection string details are available on the MS SQL 2000/2005 Manager
i.e https://my.discountasp.net/mssql2005-manager.aspx and https://my.discountasp.net/mssql2005-manager.aspx respectively.

Vikram

DiscountASP.NET
www.DiscountASP.NET