Posted By Ravinder on 06/24/2009 1:38 AM
Hiii All,
I want to access data from the RMS database in my c#.net web application.
1. How can i interact with RMS database ,
2. Is there any tool available to fetch data from RMS,
3. What i required to interact with RMS database.
Thankks
I use PHP to connect to our database, using ODBC in the Data Sources (ODBC) connector in Windows 7. It's pretty much the same for xp too.
I am not sure how .NET or ASP connects to the ODBC, but I am sure there is something out there.
Here is a quick google link http://www.asp101.com/articles/john/connstring/default.asp
I haven't learned .NET yet, or ASP, because I first starting learning PHP. Typically, you can connect to the MSSQL database using PHP, but A LOT of web servers do not allow the MSSQL module to be active, but they almost always leave the OBDC module alone.
I installed XAMPP on my machine, and then set up the server to accept incoming visitors, and voila!
Here is what we did using Hero Points and RMS as a point search.
http://liverewards.dyndns.org/ndps/points.php
Basically when the user types in their customer code, it searches the database, and brings back their point total, and how much they have on their account off their next purchase.
Good luck! |