Comments
Sort by recent activity
I've finally solved the problem.
The problem (strangely) was the TCP/IP protocol used to communicate with the server.
The difference between my computer (the working one) and the computer of my colleague (the NOT working one) was that I had both TCP/IP and Named Pipes as client protocols while he had TCP/IP only. When I configured the server to have TCP/IP only, my computer stopped working also.
I then added Named Pipes to both the server and the clients and everything started working correctly.
It seems that the order of the protocols has a part of how fast SQL compare works. If I put TCP/IP and then Named Pipes on the clients it works faster then the other way around.
Could all this be a strange bug in SQL compare? / comments
I've finally solved the problem.
The problem (strangely) was the TCP/IP protocol used to communicate with the server.
The difference between my computer (the working one) and the computer of my col...
MDAC 2.8 sp1 ON Win SP2
If I put TCP:PAN (PAN is our servername) SQL compare tells me: "Invalid connection".
On the client the only allowed protocol is TCP/IP, on the server both TCP/IP and Named pipes are allowed.
Does SQL compare connect to the second database in a different way than to the first? The scripting of the first database goes extremly fast. / comments
MDAC 2.8 sp1 ON Win SP2
If I put TCP:PAN (PAN is our servername) SQL compare tells me: "Invalid connection".
On the client the only allowed protocol is TCP/IP, on the server both TCP/IP and Named p...
Any news? Is there any log I can send you for you to investigate this problem? / comments
Any news? Is there any log I can send you for you to investigate this problem?
I have ISA 2004, and in the configuration/networks node I have a Local Host entry.
I remind you that the problem is with 1 machine we have. The other works fine. And with the machine that does not work, the first database is scripted correctly, the second database fails.
Both machines are WinXP SP2, with all the WindowsUpdate patches installed; DHCP, Microsoft Firewall client for ISA 2004, in the same location, in the same domain. / comments
I have ISA 2004, and in the configuration/networks node I have a Local Host entry.
I remind you that the problem is with 1 machine we have. The other works fine. And with the machine that does not ...
I can see that I have versions v1.0.3705, v1.1.4322 and v2.0.50727 installed. How can I find out the exact version as you specified it? / comments
I can see that I have versions v1.0.3705, v1.1.4322 and v2.0.50727 installed. How can I find out the exact version as you specified it?
I have installed .NET Framework 1.1 SP1
mscorcfg.dll -- v1.1.4322.573
mscordbc.dll -- v1.1.4322.2032
On internet i found out that .Net Framework SP1 doesn't change version of
mscorsfg.dll file. There are many articles about it so I'll read little more before I post an answer. / comments
I have installed .NET Framework 1.1 SP1
mscorcfg.dll -- v1.1.4322.573
mscordbc.dll -- v1.1.4322.2032
On internet i found out that .Net Framework SP1 doesn't change version of
mscorsfg.dll file. The...
Yes, it is configured like that. I've noticed that when SQL compare hangs, IE also hangs.
Let me explain: I run SQL compare and the scripting begins, then after a while it hangs. If I open IE at that moment and try to go to our intranet site (hosted on the same server where our SQL server resides) the answer I receive is: The page cannot be displayed.
When I turn off SQL compare after the hanging, the page in IE is displayed correctly.
Any ideas? / comments
Yes, it is configured like that. I've noticed that when SQL compare hangs, IE also hangs.
Let me explain: I run SQL compare and the scripting begins, then after a while it hangs. If I open IE at th...
SQL compare is installed on my Windows XP SP2 Workstation (AMD Athlon XP 2100+, 512 MB RAM). I think the problem is network related.
I’ve tried installing SQL compare on the server and I then compare the databases locally. I successfully compared several databases without any problem.
I emphasize that the problems started when I installed Windows SBS 2003 SP1 on my server. Windows SBS 2003 SP1 includes Win 2003 SP1. Before that I had no problems. / comments
SQL compare is installed on my Windows XP SP2 Workstation (AMD Athlon XP 2100+, 512 MB RAM). I think the problem is network related.
I’ve tried installing SQL compare on the server and I then com...
Do you mean the SBS server or the SQL server? / comments
Do you mean the SBS server or the SQL server?