我需要在我的计算机上本地运行客户端的软件,并让它通过 VPN 链接(Team Viewer VPN)连接到实时数据库,这样我就可以将调试器附加到客户端软件并找出客户端遇到的一些问题。
当客户端网络上的任何计算机连接时,它都可以正常工作。这是驱动程序调试信息的输出。
Sun Aug 05 2012 15:06:10
15:06:10 CONN: Application information:
15:06:10 "HOST=WORKSTATION36;OS=Windows XP Build 2600 Service Pack 3;PID=0x11a0;THREAD=0xdcc;EXE=C:\abba\dbisqlc.exe;VERSION=7.0.4.3472;API=DBLIB"
15:06:10 CONN: Attempting to connect using:
UID=abdbo;PWD=*****;DBN=abba;ENG=abba;ASTOP=YES;DBG=YES;LOG=C:\log\odbcLog.txt;DMRF=NO;LINKS=TCPIP{}
15:06:10 Trying to start TCPIP link ...
15:06:10 Loading wsock32.dll
15:06:10 Loading ws2_32.dll
15:06:10 TCP using Winsock version 2.0
15:06:10 My IP address is 192.168.0.111
15:06:10 My IP address is 127.0.0.1
15:06:10 TCPIP link started successfully
15:06:10 Trying 192.168.0.2:2638
15:06:10 Found database server abba on TCPIP link
15:06:10 Client connected
15:06:10 CONN: Connected to the server
15:06:10 [1174510859] CONN: Connected to database successfully
15:06:10 [1174510859] Client disconnected
但是,如果我尝试使用我的 VPN 链接进行连接,则它不起作用。
Sun Aug 05 2012 17:13:26
17:13:26 CONN: Application information:
17:13:26 "HOST=CONVERSIONVM;OS=Windows 2003 Build 3790 Service Pack 2;PID=0x878;THREAD=0x98c;EXE=C:\abba\dbisqlc.exe;VERSION=7.0.4.3472;API=DBLIB"
17:13:26 CONN: Attempting to connect using:
UID=abdbo;PWD=*****;DBN=abba;ENG=abba;ASTOP=YES;DBG=YES;LOG=C:\log\odbcLog.txt;DMRF=NO;LINKS=TCPIP{}
17:13:26 Trying to start TCPIP link ...
17:13:26 Loading wsock32.dll
17:13:26 Loading ws2_32.dll
17:13:26 TCP using Winsock version 2.0
17:13:26 My IP address is 7.192.193.89
17:13:26 My IP address is 10.0.1.106
17:13:26 My IP address is 127.0.0.1
17:13:26 TCPIP link started successfully
17:13:26 Looking for abba
17:13:26 I am in a class A network
17:13:26 Sending broadcast
17:13:26 Using broadcast address of: 7.255.255.255:2638
17:13:26 I am in a class A network
17:13:26 Sending broadcast
17:13:26 Using broadcast address of: 10.255.255.255:2638
17:13:26 I am in a class A network
17:13:26 Sending broadcast
17:13:26 Using broadcast address of: 127.255.255.255:2638
17:13:27 No reply received
17:13:27 Resending
17:13:28 No reply received
17:13:28 Resending
17:13:29 No reply received
17:13:29 Resending
17:13:30 No reply received
17:13:30 Resending
17:13:31 No reply received
17:13:31 CONN: Cannot connect
我认为可能存在问题的几个问题是 Team Viewer 希望我通过其特殊 IP 路由流量,而广播不通过它传输。我尝试告诉 TCP/IP 链接使用服务器的 VPN 的 IP 和端口,但这也没有解决问题
Sun Aug 05 2012 17:29:29
17:29:29 CONN: Application information:
17:29:29 "HOST=CONVERSIONVM;OS=Windows 2003 Build 3790 Service Pack 2;PID=0x13c;THREAD=0x810;EXE=C:\abba\dbisqlc.exe;VERSION=7.0.4.3472;API=DBLIB"
17:29:29 CONN: Attempting to connect using:
UID=abdbo;PWD=*****;DBN=abba;ENG=abba;ASTOP=YES;DBG=YES;LOG=C:\log\odbcLog.txt;DMRF=NO;LINKS=TCPIP{IP=7.192.141.131;PORT=2638}
17:29:29 Trying to start TCPIP link ...
17:29:29 Loading wsock32.dll
17:29:29 Loading ws2_32.dll
17:29:29 TCP using Winsock version 2.0
17:29:29 My IP address is 7.192.193.89
17:29:29 My IP address is 10.0.1.106
17:29:29 My IP address is 127.0.0.1
17:29:29 TCPIP link started successfully
17:29:29 Looking for abba
17:29:29 I am in a class A network
17:29:29 Sending broadcast
17:29:29 Using broadcast address of: 7.255.255.255:2638
17:29:29 I am in a class A network
17:29:29 Sending broadcast
17:29:29 Using broadcast address of: 10.255.255.255:2638
17:29:29 I am in a class A network
17:29:29 Sending broadcast
17:29:29 Using broadcast address of: 127.255.255.255:2638
17:29:29 Trying 7.192.141.131
17:29:29 Trying 7.192.141.131
17:29:30 No reply received
17:29:30 Resending
17:29:31 No reply received
17:29:31 Resending
17:29:32 No reply received
17:29:32 Resending
17:29:33 No reply received
17:29:33 Resending
17:29:34 No reply received
17:29:34 CONN: Cannot connect
Trying 7.192.141.131
我确实注意到的一件事是,尽管我明确告诉它使用该端口,但该端口并未列出,并且工作日志中的同一行显示该端口包含在内Trying 192.168.0.2:2638
。
客户端和服务器上的防火墙都被禁用,因此问题与此无关,我认为这是因为没有设置端口号,但我不知道我做错了什么导致它没有被设置。
这是使用 Adaptive Server Anywhere 7.0 驱动程序。