Hi all,
I had a VB6 program that opens a remote asp page as an ado recordset. The asp page connects to the remote db, gets some records and return them.
Should I do the same in .Net or is there a better alternative to retrieve data from a remote db. Note: webservices are not an option
Thanks,
Ivan
Hi Ivan,
Did your Database is exposed on the web?
e.g. We can install SQL server at machine A, but our client at machine A can connect to it directly.
If no, we have to build an application which will retrieve data from the DB and pass to the client.
For .NET, we can do that in ASP.NET, but if you want to build your asp.net application in such way, it is a Web Service application. So we can build it as a Web Service directly.
Did you have any concern, please feel free to post here.
If I misunderstood, please feel free let me know.
Best regards,
Peter Huang
Ivan, Ive done the same as you in ASP and sometimes now in .Net - a webservice is not always the best way...
My suggestion would be to get your data (on the webserver side) into a dataset and use the GetXml() method to convert the dataset to a string which can then be transmitted back to the client and reused there. Hope that helps!
