Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 7th, 2009, 12:59 AM
Friend of Wrox
 
Join Date: Apr 2005
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
Question Synchronizing local database with Remote Database

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.
 
Old July 7th, 2009, 02:30 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

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)"
 
Old July 8th, 2009, 03:01 AM
Friend of Wrox
 
Join Date: Apr 2005
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks A Lot !!!!





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting to database on a local pc yogeshyl Oracle 0 November 3rd, 2007 02:12 AM
A Better way to sync a remote and local database? kevorkian SQL Server 2000 1 April 5th, 2005 08:09 AM
Using DTS to sync Remote Database to Local Machine kevorkian SQL Server DTS 1 March 21st, 2005 11:13 PM
Synchronize a remote and local database - MAYBE??? kevorkian SQL Server 2000 3 March 8th, 2005 02:00 PM
transfer local database to web server laptop SQL Server 2000 1 April 22nd, 2004 05:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.