DTS Problem

Hi there !!

I am getting the error message when i try to copy SQL database tables from remote server to mine local server. I got the below mention error message when copying of the tables start after selecting the third option i.e Copy SQL Objects, from the DTS menu.

The error i am getting is...

Specify table copy or query Got error : "Failed to copy objects from microsoft sql server to microsoft sql server".

Details of the error are :

Invalid OLEVERB Structure
[Microsoft][odbc SQL Server driver][Shared Memory] General Network Error. Check your Network documentation.
[Microsoft][odbc SQL Server driver][Shared Memory] Connection Open [Preloginhandshake()]

When i opt the first options i.e. Copy SQL Tables, I am getting this error message..

[DBNET LIB][Connection Open {Preloginhandshake()}]General Network Error. Check your Network documentation.

Earlier the same setting works absolutely fine. With some reason, i have to format my hard disk and relaod the whole stuffs again. This is the begining of the error i am getting.

Can any one eloborate, what the error means and how i get rid of them? Can anyone put some lights on it ?

Any help is deeply appreciated.

With Thanks

hi, i am experiencing quite the same error.. i am running a query using query analyzer and this error statement appears. if i use a different table in my query, it works just fine. any ideas? thanks in advance.


[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.

Connection Broken



i am using ms sql server 2000