Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Could not export certain tables to the database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-10 : 07:57:23
angeline tee writes "Could not export certain tables to the database.

The Error message goes as

Create Table
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).

Copy Data
[Microsoft][ODBC SQL Server Driver]Communication Link Failure

The table consists of 34 fields in it.

I tried to export only the structure if the table removing all the data from it but still it shows the same message.

Looking for a solution from u."

KnooKie
Aged Yak Warrior

623 Posts

Posted - 2003-10-10 : 08:02:58
Where are you exporting it from / to ?


====
Paul
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-10 : 12:32:46
Are you exporting the table to another server? If so, the error is related to the connection to that server. Can you successfully register the destination server in Enterprise Manager?

Give us some more information and we'll help you out.

Tara
Go to Top of Page
   

- Advertisement -