Error Message

[innu]

Hi,

I have the following query:

insert into artikel_temp
(Artikelnummer, Text1,Text2, Bildpfad, Dokumentpfad, Preis, Einheit, Status, Preismenge, Stueck, Stueck_s)

select Artikelnummer, Text1,Text2, Bildpfad, Dokumentpfad, Preis, Einheit, Status, Preismenge, Stueck, Stueck_s
from wbsrv01.hoeller_temp.dbo.artikel


The syntax of this query is correct (I'm sure) but when I want to run this query the following Error-Message comes:

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheckForData ((null)()).
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Allgemeiner Netzwerkfehler. Weitere Informationen finden Sie in der Dokume

The second Error-Message means that is a general network error.

Does anyone have an idea?

 

[rac2]

Guten Tag,

what are you using to run the query? Query Analyzer? ASP?
do other queries work?

 

[innu]

Guten Morgen,

I tried it with query analyzer, with coldfusion.

I also tried to run this query between 2 databases on one Server. This was successful.

Only when I want to interact with another server the error-message comes.

But I also tried with other queries to interact with this server. This was also successful.

Hm...... Get crazy?

We also tried to start the server again. Nothing goes!

 

[RickCole]

Hi, Have you linked the 2 servers in question from the security tab in Enterprise Manager.

Rick.

 

[innu]

Hm, i don't really know it.

How can I link them?

Another query goes, when I want to interact between these servers