Please help

[Bhaskardeep Khaund]

Hi,

I am creating a site on ASP and SQL, which would essentially be hosted in a
third party server like Interland or Net4India. It is dynamic in nature,
i.e. has its own database. But I have got a module in where I would need to
connect to an remote SQL server, which is located somewhere else. I know the
IP address. I would need to copy a table from that sql server to my server,
and synchronize it regularly, just in case something is updated.

Now my problem is,

(1) How do I connect to that remote sql server using ASP.
(2) Please suggest what method should I adopt to copy and synchronize the
data between the two servers.

Thank you very much,

Regards,
Bhaskardeep

 

[xxxxx]

On Sun, 11 Apr 2004 02:06:13 +0530, "Bhaskardeep Khaund"

These guys have GREAT information. Type the link exactly as it is
below.

http://www.able-consulting.com/MDAC/ADO/Connection/Recordset_URL.htm#AdoUrlConnectionADORecordset

It may be that your solution is on another page in a parent
directory... check the information to see if it is appropriate.

Basically, you have a problem that I wanted to solve when using two
.mdb files on two different web servers: one here in the lab and one
hosted somewhere else.

I think your solution is easier. On win2000 create an empty file on
the desktop called "test.udl" and double click it ... then use the ip
of the server you want to connect to, and choose the SQL server
provider. Rename the file to "test.txt" then look at the text. That
is your connection string.

Connect to the server from the ASP script, then execute a select * on
the table...get the recordset and run a loop to see which Id_ fields
are not in your current table and update or insert appropriately.

check out that web site above.

 

[Bob Barrows]

Hi,

I am creating a site on ASP and SQL, which would essentially be
hosted in a third party server like Interland or Net4India. It is
dynamic in nature, i.e. has its own database. But I have got a module
in where I would need to connect to an remote SQL server, which is
located somewhere else. I know the IP address. I would need to copy a
table from that sql server to my server, and synchronize it
regularly, just in case something is updated.

Now my problem is,

(1) How do I connect to that remote sql server using ASP.

For the correct connection string, see www.able-consulting.com/ado_conn.htm.
You should concentrate on the OLEDB provider connection strings rather than
the ODBC strings.

(2) Please suggest what method should I adopt to copy and synchronize
the data between the two servers.

You should not involve ASP in this process. This is a task which should be
done via SQL Server functionality. You have two options:
1. Replication
2. Log Shipping

You should look these topics up in Books Online (BOL) - SQL Books Online
should be found in the SQL Server program group in the Windows Start menu.
If it is not there, you can download them from this url:

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

These topics cannot be taught via newsgroup posts. You need to educate
yourself by reading BOL, then, if you have questions, post to the
appropriate SQL Server newsgroups.

Bob Barrows

PS. I see you've multiposted this to .asp.db, which is the more appropriate
group. So I've cp'ed this reply so it will appear in both groups. Please use
one group in the future.