Hi All,

I am using an ASP page where I am fetching data from my local Oracle database. Now with a click of a SUBMIT Button I need to insert this data into SQL Server database located in a Remote Web Server. How can I do this?

Picking data from local Oracle Database is not a problem. Inserting it into Remote SQL Server Database is a problem. How to form a Connection String that I can use to insert data into remote SQL Server Database.

Can some one help me out. I need sample Connection strings to test it at my end.


Any help on this will be highly appreciated.

http://www.carlprothman.net/Default.aspx?tabid=81

especially:

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForSQLServer

Scroll down to "To connect to SQL Server running on a remote computer (via an IP address)"

Thanks A Lot !!!!