I made a application in ASP.net for internal use. It asp.net and it use a microsoft SQL server 2005 for the databases.
Almong others table in my database, i have a Client table. But we got a application call saleplaces to deals with those kind of things. I dont really know this application (for now) but i know it run on lotus notes. here a link for that application
So, i want to replace my "Client table" with some kind of link to that application.
I though of 3 solution, in order of interest.
- The best way whould be if i could have a datatable in my dataset (the .xsd file).
- The second one whould be if i could have a linked server on the MS SQL server to conect to lotus notes.
- The third (and as a last resort) whold be to find a way to update (automaticly please) the SQL "Client table" whith the lotus notes database.
So, What I need to apply one of those solutions?