Connectivity with remote server databse.

Closed
Digvijaysinh Posts 10 Registration date Tuesday January 27, 2009 Status Member Last seen July 6, 2009 - Feb 19, 2009 at 07:47 AM
Lynesus Posts 1 Registration date Saturday December 26, 2009 Status Member Last seen December 31, 2009 - Dec 31, 2009 at 10:19 PM
Hello,
hello every body,
is there any mechanism in visual studio 2005 and c# to copy the remote server table and update the local database table with that copied table,
please guide me in this topic, step by step to accomplish it, if no than please suggest me what i have to do for this in c# window application.
i have sql server 2005 database at local and remote server.
thanx in advance!

2 replies

Lynesus Posts 1 Registration date Saturday December 26, 2009 Status Member Last seen December 31, 2009 5
Dec 31, 2009 at 10:19 PM
Hi!
I have a problem regarding to my thesis application. I used Visual Basic 6 as my PL and MS SQL Server 2000 as my remote server database.
Every time I run my projects It has an error message:

Connectin Failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.

what is this error means?
Help me please....tnx
5
hi
there r many methods to backup the database
merge replication
and another is local database cache
-1
hi dear Shiva,

cn u pls guide me how to break into server2005 or replicate database pls mail me something useful tips. thanx in advance.
0