What I mean "connect to SQL server directly" is "every workstation connect to SQL server via ODBC, they have no cursors/tables stored inside.". I can't use same method in the branch of China. The question is how can I update the data inside SQL server when my local cursors/tables have new data.

Sunny

>>We are expanding our computer system to the branches in China. We decided to use SQL6.5 to store the database. I have a problem on updating data in SQL6.5
>>
>>Normally, we connect to SQL server directly. We haven't got serious problem. Connecting to China branches in full office time is impossible because IDD fee is too expensive.
>>
>>We plan to use dial up network to connect the branches and update their database once a day. But, I am a new user of SQL. Could anyone tell me how to do that?
>>
>Sunny
>
>Hi
>
> There is an option for the network setting in SQL Server ODBC setup.
>Specify TCP/IP address of your network and should work.
>
>
>Bye