Reach SqlServer located another server

Hi,

I have a asp.net website and bind it with sqlserver but this sqlserver is located another server different from the server my website is located. So how can i bind them with eachother.

Thanks in advance...

Fine, just specify that server name (which is diffrent than the server where your web application in) in the connection string:

Server=YourDatabaseServerName;Database=YourDatabaseName;User ID= YourUserID; Password=YourPassword

Check out his for more examples:www.connectionstrings.com

Good luck.

|||

Thanks my friend but i am sorry i forgot to ask my another question about how to connect database if it is different from sqlserver (i mean it can be oracle or something else) located another server.

Thanks in advance again...!

|||

Just visit the link I posted:http://www.connectionstrings.com/

and click on the database that you are using (e.g. Oracle -> usehttp://www.connectionstrings.com/?carrier=oracle ).

Good luck.

RDL to RDLC Dataset Bind Question

We got some existing Reports that are set to RDL files but now they want to be able to create a web user interface so the user can interact through such method. As I am finding out, these reports need to be converted to RDLC so that they can all the proper information so they can be binded. My question is, the datasets are already set (I beleive it's the .rdlc.data files) on the RDL solution project. Now I want transfer those DataSets to my Website project and bind those datasets to my Report Viewer Control. Is that the right approach? Or do we have to re-create the Datasets and then bind? Can I use Web Services to bind to these reports? Thanks for the input and all help is appreciated.

there is no need to do this what you need to do is to just deploythose reports on the reporting server then create web page and addreport viewer control to it to enable the user view the reports youdeveloped you can see this example to know how to do this

http://www.c-sharpcorner.com/UploadFile/asif.blog/DynamicDataGrouping08042006115320AM/DynamicDataGrouping.aspx

http://www.gotreportviewer.com/